Completed
1. Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Logical Functions and IF Statements - Advanced Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Topics in Video
- 3 3. IF function and its arguments
- 4 4. Logical tests in the Excel worksheet: Complete Story
- 5 5. Logical formula using comparative operators, including a comparison to how comparative operators are used in functions like SUMIFS and COUNTIFS
- 6 6. Logical formula using ISNUMBER function
- 7 7. Logical formula using AND Function
- 8 8. Logical formula using case-insensitive formula
- 9 9. Logical formula using non-zero numbers as TRUE formula
- 10 10. Logical formula using math operator to convert TRUE to 1 and FALSE to 0
- 11 11. Use IF function to deliver a sales bonus to a cell
- 12 12. Use IF function to deliver the message “Not In Balance” to a cell when Debits do not equal Credits
- 13 13. Use IF function to deliver the correct sales commission rate to a formula
- 14 14. Use XLOOKUP, IF, and ISNUMBER functions to build an Invoice.
- 15 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 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 17. Use IF function to create a NONE Logical Test using the NOT function.
- 18 18. IFS function to put three or more things into a cell
- 19 19. IFNA and FORMULTEXT functions
- 20 20. IFERROR Function and when not to use it. Scoring template for Boomerang Tournament.
- 21 21. Summary
- 22 22. Homework – Practice Problems for you!
- 23 23. Closing
