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)

rbellotti 

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