of course yes... On 4/29/10, Amiyo Biswas <amiyo.bis...@gmail.com> wrote: > Ok, if you use formatting features, it's handier than formulas. Isn't it? > Best regards, > Amiyo Biswas > Cell: 91-9433464329 > > ----- Original Message ----- > From: "Zujar Shabbir Kanchwala" <zujarbri...@gmail.com> > To: <accessindia@accessindia.org.in> > Sent: Thursday, April 29, 2010 12:32 AM > Subject: Re: [AI] EXCEL FORMULA > > >> If I understand it correctly, specifying 2 in the Number of Decimal Places >> spin box is equivalent to the round() function with 2 as second argument. >> Let me make it clear that both these methods would not change 9.49 or 9.50 >> (numbers with 2 decimal places) if you want 2 decimal places in the >> result. >> If you opt for 1 decimal place, 9.49 wull yield 9.5 by both methods. Also >> it >> is not necessary to specify a cell name as the first argument of the >> round() >> function. You would not need two cells if you specify the number itself as >> the first argument of the round() function. >> >> hth... >> >> Best Regards, >> Zujar... >> >> An optimist laughs to forget, whereas a pessimist forgets to laugh! >> >> >> -----Original Message----- >> From: accessindia-boun...@accessindia.org.in >> [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Amiyo Biswas >> Sent: Wednesday, April 28, 2010 8:01 AM >> To: accessindia@accessindia.org.in >> Subject: Re: [AI] EXCEL FORMULA >> >> Hello, >> >> Thanks to all of you for discussion on formulas. I think, I failed to make >> my question clear. When we are using formulas, we have to use two cells, >> cell A1 for entry of value, B1 for display of value, for instance. I was >> looking for a format option which can solve the problem. >> >> Let me explain it further. Suppose, you write 9.03 in cell a1. Now press >> ctrl+1 for format cell dialogue box, select number category and enter 0 in >> the number of decimal places. This will yield 9 in the same cell A1. Now >> write 9.53 in cell A1 and you will get 10 since you have 0 decimal place >> in >> the number format box. Experiment it with 9.49 and 9.50 and notice that >> the >> values displayed are 9 and 10. >> >> My question is, this is an easy alternative for the formula >> =ROUND(A1,0) >> >> Can you suggest any format option for an alternative to >> =ROUND(A1,2) >> >> In that case, we could use a single cell for both entry and display of >> value. >> >> Best regards, >> Amiyo Biswas >> Cell: 91-9433464329 >> >> ----- Original Message ----- >> From: "Zujar Shabbir Kanchwala" <zujarbri...@gmail.com> >> To: <accessindia@accessindia.org.in> >> Sent: Tuesday, April 27, 2010 7:28 AM >> Subject: Re: [AI] EXCEL FORMULA >> >> >>> Using formula you can convert 9.03 to 10 like this: >>> >>> =ceiling(9.03,1) >>> >>> The CEILING() function calculates the next multiple of a number after a >>> given number. The syntax is: >>> >>> =CEILING(number,significance) >>> >>> Where number is the base number which you want to round off. >>> >>> And >>> >>> Significance is the multiple to consider. Specifying 1 here gives you the >>> next non decimal number if the first argument is a decimal number. >>> >>> Examples: >>> >>> =ceiling(10.5,2) gives 12 (the next multiple of 2 after 10.5) >>> >>> =ceiling(22,11) gives 22. (22 itself is a multiple of 11) >>> >>> =ceiling(6.15, 4.02) gives 8.04 >>> >>> Hope that's clear... >>> >>> Best Regards, >>> Zujar... >>> >>> An optimist laughs to forget, whereas a pessimist forgets to laugh! >>> >>> -----Original Message----- >>> From: accessindia-boun...@accessindia.org.in >>> [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Amiyo Biswas >>> Sent: Tuesday, April 27, 2010 6:20 AM >>> To: accessindia@accessindia.org.in >>> Subject: Re: [AI] EXCEL FORMULA >>> >>> Hello Kamal, >>> >>> How was it solved? You wanted a format option and I did not notice if >>> anybody suggested any suggestion on format option. We were all discussing >>> formulas. >>> Best regards, >>> Amiyo Biswas >>> Cell: 91-9433464329 >>> >>> >>> ----- Original Message ----- >>> From: "Kamal Verma" <kamalve...@pnb.co.in> >>> To: <accessindia@accessindia.org.in> >>> Sent: Monday, April 26, 2010 11:00 AM >>> Subject: Re: [AI] EXCEL FORMULA >>> >>> >>>> Hello! >>>> >>>> Thanks to all for their valuable suggestions. My problem is solved now. >>>> >>>> Kamal Verma. >>>> ----- Original Message ----- >>>> From: "Surya Prakash Sharma" <surya.sharm...@gmail.com> >>>> To: <accessindia@accessindia.org.in> >>>> Sent: Monday, April 26, 2010 6:43 AM >>>> Subject: Re: [AI] EXCEL FORMULA >>>> >>>> >>>>> hi, >>>>> 9.00 is the nearest round off of 9.03. so one should not expect 10 from >>>>> the formula. >>>>> ----- Original Message ----- >>>>> From: "Amiyo Biswas" <amiyo.bis...@gmail.com> >>>>> To: <accessindia@accessindia.org.in> >>>>> Sent: Monday, April 26, 2010 6:18 AM >>>>> Subject: Re: [AI] EXCEL FORMULA >>>>> >>>>> >>>>>> Ok, it's not giving 10 for 9.03, as Kamal wanted. >>>>>> >>>>>> ----- Original Message ----- >>>>>> From: "Mukesh Baviskar" <mukeshbaviskar....@gmail.com> >>>>>> To: <accessindia@accessindia.org.in> >>>>>> Sent: Sunday, April 25, 2010 7:34 AM >>>>>> Subject: Re: [AI] EXCEL FORMULA >>>>>> >>>>>> >>>>>>> Here is the solution for your problem. >>>>>>> Open excel sheet. >>>>>>> For example: write 9.03 in a1. >>>>>>> Go to format menu or simply press the shortcut ctrl + 1 and go to >>>>>>> number tab. >>>>>>> Choose category number-tab-decimal place 0-tab-okay-enter. Copy this >>>>>>> format in required column or row. your problem will be solved. Thank >>>>>>> you. >>>>>>> >>>>>>> Mukesh R. Baviskar >>>>>>> 9403161157 >>>>>>> ----- Original Message ----- >>>>>>> From: "Kamal Verma" <kamalve...@pnb.co.in> >>>>>>> To: <accessindia@accessindia.org.in> >>>>>>> Sent: Thursday, April 22, 2010 11:28 AM >>>>>>> Subject: [AI] EXCEL FORMULA >>>>>>> >>>>>>> >>>>>>>> Hello everyone, >>>>>>>> >>>>>>>> I want to round off the figure in nearest rupee. Suppose, I enter >>>>>>>> 9.03 >>> >>>>>>>> in A1, it should appear as 10.00 in the same cell. Further, I enter >>>>>>>> 99.10 in B1, it should automatically be changed to 100. >>>>>>>> >>>>>>>> Please suggest me any formula or macro in this regard. Though I am >>>>>>>> well acquainted with excel formulae, this exercise is out of my >>>>>>>> comprehension. >>>>>>>> >>>>>>>> Kamal Verma, >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> DISCLAIMER: >>>>>>>> >>>>>>>> >>>>>>>> The Information transmitted in this email is solely for the >>>>>>>> addressee. >>> >>>>>>>> It is confidential and may be legally privileged. Access to this >>>>>>>> email >>> >>>>>>>> by anyone else is unauthorized. Any disclosure, copying, >>>>>>>> distribution >>>>>>>> or any action taken by anyone other than by the intended recipient >>>>>>>> is >>>>>>>> prohibited and may be unlawful. If you are not the intended >>>>>>>> recipient >>>>>>>> then kindly delete the mail from your system. Any opinion or views >>>>>>>> expressed in this mail may not necessarily reflect that of Punjab >>>>>>>> National Bank. The bank considers unencrypted email as an insecure >>>>>>>> mode of communication. >>>>>>>> >>>>>>>> >>>>>>>> To unsubscribe send a message to >>>>>>>> accessindia-requ...@accessindia.org.in with the subject unsubscribe. >>>>>>>> >>>>>>>> To change your subscription to digest mode or make any other >>>>>>>> changes, >>>>>>>> please visit the list home page at >>>>>>>> >>>>>>>> >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> To unsubscribe send a message to >>>>>>> accessindia-requ...@accessindia.org.in >>> >>>>>>> with the subject unsubscribe. >>>>>>> >>>>>>> To change your subscription to digest mode or make any other changes, >>>>>>> please visit the list home page at >>>>>>> >>>>>>> >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> To unsubscribe send a message to >>>>>> accessindia-requ...@accessindia.org.in >>>>>> with the subject unsubscribe. >>>>>> >>>>>> To change your subscription to digest mode or make any other changes, >>>>>> please visit the list home page at >>>>>> >>>>>> >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>> >>>>> >>>>> >>>>> >>>>> To unsubscribe send a message to accessindia-requ...@accessindia.org.in >>>>> with the subject unsubscribe. >>>>> >>>>> To change your subscription to digest mode or make any other changes, >>>>> please visit the list home page at >>>>> >>>>> >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>> >>>> >>>> >>>> >>>> DISCLAIMER: >>>> >>>> >>>> The Information transmitted in this email is solely for the addressee. >>>> It >>>> is confidential and may be legally privileged. Access to this email by >>>> anyone else is unauthorized. Any disclosure, copying, distribution or >>>> any >>>> action taken by anyone other than by the intended recipient is >>>> prohibited >>>> and may be unlawful. If you are not the intended recipient then kindly >>>> delete the mail from your system. Any opinion or views expressed in this >>>> mail may not necessarily reflect that of Punjab National Bank. The bank >>>> considers unencrypted email as an insecure mode of communication. >>>> >>>> >>>> To unsubscribe send a message to accessindia-requ...@accessindia.org.in >>>> with the subject unsubscribe. >>>> >>>> To change your subscription to digest mode or make any other changes, >>>> please visit the list home page at >>>> >>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> >>> >>> >>> To unsubscribe send a message to accessindia-requ...@accessindia.org.in >>> with >>> the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> No virus found in this incoming message. >>> Checked by AVG - www.avg.com >>> Version: 9.0.814 / Virus Database: 271.1.1/2836 - Release Date: 04/26/10 >>> 12:01:00 >>> >>> >>> >>> >>> To unsubscribe send a message to accessindia-requ...@accessindia.org.in >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please visit the list home page at >>> >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> >> >> >> To unsubscribe send a message to accessindia-requ...@accessindia.org.in >> with >> the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> No virus found in this incoming message. >> Checked by AVG - www.avg.com >> Version: 9.0.814 / Virus Database: 271.1.1/2838 - Release Date: 04/27/10 >> 11:57:00 >> >> >> >> >> To unsubscribe send a message to accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> > > > > > To unsubscribe send a message to accessindia-requ...@accessindia.org.in with > the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >
-- Best Regards, Zujar Shabbir Kanchwala... Hello : 9769371152 To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
