Re: Round up entire worksheet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

what does the number after the comma stand for in the
formula Ex. =ceiling(A1,1)?

That means to roundup to the next increment of 1.

12.01 rounds up to 13

A1 = 33

=CEILING(A1,10)

Rounds up to the next increment of 10. Result = 40

=CEILING(A1,5)

Rounds up to the next increment of 5. Result = 35

Biff

"Nancy" <Nancy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:27F86C69-C9F5-4AC1-8B27-69F7357D72CE@xxxxxxxxxxxxxxxx
Hi!
Thank you for the info. Very helpful. One question - what does the
number
after the comma stand for in the formula Ex. =ceiling(A1,1)?
--
Nancy :)


"T. Valko" wrote:

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" <Jaime@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C2C4532-5F7D-43EF-B5EC-0A5515596872@xxxxxxxxxxxxxxxx
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?





.

Relevant Pages