Round up entire worksheet
The only way to do that is to use 2 cells. One for the actual amount and one
for the rounded amount.
A1 = 12.01
B1 FORMULA: =CEILING(A1,1)
Biff
"Jaime" wrote in message
...
Is there a way to make it so every number entered in a worksheet is
automatically rounded up? My work wants the numbers rounded up (12.01
rounded up to 13.00), however they want the actually amount to be typed in
for possible future audits.
I don't have to do this cell by cell do I?
|