What formula would i enter if If i wanted the result of

A1/(B1*C1) rounded up to the next whole number.

Thank you Mike but then I get on #div/0! mty D1.how can i correct this?

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

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History