May 23 2021 06:50 PM
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
May 23 2021 09:17 PM - edited May 23 2021 09:18 PM
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
May 23 2021 09:22 PM
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)