Forum Discussion

Norman Zanders's avatar
Norman Zanders
Copper Contributor
Feb 19, 2018

Need help with creating a formula

I need help creating a formula. If the value of A2 = a number from 1 to 99 then I want the value 99 to be placed in A3. If the value of A2 is ≥100, then I want the value of A3 to be (A2*.45+54)

 

I was able to do this somewhat by using the IF formula. The only problem was that A3 would populate with 99 even if A2 was blank or 0. If A2 is blank or 0 then I need A3 to be blank or 0.

Thanks in advance.

  • Hi Norman,

     

    That could be 

    =IF(A2>=100,A2*0.45+54,IF(A2>0,A2,0))

    Formula in Excel never returns blank, it'll be zero in that case. Or you may return "" with one more nested IF

     

Resources