Logical Functions: IF, AND, OR, IFS, IFERROR
This lesson is part of the subscription
The first 2 lessons of this course are free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Entering Data & Your First FormulasFree
- Relative, Absolute & Mixed ReferencesFree
- Math & Stats Functions: SUM, AVERAGE, COUNT, MEDIAN Pro
- Logical Functions: IF, AND, OR, IFS, IFERROR Pro
- Lookups: VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP Pro
- Text Functions: LEFT, MID, TRIM, PROPER, TEXT & Joining Pro
- Date Functions: DATE, EDATE, EOMONTH, NETWORKDAYS Pro
- SUMIFS, COUNTIFS & AVERAGEIFS Pro
- Data Cleaning: Split Codes, Fix Case, Convert Text to Numbers Pro
- Final Project: Monthly Sales Report Pro