# Display a text result based on numeric values

Occasional Contributor

# Display a text result based on numeric values

Seeking a formula for the following:

If P5 is less than 0.9, display B5 in Q5

OR

If P5 is greater or equal to 0.9 but less than or equal to 1.1, display "Even" in Q5

OR

If P5 is greater than 1.1, display A5 in Q5

Thank you, Bob

2 Replies

# Re: Display a text result based on numeric values

If P5 is less than 0.9, display B5 in Q5
cannot be an OR but should be an ELSE:
IF(P5<.9,B5
If P5 is greater or equal to 0.9 but less than or equal to 1.1, display "Even" in Q5
cannot be an OR but an AND
IF(
AND(P5>=.90,P5<=1.1),"EVEN",

cannot be an OR but an ELSE (assuming it is then greater than 1.1 based on the IF statement above)

A5

So to sum it all up:

`IF(P5<.9, B5,   IF(      AND(          P5>=.9,P6<=1.1         ),           "EVEN", A5     )  )`

Paste in Q5 in excel:

`IF(P5<.9, B5,F(AND(P5>=.9,P6<=1.1),"EVEN", A5))`

Cheers

# Re: Display a text result based on numeric values

Untested...

``=IFS(P5<0.9,B5,P5<=1.1,"Even",TRUE,B5)``

or

``=IFS(P5<0.9,B5,P5<=1.1,"Even",P5>1.1,B5)``