Round Percentage

K

K

Hi all, What will be the formula to round the percentage to two
decimal places like I have percentage in cell A1 "17.83333331%".
Whith which formula I can make it "17.83%". Please can any friend can
help
 
M

Mike H

Hi,

The simplest way is to format the cell as % to 2 decimal places but you
could use

=ROUND(A1,2)

Mike
 
K

K

Hi Mike H, Thanks for replying. actually i got formula in cell A1
and i have formated cell as 0.00%.if i look in in formula bar i see
the result 17.8333333% but it appear in cell 17.83%. I know about
Round formula but when i put in cell A1 "=ROUND(B1/C1,2)" i get result
0.00%. I tried CELING formula but i get result 17.84 as it rounds up
the last digit. Round formula works on normal numbers but for
percentage i am looking for something that i get 17.83% in cell as
well as in formula bar.
 
P

Peter T

Looks like you want 0.1783 displayed as 17.83%, that's 4 places

=ROUND(B1/C1,4)
and numberformat 0.00%

Regards,
Peter T
 
J

JoeU2004

K said:
i see the result 17.8333333% but it appear in cell
17.83%.

Remember that 17.8333% is actually the number 0.178333 (about). So if you
want to round percentages to 2 decimal places, you need ROUND(A1,4).

However....

I know about Round formula but when i put in cell
A1 "=ROUND(B1/C1,2)" i get result 0.00%.

Something else is wrong. If B1/C1 results in 17.8333%, ROUND(B1/C1,2)
should result in 18%, not 0%.

And....

I tried CELING formula but i get result 17.84 as it
rounds up the last digit.

If you are saying that you tried CEILING(B1/C1,0.01) with that result, then
B1/C1 resulted in 17.8333, not 17.8333%.

Not only is that inconsistent with your statement about ROUND(B1/C1,2), but
also it means that you really do not have a percentage result (i.e.
formatted as Percentage).

Can you explain these inconsistencies?


----- original message -----
 
K

K

Thanks peter, you have solved my problem. i should be putting Round
(B1/C1,4) intead of Round(B1/C1,2). Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top