View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
simmerdown
 
Posts: n/a
Default IF statement including BETWEEN

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.