If Statement Between Ranges?

[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

 

[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

 

[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

 

[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

 

[MJSlattery]

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

Michae

 

[Greg]

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

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

 

[Guest]

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.