Excel IF & Logical Functions: From Simple IF to IFS, SWITCH & Nested Logic
Master IF, AND, OR, NOT, nested IF, IFS, SWITCH, XLOOKUP tiers, text and date tests and error handling in 8 hands-on labs built on one company, every cell checked instantly.
The first 2 lessons are free — no account needed.
About this course
An Excel IF function course that takes you from a single pass/fail test to a status dashboard driven by logic, all on one outdoor retailer's data. You flag departments over budget with a simple IF, turn an HR policy into eligibility rules with AND, OR and NOT, grade satisfaction scores with a nested IF and pick commission rates with IFS, replace a five-level IF with SWITCH, CHOOSE and an approximate XLOOKUP, categorise web-shop lines with SEARCH, LEFT, EXACT and LEN, label overdue invoices and move weekend deliveries to Monday with WEEKDAY, keep lookups and line totals clean with IFERROR, IFNA, ISBLANK and ISNUMBER and finish with a store dashboard built on COUNTIFS and SUMIFS. For anyone who writes IF formulas at work and wants them right the first time. The first two labs are free.
Lessons
- Simple IF: Pass/Fail and Over/Under BudgetFree
- IF with AND, OR & NOT: Eligibility RulesFree
- Nested IF vs IFS: Grade Bands & Commission Tiers Pro
- SWITCH, CHOOSE & XLOOKUP: Replacing Nested IFs Pro
- IF with Text: SEARCH, LEFT, EXACT & LEN Pro
- IF with Dates: Overdue Invoices & Weekend Deliveries Pro
- Error Handling: IFERROR vs IFNA, ISBLANK & ISNUMBER Pro
- Logic-Driven Status Dashboard: COUNTIFS, SUMIFS vs IF Arrays Pro