Excel Logical Functions and IF Statements - Advanced Tutorial

Overview

Learn essential Excel logical functions and tests in this 47-minute comprehensive video tutorial with downloadable practice files. Master the IF function and its variations through 14 practical examples, starting with basic logical tests and progressing to complex applications. Explore comparative operators, ISNUMBER, AND, OR, and NOT functions while building practical solutions like sales bonus calculations, invoice creation, and balance checking systems. Discover advanced concepts including case-insensitive formulas, TRUE/FALSE conversions, and the proper implementation of IFERROR and IFNA functions. Practice with real-world scenarios including sales commission calculations, multi-condition testing with IFS, and a scoring template for a Boomerang Tournament. Complete hands-on exercises with provided homework problems to reinforce learning.

Syllabus

1. Introduction
2. Topics in Video
3. IF function and its arguments
4. Logical tests in the Excel worksheet: Complete Story
5. Logical formula using comparative operators, including a comparison to how comparative operators are used in functions like SUMIFS and COUNTIFS
6. Logical formula using ISNUMBER function
7. Logical formula using AND Function
8. Logical formula using case-insensitive formula
9. Logical formula using non-zero numbers as TRUE formula
10. Logical formula using math operator to convert TRUE to 1 and FALSE to 0
11. Use IF function to deliver a sales bonus to a cell
12. Use IF function to deliver the message “Not In Balance” to a cell when Debits do not equal Credits
13. Use IF function to deliver the correct sales commission rate to a formula
14. Use XLOOKUP, IF, and ISNUMBER functions to build an Invoice.
15. Use IF function with the AND function. Also see how to spill the results for an AND Logical Test using the math operator: Multiplication.
16. Use IF function with the OR function. Also see how to spill the results for an OR Logical Test using the math operator: Addition.
17. Use IF function to create a NONE Logical Test using the NOT function.
18. IFS function to put three or more things into a cell
19. IFNA and FORMULTEXT functions
20. IFERROR Function and when not to use it. Scoring template for Boomerang Tournament.
21. Summary
22. Homework – Practice Problems for you!
23. Closing