Thank you very much sir. I have two more things to get clarified. 1. How do we read a cell containing formula letter by letter?
2. If I type some number in figures that is 123 in A1, how do I get 123 in words in B1? On 22/03/2012, Zujar Shabbir Kanchwala <[email protected]> wrote: > Thanks Zoher for the correction. I realized that while watching TV after > sending the email, so turned on the Internet to send out the correction and > found your email with the same content. > > Best Regards, > Zujar > > An optimist laughs to forget while a pessimist forgets to laugh... > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of zoher > Sent: Thursday, March 22, 2012 8:51 PM > To: [email protected] > Subject: Re: [AI] Rounding up percentage. > > dear zujar in your formula the importent part is missing. that is the how > many desimal point you want to round up to.in the above query the person > wants to round the figure to 0 desimal point so the formula will be, > =round((25*15%),0) > =round((25*13%),0) > ----- Original Message ----- > From: "Zujar Shabbir Kanchwala" <[email protected]> > To: <[email protected]> > Sent: Thursday, March 22, 2012 8:32 PM > Subject: Re: [AI] Rounding up percentage. > > >> Use theROUND() function. Your examples rewritten below: >> >> 1. =ROUND(25*15%) >> 2. =ROUND(25*13%) >> >> The above formulae return 4 and 3 respectively as desired. >> >> Best Regards, >> Zujar >> >> An optimist laughs to forget while a pessimist forgets to laugh... >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of giri prasad >> Sent: Thursday, March 22, 2012 7:24 PM >> To: [email protected] >> Subject: [AI] Rounding up percentage. >> >> Dear list members, I have a queery related to excel regarding rounding >> up percentage. >> I am not sure whether I will be able to explain it well. I therefore >> will explain it giving an example. For instance if we give the formula >> 1. =25*15% we get 3.75. >> 2. =25*13% we get 3.25. >> >> In the first example, after the decimal point, if the value is greater >> than or equal to 5, I want it to be rounded up to the next digit that >> is 4. >> >> If the value is less than 5 after the decimal point, I want it to be >> rounded to the previous digit that is 3 in the second example. >> How do I do this? I will be grateful if some one can help me out. >> >> >> -- >> WITH REGARDS >> >> GIRIPRASAD >> >> MOBILE 924710000 / 9441133367 >> >> SKYPE giriprasad.maddina >> >> "Our greatest glory consists not in never falling, >> but in rising every time we fall." >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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 >> >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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 >> > > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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 > > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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 > > -- WITH REGARDS GIRIPRASAD MOBILE 924710000 / 9441133367 SKYPE giriprasad.maddina "Our greatest glory consists not in never falling, but in rising every time we fall." Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] 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
