"K" wrote:
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" wrote in message
...
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.