Great - thanks again for your help. I appreciate it.

"Jim Thomlinson" wrote:

Since zero rounded up is zero you can just place the roundup around the
entire formula...

=ROUNDUP(IF(((C14-D24)/1800)<0,0,((C14-D24)/1800)), 0)
--
HTH...

Jim Thomlinson


"bgcooker" wrote:

Here is the formula I'm using,which gives me the correct result. I would
like round up the result of this formula. Thanks very much for your help.

=IF(((C14-D24)/1800)<0,0,((C14-D24)/1800))


"Jim Thomlinson" wrote:

Yes you can embed the roundup function in an If formula. We would need more
details to help you proceed. Perhaps post an attempt at your formula with a
description of what you want...
--
HTH...

Jim Thomlinson


"bgcooker" wrote:

Is there a way to use the ROUNDUP function within another formula? I have an
IF formula and want to round up the results to the nearest whole number.
I've created a workaround using cells to the side of my work area that
accomplish this, but I would like to know if it can all be combined into one
formula.