=IF(AND(A1=1100,A1<=1199),11,"")
or
=IF(A1/100=11,11,"") or if the number is not an integer
=IF(INT(A1/100)=11,11,"")
or if you can live with zero when the value is not in the range
=11*(INT(A1/100)=11)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dorothy J" wrote in message
...
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