Welcome and Introduction
  • Introduction - What are Logic Functions?
  • Downloadable Files
  • My Latest Course! Free for a Limited Time Only
"If" Functions
  • Case Study Explained
  • Logic Functions Explained
  • "If" Function Builder File
  • Example 1: Basic Formula Creation
  • Example 2: "If" function cell linking
  • Example 3: Input Variations/Alterations
  • Example 4: Text Outputs
  • Example 5: Handling Blanks
And/Or Functions
  • "And" function
  • "Or" function and the Fill Handle
Absolute Referencing
  • Absolute Referencing Theory
  • Application of Absolute Referencing with Logic Functions
Bonus Features
  • Nested Logic Functions - Adding If Functions
  • Nested Logic Functions - If within an If
  • "If" Function variations with "Greater Than" and "Less Than"
  • Number and Text Concatenation
  • Error Handling - "Iferror" function
Congratulations
  • Course Quiz
  • Congratulations