What is the IFS function? (Excel)

Learn how to use IFS in Excel instead of using IF with multiple conditions and OR. Learn at your own pace!

Instead of using IF with OR, use IFS when you want to check multiple conditions one by one in Excel.

What’s the difference between IFS and IF functions? What’s the IFS formula in MS Excel?

After reading this quick Excel tutorial, you’ll know!

Ready to learn?

The IF function allows you to compare a value with an expected value while IFS in Excel checks whether one or more conditions are met and will return a value that corresponds to the first TRUE condition. If several conditions are met, only the value from the first TRUE condition will be returned.

As a reminder, the IF formula is =IF(logical_test, value_if_true, [value_if_false]) and can be used with AND or/and OR statements.

Learn more about IF with AND/OR, click here.

The IFS formula is =IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], [logical_test3, value_if_true3],…).

IFS includes 2 required arguments in Microsoft Excel: logical_test1 and value_if_true1.

logical_test1 — a condition that can be TRUE of FALSE.
value_if_true1 — the result of IFS if logical_test1 is TRUE.

– You can test up to 127 different conditions in Excel using IFS.
– As soon as one condition is met, the system will not check for other conditions and will return the value_if_true of the first TRUE logical_test.
– If no TRUE conditions are found, you’ll see an N/A error. You can change this error message by combining IFS with IFNA. (Learn about IFNA here.)

In this example, instead of using IF with multiple arguments thanks to OR, we use the IFS function (like pros do!).

We want to check if some of our students did not start their Online Course yet: if so, we want to contact them. We also want to track the completion level of other students.

The formula we use is =IFS(C42=0,”Contact them”,C42=100,”Certified”,0<C42,”In progress”,C42<100,”In progress”).

We also used Conditional Formatting to highlight cells containing “Contact them”. Learn how to do it here.

Combine IFNA and IFS in case no conditions are met so no N/A error will appear.

In this example, we just want to find students who got they MS Excel certificate or who did not start the Course yet so we can contact them. We don’t want anything to appear when students are still learning.

The formula we use is =IFNA(IFS(C42=0,”Did not start yet”,C42=100,”Certified”),””).

For your information, without IFNA, the formula would be =IFS(C42=0,”Did not start yet”,C42=100,”Certified”) and you can see how it would look in the last column.

Now, you know how to use the IFS function in Excel and the difference between IF vs IFS.

Want to learn more Excel tips and tricks? Join our Certifying Excel Course now!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Advertising News – 09 June 2024

This week, we'll explore Google's latest algorithm update and it's massive impact on independent websites, the newly passed media Freedom Act in the EU aimed at protecting journalists, and a...

Read More

Categories

AllFunctionsToolsShortcut Keys
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Using Text to Column to Extract texts on Excel

Excel: How to split text into columns

If you need to extract data in Excel, you may want to use the Text to Columns tool. With only 3 steps, it's really easy to split text into columns.

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More