Microsoft Excel: IF, IFS & Logical Functions

Wishlist Share

About Course

Learn how to make Excel decide for you. This course covers the IF function, combining tests with AND, OR and NOT, replacing long nested IFs with IFS and SWITCH, and the common mistakes that make logical formulas return the wrong answer.

Tutwoo is an independent learning provider and is not affiliated with or endorsed by Microsoft. Menu names and features can vary between versions and platforms and change with updates. This course is general skills training and is not an accredited qualification.

What Will You Learn?

  • Write IF formulas that return the right result every time Combine several conditions with AND, OR and NOT Replace hard-to-read nested IFs with IFS, SWITCH or a lookup table Spot and fix the most common logical formula mistakes

Course Content

Course Lessons

  • The IF function
  • Combining conditions: AND, OR and NOT
  • Nested IF, IFS and SWITCH
  • Checking and troubleshooting logical formulas

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕