Need to watch those = signs if BETWEEN is to be taken literally. Depends on
what the OP really meant though :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Duke Carey" wrote in message
...
=if(and(a1=80.01,A1<=90),"Between", "Not between")


"simmerdown" wrote:

How can I write an IF statement that evaluates whether a cell's value is
BETWEEN two numbers?

Example:

A1 = 89.99

I need a statement that evaluates whether A1's contents are between 80.01
and 90.00.

Thank you.