IF Statement Reading Zero's
If a number in cell AX2 is between -5 and 10, I want there to be “10” in cell AS2, but for some reason if AX2 is a “0”, a “0” is placed in the cell and not “10.”
The formula I am using is: =IF(AND(AX2-5,AX2<10)*AX2,10,0)
Thank You for any help/insight that can be provided.
|