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
<=
--
David Biddulph

Anthony wrote:
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