IF Statement Reading Zero's

[MichaelPK]

If a number in cell AX2 is between -5 and 10, I want there to be “10” i
cell AS2, but for some reason if AX2 is a “0”, a “0” is placed in th
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

 

[Claus Busch]

Hi Michael,

Am Tue, 28 May 2013 16:22:27 +0100 schrieb MichaelPK:

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.”

try:
=AND(AX2>-6,AX2<11)*10
or
=IF(AND(AX2>-6,AX2<11),10,"")


Regards
Claus Busch

 

[MichaelPK]

If a number in cell AX2 is between -5 and 10, I want there to be “10” i
cell AS2, but for some reason if AX2 is a “0”, a “0” is placed in th
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.

The solution: Remove the *AX