Using less than and great than to return cell information

[cadley]

Hi,

I'm new to this forum and require some help from you guys.

I'm trying to get a formula to work and I can up to the final part when it returns the wrong information.

Basically I have entered the following formula in cell D7:

=IF(E7=21,"Won",IF(E7<=20>0,"Lost",IF(E7=0,"N/A")))

What I am trying to achieve the following outcomes:

If cell E7 = 21 then I want "Won" in cell D7
If cell E7 = anything between 1 and 20 then I want "Lost" in cell D7
If cell E7 = 0 then I want "N/A" in cell D7

The formula I have entered works fine although if E7 is "0" with the above formula it put "lost" in D7 and it's driving me mad.

Please can anyone help me.

 

[VoG]

Try

=IF(E7=21,"Won",IF(AND(E7<=20,E7>0),"Lost",IF(E7=0,"N/A")))

 

[cadley]

Try

=IF(E7=21,"Won",IF(AND(E7<=20,E7>0),"Lost",IF(E7=0,"N/A")))

You're a star! God that took me so long to work out and you did it in 1 minute!! Thanks so much!!