Nesting IF function and Roundup Function- help please

[brittcarey]

Here is my formula:

=IF(B2>=1,(A2*10)/50,IF(C2>=1,(A2*5)/50,0))


I would like the output value to be rounded up to the next highest whole number but was unable to make this work. Please provide any suggestions- Thank you!


*Note- my office is still operating with 2003 (upgrading soon- yay!)

 

[Faseeh]

Hi Brittcarey,


What if you wrap up your formula in a ROUNDUP() function:

=ROUNDUP(IF(B2>=1,(A2*10)/50,IF(C2>=1,(A2*5)/50,0)),0)

Hope that helps.


Faseeh

 

[brittcarey]

That worked! Thank you so much for the great suggestion and the quick response!

 

[Faseeh]

You are welcome !!


Faseeh