IF with Text: SEARCH, LEFT, EXACT & LEN
This lesson is part of the course
In this lesson
You categorise web-shop lines by a word in the description, route them by the SKU prefix, check promo codes case-sensitively and flag broken records.
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