Simple Nested And, Or formula based on three conditions

[deacon10]

Hi all, I am hoping someone can help with what I think should be a pretty easy formula,

I am trying to return a value of “medium” or “high” based on if W11 is blank & P11>5 for three different criteria in N11 “average”, “poor” or “good”.

I don’t understand why I am struggling with this so much, but In English it would be…

if N11 = “average” and W11 is blank and P11>5 then answer = “medium”
if N11 is not “average”, but = “poor” and W11 is blank and P11>5 then answer = “high”
if N11 is not “average” or “poor”, but = “good” and W11 is blank and P11>5 then answer = “high”


This is my rather pathetic attempt for part of the logic that returns nothing.

=IF(OR(AND(W11="",N11="average",P11>5)),IF(AND(W11="",N11="poor",P11>5),"High",""))

Thanks in advance

JD

 

[Fluff]

How about

=IF(AND(W11="",P11>5),SWITCH(N11,"average","medium","poor","high","good","high",""),"")

 

[deacon10]

You are a genius! Thank you again.

 

[Fluff]

You're welcome & thanks for the feedback.