Perhaps ....

=IF(AND(A1=100,A1<=200),"In range","out range")


"Ardus Petus" wrote:

To test A1 againts range 100,200:

=IF(AND(A1<=100,A1<=200),"In range","out range")

There is no "between" operator.

HTH
--
AP

"aries" a écrit dans le message de news:
...
how do i use between instead of greater than or less than , in if then
else
statement