Simple IF: Pass/Fail and Over/Under Budget
This lesson is part of the course
In this lesson
You flag the Brightline Outdoor departments that went over budget, calculate the overspend, grade a safety test and chart budget against actual.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Simple IF: Pass/Fail and Over/Under Budget Locked
- IF with AND, OR & NOT: Eligibility Rules Locked
- Nested IF vs IFS: Grade Bands & Commission Tiers Locked
- SWITCH, CHOOSE & XLOOKUP: Replacing Nested IFs Locked
- IF with Text: SEARCH, LEFT, EXACT & LEN Locked
- IF with Dates: Overdue Invoices & Weekend Deliveries Locked
- Error Handling: IFERROR vs IFNA, ISBLANK & ISNUMBER Locked
- Logic-Driven Status Dashboard: COUNTIFS, SUMIFS vs IF Arrays Locked