Excel expert David Ringstrom, CPA, begins with a brief discussion of the IF function and then takes you step-by-step beyond the basics. David explains what can go awry with the IF function and ways to improve the integrity of decision-making formulas. David shares alternatives to the IF function, including IFS, CHOOSE, VLOOKUP, SUMIF, and several other worksheet functions. The presentation also explores techniques useful in verifying that formulas such as nested IF statements are working properly.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Topics covered:

  • Facilitating decision making within Excel formulas by way of the IF function.
  • Testing for two or more alternate conditions by way of the OR function.
  • Discovering the capabilities of the SUMPRODUCT function for calculating payroll and other amounts.
  • Auditing portions of a formula by using the F9 key to temporarily convert part of a formula to a value.
  • Stepping through formulas in slow motion with the Evaluate Formulas feature.
  • Employing the SUMIF function to sum values related to multiple instances of criteria you specify.
  • Testing for a single condition among two or more that returns TRUE by way of Excel’s XOR function.
  • Employing the ISERROR function to determine if a formula returns a # sign error as the basis for triggering alternate calculations.
  • Mastering the IFERROR function to display alternate values in lieu of a # sign error.
  • Streamlining the decision-making process with the IFS function in Office 365.
  • Discovering the range of IS functions that can be used within IF statements to test for various conditions within a worksheet.
  • Understanding when you might wish to use ISERROR or ISNA instead of IFERROR.
Learning Objectives
  • Identify the worksheet function that enables you to determine whether at least one logical test returns TRUE
  • Discover the purpose of Excel's IFERROR worksheet function.
  • Identify what the SUMIFS function returns if a match cannot be found.
Last updated/reviewed: August 17, 2023

Included In Certifications

This course is included in the following Certification Programs:

17 CoursesExcel Modeler Certification

  1. Excel Efficiency: VLOOKUP
  2. Excel Efficiency: Logic Functions
  3. Excel Efficiency: Filtering and Formatting Data
  4. Excel Efficiency: Intermediate Pivot Tables
  5. Excel Efficiency: Auditing Spreadsheets
  6. Excel Efficiency: Minimizing Worksheet Errors
  7. Excel Efficiency: Workbook Links
  8. Excel Efficiency: What-If Analysis in Microsoft Excel
  9. Excel Efficiency: Quick and Easy Financial Statements in Excel
  10. Excel Efficiency: Budget Spreadsheets
  11. Hands-On Excel: Waterfall Calculations
  12. Excel Efficiency: Table Feature
  13. Excel Efficiency: Intro to Macros Part 1
  14. Excel Efficiency: Intro to Macros Part 2
  15. Excel Efficiency: Excel Chart Speed Tips
  16. Excel Efficiency: Taming Large Spreadsheets
  17. Excel Efficiency: Internal Controls
18 Reviews (87 ratings)


Member's Profile
I learn how use in deep IFERROR/VLOOKUP ,XOR, SUMPRODUCT formulas and how apply them correctly in any database. It will helpa lot in my data job. I highly recommend you that I reading my comment to take this course it worth every minute that you spend learning it.

Anonymous Author
This course covers Excel logic functions you might not have been aware of. There is also quite a lot of discussion of the different versions of Excel and which functions were available when.

Anonymous Author
Great lesson. There are many Excel features that are not known by the vast majority of users. Illumeo does a good job of providing content to help bring those to light.

Anonymous Author
Good explanation of some of the newer Excel functions like IFERR and XOR. Some of the other functions like SUMIF are also covered in this trainer's other courses.

Member's Profile
Excellent discussion of all the ins and outs of logical expressions. Especially liked the discussions around how to use columns as ranges in sumifs and vlookups.

Anonymous Author
This was a very helpful course with a pragmatic application. Not only introduced the concepts, but gave useful examples of how to apply the formulas.

Member's Profile
Learned some new logic functions and am now more comfortable with others that I was aware of but wasn't clear how they worked.

Member's Profile
David provides easy to follow examples plus he is very clear on the steps to do get the desired results.

Member's Profile
Includes many useful functions and was to leverage them together to solve common spreadsheet issues.

Member's Profile
Great examples and detailed slides make this type of instruction my hands down favorite.

Anonymous Author
Great course. First real understanding of logic statements and not being overwhelmed.

Member's Profile
Awesome course. A deep dive into excel formulas extremely useful for data analysis.

Anonymous Author
Once again, a lot of valuable material delivered in a clear and concise manner.

Member's Profile
Great review of many different functions and a few practical uses of functions.

Anonymous Author
This is very helpful. I thought I knew everything about the IF function.

Anonymous Author
Instructor's approach of explaining then demonstrating is very effective.

Anonymous Author
The topics were discussed with excellent examples and concisely.

Member's Profile
great course. great information and great presenter.

Course Complexity: Intermediate

Program Prerequisites: Experience with Excel Error Functions is Recommended

Advance Preparation:None

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
Course Syllabus
  Introduction to Excel Efficiency: Logic Functions6:56
  Comparing Cells Without Using IF6:58
  Two Levels of Nested IF Statements7:08
  Use F9 to Calculate Part of a Formula12:26
  IFS Function (Office 365 Only)8:54
  Introduction to IFERROR10:07
  IFERROR/VLOOKUP Alternative to IF10:06
  Introduction to IS Functions8:12
  Introduction to XOR7:14
  SUMIF with Range Criteria8:51
  SUMPRODUCT as SUMIFS Alternative7:15
  MINIFS Function (Office 365 Only)7:14
  Excel Efficiency: Logic Functions1:45:29
Supporting Materials
  Slides: Excel Efficiency: Logic FunctionsPDF
  Excel Efficiency: Logic Functions Glossary/IndexPDF
  Workbook: Excel Efficiency: Logic FunctionsPDF