If Formula by criteria

[AaruJaan]

HERE IS WHAT WE ARE TRYING TO ACHIEVE:

D33 needs to do show certain words given certain criteria as laid out here....

IF D22 and D13 is Yes then ....
--If D31 is greater then or equal to 12 show MAXIMUM
--If D31 is 10 or 11 then show TARGET
--If D31 is 8 or 9 then show THRESHOLD

However,

IF D22 is NO and D13 is yes then...
--If D31 is equal to 3 show MAXIMUM
--If D31 is equal to 2 show TARGET
--If D31 is equal to 1 show THRESHOLD

However,

IF D22 is YES and D13 is NO then...
--If D31 is greater then or equal to 10 show MAXIMUM
--If D31 is 8 or 9 then show TARGET
--If D31 is 6 or 7 then show THRESHOLD

[JohnTopley]

Try

=IF(AND(D22="Yes",D13="YES"),IF(D31>=12,"MAXIMUM",IF(D31>=11,"TARGET","THRESHOLD")),IF(AND(D22="No",D13="YES"),IF(D31=3,"MAXIMUM",IF(D31=2,"TARGET","THRESHOLD")),IF(AND(D22="Yes",D13="No"),IF(D31>=10,"MAXIMUM",IF(D31>=8,"TARGET","THRESHOLD")),"")))

Assumption is that only the values listed are valid i.e if not MAXIMUM or TARGET it is THRESHOLD

[seekerarcane]

Use this

=IF(AND(D22="Yes",D13="YES"),IF(D31>=12,"MAXIMUM",IF(D31>=11,"TARGET","THRESHOLD")),IF(AND(D22="No",D13="YES"),IF(D31=3,"MAXIMUM",IF(D31=2,"TARGET","THRESHOLD")),IF(AND(D22="Yes",D13="No"),IF(D31>=10,"MAXIMUM",IF(D31>=8,"TARGET","THRESHOLD")),"Invalid Criteria")))