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
