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 -----