For example, select cell C3 and write
=IF(AND(A1=2.5,A1<=5),"Good","Bad")
A1 contains the value you want to test.

Ola Sandström


=IF(AND(A1=B1,A1<=B2),"Good","Bad")
B1 is 2.5
B2 is 5.0


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378692