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
