Function termnology

[Guest]

I am aware that < means 'less than', that > means 'more than' and that <=
means less than or equal.
but how is the term 'between say1401 and 2000' written (1401 and 2000 need to
be included in the numbers excel would work with)?


Thank you,

Colin.

 

[Peo Sjoblom]

IF(AND(A2>=1401,A2<=2000),"Do This",Do That")

 

[Guest]

=AND(>A1,<A2) assuming A1 = 1401 and A2 = 2000

Dave