Spread Sheet Logic

Consider this logic which examines a possible two columns and resolves to a W or an L.

=IF(AND(B4="EDM"; C4>E4); "W"; IF(AND(D4="EDM"; E4>C4); "W"; "L"))

How can I include logic for unresolved, or ‘pending’, "P" as a result?

1 Like

Don’t you hate when you answer your own question right after you ask it? Oh well. Better to admit than hide it.

LAK-V-EDM

=IF(AND(B4="EDM";C4>E4);"W";IF(AND(D4="EDM";E4>C4);"W";IF(C4=E4;"P";"L")))
2 Likes