Formulas > =IFS()

How To Use IFS() Function in Google Sheets


Evaluates multiple conditions and returns a value that corresponds to the first true condition.

Common Questions about the IFS Formula:
-What does the IFS formula do?
-What are the syntax requirements for using the IFS formula?
-How can I use the IFS formula to do a certain operation?

How can the IFS formula be used appropriately:
-The IFS formula can be used to determine the outcome of multiple conditions.
-The IFS formula can be used to form nested and multiple IF statements.
-IFS formula can be used in combination with other functions such as AND, OR, etc.

How can the IFS formula be commonly mistyped:
-Leaving out parentheses or commas.
-Using incorrect operators for testing conditions such as a less than symbol ( < ) instead of a less than or equal to symbol ( <= ).
-Forgetting to include an END IF for the IFS statement.

What are some common ways the IFS formula is used inappropriately:
-Using the IFS formula for operations that can be simplified with simpler formulas.
-Trying to use the IFS formula to compare two values that are incompatible types.

What are some common pitfalls when using the IFS formula:
-Forgetting to have a corresponding outcome for each condition.
-Writing a non-coditional statement, such as a mathematical operation, as the outcome.

What are common mistakes when using the IFS Formula:
-Forgetting to close the parentheses.
-Incorrectly nesting the IFS statement by not placing the IFS statement within another IF statement.
-Using parentheses incorrectly with the IFS statement.

What are common misconceptions people might have with the IFS Formula?
-Thinking the IFS formula works the same way as normal IF-ELSE statements when it does not.
-Thinking the IFS statement is limited to only two or three conditions when it can contain an infinite number of conditions.

Learn Every Google Sheets Formula
Better than any other Google Sheets course, At Better Sheets and specifically:, I have everything you need to take your Google Sheets skills to the next level. 

From ABS() to YIELD(), Better Sheets has it all. 

There’s no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

How To Actually Use IFS() in Sheets

IFS(condition1, value1, [condition2, value2], …)

2Better Sheets Tutorials

Let's code a Radio button that turns off all checkboxes except the one clicked.
We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.

Learn more about the IFS() formula:

Using OR, AND, NOT, IF, and SWITCH: Introduction to Programming with Google Sheets 06-D

In this video we demonstrate some of the functions in Google Sheets we can use to make decisions.

Generate a IFS() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.