IF gone wrong

[Turnipboy]

This is a simple IF statement that I can not get to work:

=IF(4000<$F59<9000,"BETWEEN","NOT BETWEEN")


No matter what I put in F59, e.g. 5000 I only get the output NOT
BETWEEN. What am I doing wrong?

Thanks.

 

[Roger Govier]

Hi

Try
=IF(AND($F59>4000,$F59<9000),"BETWEEN","NOT BETWEEN")

Regards

Roger Govier