If statement

A

Anthony

In an if statement how do you code where the variable is between 2 numbers, eg
(minus) -10,000 and 10,000.

Much appreciated

Anthony
 
D

David Biddulph

I don't understand your question.

Do you mean =IF(AND(A2>-10000,A2<10000),"A2 is between the limits","A2 is
not between the limits") ?
If by "between" you want the limits to be inclusive, change > to >= and < to
<=
 
Top