IF gone wrong

T

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

Roger Govier

Hi

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

Regards

Roger Govier
 
Top