Excel - test if a value is in a range of values

Asked By jfric on 12-Apr-08 10:57 PM
I am trying to write a formula that tests a cell value to see if it matches
values in a range of values and returns either true or false.   Any help
would be greatly appreciated.

Josh




Joe replied on 12-Apr-08 11:23 PM
=IF(AND(A1>=5,A1<=10),TRUE,FALSE)