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
