Completed
5. Logical formula using comparative operators, including a comparison to how comparative operators are used in functions like SUMIFS and COUNTIFS
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
