Rounding up decimals
 

is it possible to round up a decimal number regardless of it's value?

Example:
45.01 shown as 46

Rounding up decimals
 

Try this:

=ROUNDUP(A1,0)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Darren" wrote:

is it possible to round up a decimal number regardless of it's value?

Example:
45.01 shown as 46

Rounding up decimals
 

Darren,

Assuming the value is located at cell A-1, the formula is =roundup(A1,0)
Is this what you were looking for?

Darren wrote:
is it possible to round up a decimal number regardless of it's value?

Example:
45.01 shown as 46

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200905/1