View Single Post
  #1   Report Post  
MichaelPK MichaelPK is offline
Junior Member
 
Location: Chicagoland
Posts: 6
Default 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.