Forum Discussion
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)
...
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