Rounding up Cells

  • Thread starter Thread starter dixonpeter
  • Start date Start date
D

dixonpeter

Simple Question:

If I have a number like 33.33 in a cell, how do I get it to round up to
the nearest whole number instead of rounding down.

Thanks
 
simplest way

=ROUNDUP(Cell,0) where "Cell" is where your 33.33 is found
and the zero is the number of decimal places.

Hope this helps

Mik
 
Hi

Excel2000+Analysis ToolPack
=ROUNDUP(33.33,0)

Or without toolpack
=ROUND(33.33+0.49,0)
 
Hi

Excel2000+Analysis ToolPack
=ROUNDUP(33.33,0)

Or without toolpack
=ROUND(33.33+0.49,0)
Click to expand...

I do not believe the ATP is required for ROUNDUP (or CEILING, etc)


--ron
 
Back
Top