Display a text result based on numeric values

[rbellotti]

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]

Hi @rbellotti 

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

[#3]

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)

@rbellotti