Yes sir. I did a small mistake by including "UP" in the formula. How do I convert numbers in to words? That is if type "123" in A1, I want "one hundred and twenty three" to be written in B2. How do I do this?
On 23/03/2012, zoher <[email protected]> wrote: > stil my formula works in your example . > ----- Original Message ----- > From: "giri prasad" <[email protected]> > To: <[email protected]> > Sent: Friday, March 23, 2012 1:48 PM > Subject: Re: [AI] Rounding up percentage. > > >> Dear sir, try this and let me know. >> =16150*35.952% >> The result will be 5806.248. >> Now I want to round up this result to 5806 since the value after the >> decimal point is less than 5. >> Look forward to hearing from you at the earliest. >> >> On 23/03/2012, Mukesh <[email protected]> wrote: >>> Use this formula as follows: >>> >>> =round((a1*0.15),0) >>> >>> The cell address may vary as per your cell address. Your problem is >>> solve. >>> Please try it. >>> >>> Regards >>> >>> Mukesh Baviskar >>> Mobile: 9403161157 >>> >>> -------------------------------------------------- >>> From: "giri prasad" <[email protected]> >>> Sent: Thursday, March 22, 2012 7:23 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 >>> >>> >> >> >> -- >> 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 > > -- 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
