Using Conditional If Statemens in MS Excel

---

I will keep this blog post rather simple. My objective here is to use the “IF(OR(AND(…  “
Statement in order to create a formula based on that criteria that need to be met.
Consider the table below:

I want column D (I.e. Testing Completed) to Display the value “X”, whenever either one of the conditions below have been satisfied: 

Here is the If statement that I will use in order to satisfy all the above criteria in a single formula using the IF, OR and AND functions of Excel:

=IF(OR(AND(B2="YES", C2="Passed"), AND(B2="No", C2="NA")),"X","")


Here is the final outcome: 

---