Is this what you were trying to do?
=IF(AND(A1=1100,A1<1200),11,"")
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Dorothy J" wrote:

I need the IF statement to look for numbers 1100 through 1199, then put 11 in
another cell. How do I get the IF statement to recognize the range 1100
through 1199? Meaning, any number between 1100 and 1199 should be given the
number 11?
--
Dorothy J