=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.