If, then, formula, roundup question

Copper Contributor

 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.




Can you help me?

Thank you in advance

2 Replies

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

Hello @JamesWise,


That could also be: