range in an IF statement
 

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

range in an IF statement
 

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

range in an IF statement
 

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

range in an IF statement
 

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

range in an IF statement
 

=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

range in an IF statement
 

sort of, but you gave me an idea....
--
Dorothy J


"John Bundy" wrote:

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

range in an IF statement
 

Your answer made it work, putting in the sign worked. I didn't need the
AND though...I think!!

THANKS!!!!

--
Dorothy J


"John Bundy" wrote:

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

range in an IF statement
 

maybe try this

=11*--and(a1=1100,a1<1200)
--
*****
birds of the same feather flock together..



"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

range in an IF statement
 

THANKS!
--
Dorothy J


"dribler2" wrote:

maybe try this

=11*--and(a1=1100,a1<1200)
--
*****
birds of the same feather flock together..



"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

range in an IF statement
 

your welcome
--
*****
birds of the same feather flock together..



"Dorothy J" wrote:

THANKS!
--
Dorothy J


"dribler2" wrote:

maybe try this

=11*--and(a1=1100,a1<1200)
--
*****
birds of the same feather flock together..



"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