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
=IF(AND(A1>=5,A1<=10),TRUE,FALSE)