If, then, formula, roundup question

[JamesWise]

 I have the following formula that works mostly how i want it to, however i need the "G31/75" portion to round up when it meets the "IF" Criteria.

=IF($G$31<=1500,($G$31/75),0)

Can you help me?

Thank you in advance

[#2]

Hi, @JamesWise 

The below ways you can round up the results :

1. =Round(IF($G$31<=1500,($G$31/75),0),0)

2. =IF($G$31<=1500,Round(($G$31/75),0),0)

3. =IF($G$31<=1500,Text($G$31/75,"0.00"),0) * if you want to have the decimal places even if they are zeros

Hope it helps...

[#3]

Hello @JamesWise,

That could also be:

=IF($G$31<=1500,ROUNDUP($G$31/75,0),0)