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
