Function termnology
 

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.

Function termnology
 

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

--
Regards,

Peo Sjoblom


"Colin" wrote in message
...
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.

Function termnology
 

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

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Colin" wrote:

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.