Skip to content

Learn How to Use the IFS Function

This article will teach you how to use the IFS function.

The IFS function is available in both Microsoft Excel and Google Sheets.

The IFS Function

The IFS function allows you to test several conditions and return a result depending on which condition is met.

For example, you can visualize the IFS function like this.

  • If the score is above 90, the letter grade is A
  • Otherwise, if the score is above 80, the letter grade is B
  • Otherwise, if the score is above 70, the letter grade is C

Hopefully, you are starting to catch on to how the IFS function operates.

How to Use the IFS Function

The IFS function can accept up to 127 pairs of arguments. Each pair of arguments is used to test each condition.

=IFS(Condition1, Value1, Condition2, Value2, etc.)

In each pair, the first argument is the condition the IFS function will evaluate. The second argument is the result the IFS function will return if the condition is true.

Take a look at the example below.

The IFS function starts with the first pair of arguments.

Argument one is a test to see if the score is above 90. Argument two is the letter grade that is returned if the first argument evaluates to TRUE.

If the first argument is FALSE, the IFS function moves on to the next pair of arguments.

Once a condition is met, the IFS function stops looking through the argument list and returns the value corresponding with the true condition. In this case, it returns the value of B.

If no condition evaluates to TRUE, the IFS function returns an error.

How to Set a Default Value

You can set up a default value to prevent the IFS function from returning an error.

To set up a default value, simply add one more pair of arguments at the end of the function.

Make the first of these two arguments TRUE, and make the second argument the default value.

This way, when all other conditions listed in the IFS function are FALSE, this last condition will always be TRUE and result in the default value.

And that is how you can use the IFS function to test several conditions to return a specific result.

This Post Has One Comment

  1. I love the IFS function, but I didn’t know about the TRUE argument that you can use at the end! This is going to save me a lot of time!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top