rounding the answer of a formula
=CEILING(A2,0.01)
with the formula in A2
--
Regards,
Peo Sjoblom
"Boze" wrote in message
...
I want to divide one number by another and round the answer up to the
nearest hundreth.
Ie, 38 inches divided by 12 equals 3.17.
Right now I can DISPLAY the 3.17 but when using that in a formula it's
calculating with 3.1667
Thanks in advance
Boze
|