If, then, formula, roundup question

Question

&nbsp;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.&nbsp;=IF($G$31&lt;=1500,($G$31/75),0)&nbsp;Can you help me?Thank you in advance

ashakantasharma · Answer

Hi,&nbsp;JamesWise&nbsp;&nbsp;The below ways you can round up the results :&nbsp;1.&nbsp;=Round(IF($G$31&lt;=1500,($G$31/75),0),0)2. =IF($G$31&lt;=1500,Round(($G$31/75),0),0)3.&nbsp;=IF($G$31&lt;=1500,Text($G$31/75,"0.00"),0) * if you want to have the decimal&nbsp;places even if they are zeros&nbsp;Hope it helps...

preagan · Answer

Hello&nbsp;JamesWise,&nbsp;That could also be:=IF($G$31&lt;=1500,ROUNDUP($G$31/75,0),0)

Forum Discussion

If, then, formula, roundup question

2 Replies

Resources