If Statement Between Ranges?

M

MJSlattery

Hi:

I am trying to produce three states from the result of a calculation.

IF it is above 75, IF it is below 25, and (Here is the problem) If i
is between 26 and 74?

This is three fields and three if statements. The first two are easy.
How do you accomplish "between" in an Excel If statement?

Thanks, Michae
 
E

eluehmann

=IF(E10<25,"State A",IF(E10>75,"State B","State C"))

kinda what you are looking for... you can change the variables for
precision
 
M

MJSlattery

I am looking for one statement that give me a "TRUE" when the I
statement is between two values?

I will be able to utilize your answere to this problem in othe
situations but not here.

Thanks,

Michae
 
E

eluehmann

Change "state A" to "False" change "State b" to "False" and Chang
"State C" to "true"

I don't know of any other way without nesting formulas
 
M

MJSlattery

Thanks for the assistance. I will try and work with what you hav
provided.

Michae
 
G

Greg

=IF(AND(A1>=26, A1<=74),"TRUE","FALSE")




MJSlattery said:
I am looking for one statement that give me a "TRUE" when the IF
statement is between two values?

I will be able to utilize your answere to this problem in other
situations but not here.

Thanks,

Michael
Click to expand...
 
G

Geeoff

Greg, that is such a good help. i was looking for the same answer. Thanks
for stepping up and helping me out, just as much as the person who made the
original post.
 
Top