The AND/OR functions are capable functions on their own, but they can also be used as logical operators for more ... [condition2], ) Just as in Boolean logic, Excel has a third logical function ...
Nested IF Statement . If you want to test multiple conditions simultaneously, you can place IF statements inside another.