I put that in but it made no difference, I used my own figures, correct?
--
Dorothy J


"Don Guillett" wrote:

would this work?
=left(a2,2)

--
Don Guillett
SalesAid Software

"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