IF formula conundrum

[kittenkj]

Ok.....I need your help. There must be an obvious solution to this tha
I am not seeing.

Im trying an "IF" calculation with a top and bottom variable such that
If cell A1>20000 and <50000 then answer "YES" if not "NO". Should b
basic right?

Somehow just cant seem to get it right. Im stuck on the basic I
calc.

=IF(A1>20000<50000,"YES","NO") but it doesnt like the variables. Ca
anyone assist? Im doing something wrong here.

Really appreciate your help

 

[Mark Rosenkrantz]

Kitten;

IF(And(A1>20000;A1<50000);"Yes";"No")

See for more Help the Excel Help under And.

Mark.

 

[kittenkj]

Thanks Mark.....

You have saved me!...YIPEEEE

Had a little trouble at first but when i used comma instead of semi
the formula worked a treat!

Thanks again.

Kitte

 

[Frank Kabel]

Hi
try
=IF(AND(A1>20000,A1<50000),"YES","NO")