It also works well when the tests use different logical operators in Excel (e.g., >, <, =, <>, AND ... Take this complex nested IF statement, for example: Here, we have set the expression that ...