How can I combine more than one of these "IF(AND)" statements?

"Peo Sjoblom" wrote:

=AND(A1=80.01,A1<=90.00)

will return TRUE if it is, if you need to get another answer

=IF(AND(A1=80.01,A1<=90.00),"Yes","No")

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


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