As you can see, the logic can quickly get confusing the more you nest the IF statements ... multiple conditions. It also works well when the tests use different logical operators in Excel ...