If you want to check several conditions in a row and return a different answer for each, the IFS function in Google Sheets handles that without nesting IFs.
You list each condition with the result it should give, and IFS returns the result for the first condition that is true. In this article I’ll show you how it works with five examples.
IFS Function Syntax in Google Sheets
Here is how you write the IFS function.
=IFS(condition1, value1, [condition2, value2, ...])
- condition1 – the first test to check, such as
B2>=90. - value1 – the result to return if condition1 is true.
- condition2, value2, … – more condition and result pairs, checked in order. IFS stops at the first condition that is true and returns its value.
When to Use IFS Function
- Assign letter grades from a column of scores.
- Bucket numbers into bands like Low, Medium, and High.
- Pick a label or message based on which range a value falls into.
- Replace a long chain of nested IF formulas with something easier to read.
Example 1: Convert Scores to Letter Grades
Let’s start with the classic use, turning scores into grades.
Below is the dataset, student names in column A and their scores in column B, rows 2 to 6.
The goal is to give each student a letter grade based on their score.
Here is the formula:
=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",B2>=60,"D",TRUE,"F")
IFS checks the conditions left to right and stops at the first true one. A score in the top band returns “A”, the next band down returns “B”, and so on.
The final TRUE,"F" is a catch-all. Any score that misses every earlier band lands here, so the lowest scorer gets “F”.
Pro Tip: Always finish with TRUE as the last condition. It acts as the else case, so any value that matches none of the bands still gets a result instead of an #N/A error.
Example 2: Label Temperature Readings
Here’s how to turn numbers into descriptive labels.
Below is the dataset, a single column of temperature readings in A2 to A5.
The goal is to describe each reading as Too hot, Comfortable, Cold, or Freezing.
Here is the formula:
=IFS(A2>=90,"Too hot",A2>=60,"Comfortable",A2>=32,"Cold",TRUE,"Freezing")
Order matters here. IFS checks the hottest band first and works down, so a high reading returns “Too hot” before it ever reaches the cooler tests.
A mild reading lands in the “Comfortable” band, and anything below freezing falls through to the catch-all and returns “Freezing”.
Example 3: Sort Values Into Low, Medium, and High
IFS is handy for bucketing numbers into named tiers.
Below is the dataset, product names in column A and order counts in column B, rows 2 to 6.
The goal is to flag each order count as Low, Medium, or High.
Here is the formula:
=IFS(B2>=100,"High",B2>=10,"Medium",TRUE,"Low")
The first condition catches the largest counts and returns “High”. The next catches the middle range and returns “Medium”.
Anything left over hits the TRUE catch-all and returns “Low”. Three conditions cover every value cleanly.
Example 4: Pick a Commission Rate by Sales
You can return formatted text like percentages too.
Below is the dataset, salesperson names in column A and their sales totals in column B, rows 2 to 5.
The goal is to assign a commission rate based on how much each person sold.
Here is the formula:
=IFS(B2>=10000,"15%",B2>=7000,"10%",B2>=4000,"5%",TRUE,"0%")
The top sales tier returns the rate “15%”, the next tier down returns “10%”, and the third returns “5%”. The catch-all returns “0%” for anyone under the lowest threshold.
These rates are text strings here, which is fine for a quick label. If you need to multiply by them later, store the numbers instead of the percent text.
Example 5: Group Ages Into Categories
Last one, sorting ages into life-stage categories.
Below is the dataset, names in column A and ages in column B, rows 2 to 6.
The goal is to label each person Child, Teen, Adult, or Senior by age.
Here is the formula:
=IFS(B2<13,"Child",B2<20,"Teen",B2<65,"Adult",TRUE,"Senior")
This time the conditions use less-than instead of greater-than, so the order runs from youngest up. A young age returns “Child”, then “Teen”, then “Adult”.
Anyone who passes all three tests reaches the catch-all and returns “Senior”. The youngest person here gets “Child” and the oldest gets “Senior”.
Tips & Common Mistakes
- Put your conditions in the right order. IFS returns the first true match, so a loose test placed early can grab values meant for a later band.
- Always add a
TRUEcatch-all at the end. Without it, a value that matches no condition returns an #N/A error instead of a fallback result. - For mapping a single code or number to a label, CHOOSE is often simpler. Reach for IFS when you’re testing ranges or several different conditions.
IFS is the function to reach for when one value needs checking against several conditions in order. It reads far cleaner than stacking IF inside IF.
It works for grades, bands, tiers, and labels, and as long as you end with a TRUE catch-all, every value gets a sensible result.
List of All Google Sheets Functions
Related Google Sheets Functions / Articles: