=IF(AND(A1=90,A1<=100),"A1 between 90-100","Outside 90-100")

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Chris" wrote:

How would I write an IF statement where my logical test is looking for a
range. i.e A1=91
Is it possible to write an if statement where I am looking for the range in
A1 to be a range between 90 and 100. I don't seem to be able to find
anything in microsoft help that allows you to return a value if true on a
range.