When compared to the SWITCH statement, IF is best used when performing complex logical tests involving multiple conditions. It also works well with tests that use various logical operators in Excel (e ...