Rounding up Cells

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
 
F

Freemini

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
 
A

Arvi Laanemets

Hi

Excel2000+Analysis ToolPack
=ROUNDUP(33.33,0)

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

Ron Rosenfeld

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
 
Top