Forum Discussion
If, then, formula, roundup question
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 m...
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...