Roundup Function

[bgcooker]

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.

 

[Jim Thomlinson]

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...

 

[bgcooker]

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]

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)

 

[bgcooker]

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

 

[joeu2004]

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))

=max(0,round((C14-D24)/1800,0))


----- original posting -----