Need IF statement or Macro to make decision based on multiple criteria

[weddica]

Hi there,
I would like to use excel to make a decision of "YES" or "NO" in M3 based on a few criteria, i.e. "NO" if:
1. D3:E3 = "N" (vs. "Y" or "?")
2. H3:J3 = "N" (vs. "Y" or "?")
3. K3 = "Y" (vs. "N" or "?")
4. L3 = "LOW" (vs. "MEDIUM" or "HIGH")

All else should result in a "YES" decision. There is no data in columns G or H.

Is this even possible???

[Mayda89]

When you say

1. D3:E3 = "N" (vs. "Y" or "?")

, do you mean both d3 and e3 is equal to N, or at least one of them is equal to N?

[weddica]

I mean that both D3 and E3 is equal to N.
THANKS!!

[Mayda89]

Type this formula in M3:

Please Login or Register  to view this content.

[weddica]

Wow! Thanks so much, it works perfectly!!!

[Mayda89]

Glad that I could help