Nested "if" statement

[MN_Excel]

Would anyone be able to help with a formula I'm trying to create regarding "if" and "or." I would like excel to search cells A1 or B1 for a Yes and if either contains Yes to have the result of A. If neither contain Yes I would like to check cells C1 and D1 for Yes and if either of those contain Yes the output would be B. If neither A1, B1, C1, or D1 contain a yes I would like to search E1, and if that contains a yes to have a result of C. Seems like there should be an easy way to do this, I'm just not sure how.

 

[Oaktree]

What if none of A1:E1 contain "Yes"?

In the below, I had that return "D"

=IF(ISNA(MATCH("Yes",A1:E1,0)),"D",CHOOSE(MATCH("Yes",A1:E1,0),"A","A","B","B","C"))

 

[T. Valko]

Would anyone be able to help with a formula I'm trying to create regarding "if" and "or." I would like excel to search cells A1 or B1 for a Yes and if either contains Yes to have the result of A. If neither contain Yes I would like to check cells C1 and D1 for Yes and if either of those contain Yes the output would be B. If neither A1, B1, C1, or D1 contain a yes I would like to search E1, and if that contains a yes to have a result of C. Seems like there should be an easy way to do this, I'm just not sure how.

Maybe this...

=IF(COUNTIF(A1:B1,"yes"),"A",IF(COUNTIF(C1:D1,"yes"),"B",IF(E1="yes","C","")))

 

[MN_Excel]

Worked perfectly........thanks much for your help. Really appreciate it.

 

[Scott Huish]

Perhaps:

=CHAR(64-INT(-MATCH("Yes",A1:E1,0)/2))