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: