Roundup Function

  • Thread starter Thread starter bgcooker
  • Start date Start date
B

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.
 
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...
 
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))
 
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)
 
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))
Click to expand...

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


----- original posting -----
 
Back
Top