Mastering Excel Formulas IF, AND, OR

Become an Excel guru by understanding and then dominating the IF formula. This formula intimidates novice and intermediate Excel users but with a step by step approach and hands on examples, you can easily master this monster. Additionally, the lesson then goes on to cover two other complementary formulas: AND, OR that can be used with IF to handle complex logic.

This lesson is written in a step by step, easy to understand manner. This lesson, like all other lessons in the series, comes with a follow along workbook where you can practice what you read.

Updated version
This lesson has been updated to cover two new Excel 2016 formulas: SWITCH and IFS. You do not need Excel 2016 for this lesson. The new section explains the new formulas but you can follow along without the 2016 version.