IFS Function - Multiple IF Statements in One

Add to Favorites
Author: | Edits: don

Easily create nested IF statements using the new IFS() function for Excel!

The IFS() function allows you to have multiple conditional checks and output something different for each condition. The structure of this function is more like the IF statement in programming than the IF() worksheet function in Excel.

In addition to the syntax and basic usage of the IFS function, I'll show you a simple process for making much more complex decision structures using this variation of the IF statement.

In this tutorial, I'll walk you through multiple examples, including:

  • checking text values and outputing different smiley faces based on food selections
  • checking for ranges of values, the standard "school grades" example
  • combining multiple logical checks together in order to create a more complex decision structure using the IFS() function in Excel

I hope you enjoy this tutorial!


Excel Version: Excel 2016
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.