How to roundup to the next Whole Number

October 24, 2009 at 07:03:08
Specs: Windows 7
What formula would i enter if If i wanted the result of
A1/(B1*C1) rounded up to the next whole number.


See More: How to roundup to the next Whole Number

Report •


#1
October 24, 2009 at 07:39:31
=ROUNDUP(A1/(B1*C1),0)

Using 0 rounds up to nearest whole number.

MIKE

http://www.skeptic.com/


Report •

#2
October 24, 2009 at 08:22:31
Thank you Mike but then I get on #div/0! mty D1.how can i correct this?

Report •

#3
October 24, 2009 at 12:09:08
Your trying to divide by 0,

Try this

=IF(ISERR(A1/(B1*C1)),"Try again!",ROUNDUP(A1/(B1*C1),0))

A blank cell is equal to 0

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question