How to Use IFS() in Google Sheets

Description

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

How To Actually Use IFS() in Sheets

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

Free 2027 printable calendar in Google Sheets The whole year on one page. Copy it to your Drive, plan the big dates, and print it as a PDF. Get the free calendar

Try IFS yourself

In cells B1:B10, enter student scores. Use the IFS formula in cell C1 to assign grades based on the following criteria: A for scores 90 and above, B for scores 80 to 89, C for scores 70 to 79, and F for scores below 70.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

5 Ways to use IF() Formula to Create Magic in Your Sheets

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.

Intermediate

AND() IF() IFS() ISBLANK() OR() +1 more

Transcript-matched member videos for IFS(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Unlock these tutorials

Learn more about the IFS() formula:

Generate a IFS() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses IFS(). 2 free AI generations, no signup. Members get unlimited use.

Generate a IFS() formula

Ads keep the free stuff free. Members browse ad-free — log in or see pricing.

How to Use IFS() in Google Sheets

Try IFS yourself

Create a Radio Button From Checkboxes Using Google Apps Script

5 Ways to use IF() Formula to Create Magic in Your Sheets

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values