Google Sheets IFS Formula: Syntax, Examples, and Fixes

In Google Sheets, the IFS function checks conditions in order and returns the value paired with the first condition that is TRUE. For example, it can turn a score into a letter grade without stacking several IF functions; add a final TRUE condition when you want a clear result if none of the earlier conditions match.

What the IFS function does

IFS is useful when one cell or row needs to be classified according to several possible rules. It can assign a grade from a score, label an order by its status, or group a quantity into a range. Instead of writing one IF inside another, you provide condition-and-result pairs in sequence. Sheets tests each condition from left to right and returns the result associated with the first true one.

That order matters. If a value meets more than one condition, later matching conditions are not used. IFS is therefore a good fit for ordered rules such as “at least 90,” then “at least 80,” and so on. It is less suitable when you need to combine several independent results or calculate multiple outputs from one row.

The function returns a single value for each formula cell. To apply the same classification to many records, enter the formula in the first row and copy it down, or use an array-based approach if your sheet and workflow call for one.

Syntax and evaluation order

IFS takes alternating arguments: a condition, the value to return if that condition is true, another condition, and its corresponding value. You can add more condition-and-result pairs as needed. Conditions can compare a cell with a number or text, or use functions such as AND to test multiple requirements together.

For example, a condition might ask whether a score is at least 80, while its paired result might be the text “B.” A condition can also test an exact match, such as whether a status cell contains “Paid.” The returned values do not all need to be the same type, although consistent output types usually make a result column easier to sort, filter, and use in later calculations.

IFS does not automatically provide a default result. If every condition is false, Google Sheets returns #N/A. A common way to prevent that is to end the list with TRUE and the fallback text or value you want. Because TRUE is always true, Sheets reaches it only after all preceding conditions have failed.

In the formulas below, commas separate arguments, as they do in the standard U.S. spreadsheet locale. If your Google Sheets locale uses semicolons as function argument separators, replace the commas with semicolons. The locale setting can affect formula separators even though the logic is unchanged.

Build a letter-grade formula

Suppose each student’s numeric score is in A2 and you want a letter grade in B2. Put the highest threshold first and work downward. This example treats scores below 60 as F and uses a final TRUE fallback so a blank or unexpected value does not produce #N/A.

With a student’s score in A2, enter this formula in B2. A score of 84 returns B; a score of 60 returns D; and a blank or other value that meets none of the numeric tests returns F.

=IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",A2>=60,"D",TRUE,"F")

This example illustrates why ordering is important. A score of 95 is also greater than or equal to 80, 70, and 60. Because the 90-point condition comes first, Sheets returns A immediately rather than continuing to the lower thresholds. If you put the 60-point condition first, every passing score would receive D.

Think carefully about the boundary values in your own grading scheme. The formula above uses greater-than-or-equal comparisons, so 90 belongs in A and 80 belongs in B. If your policy defines a different cutoff, edit the comparison operators or thresholds to match it. IFS follows the rules you write; it does not infer a grading standard.

Use IFS for status labels and grouped values

IFS also works well for text categories. Imagine that order status is recorded in B2, and you want a separate cell to explain what should happen next. Exact text comparisons are case-insensitive in Google Sheets, but the text still needs to match the cell’s contents apart from letter case. Extra spaces or different wording can cause a condition not to match.

With the order status in B2, enter this formula in the adjacent column. “Paid” returns “Ready to ship,” “Pending” returns “Awaiting payment,” “Refunded” returns “Do not ship,” and any other status returns “Check status.”

=IFS(B2="Paid","Ready to ship",B2="Pending","Awaiting payment",B2="Refunded","Do not ship",TRUE,"Check status")

You can also classify a quantity into named bands. Suppose units are in C2: a quantity of 20 or more is “Bulk,” 10 through 19 is “Medium,” and anything lower is “Standard.” Because the largest cutoff comes first, values are assigned to the intended group.

With the unit count in C2, this formula returns “Bulk” for 24, “Medium” for 12, and “Standard” for 8.

=IFS(C2>=20,"Bulk",C2>=10,"Medium",TRUE,"Standard")

For rules that require more than one fact, use AND inside a condition. For instance, a record might need both a particular region and a minimum number of units to receive a special label.

With the region in B2 and the unit count in C2, this formula returns “Priority” for North with at least 100 units, “Review” for South with at least 100 units, and “Standard” in all other cases.

=IFS(AND(B2="North",C2>=100),"Priority",AND(B2="South",C2>=100),"Review",TRUE,"Standard")

Put conditions in the right order

For threshold rules, list the most restrictive or highest threshold first, then move toward broader conditions. For exact-match categories, the order may not matter if the categories cannot overlap, but it still matters if conditions include broader tests such as “contains” or ranges.

Check overlapping rules. Ask whether one value could satisfy two conditions. If it can, make sure the condition that should take priority appears first.
Decide what should happen when nothing matches. Use a final TRUE condition for a default label, or leave it out only when #N/A is an intentional signal that the input needs attention.
Define your boundaries. Decide whether a cutoff includes the exact value by choosing > or >=, and make sure there are no gaps between ranges.
Test edge cases. Check values just below, exactly at, and just above each cutoff, along with blanks and unexpected text.

A useful way to review a long IFS formula is to read each pair aloud: “If this is true, return this.” Then check that the first true condition for each realistic input is the result you intend. This simple review catches many mistakes that are hard to spot in a long string of punctuation.

Handle blank cells and unmatched values

A fallback value solves the no-match error, but it does not always give the desired treatment to blank input. In a numeric grading formula, a blank cell can behave like zero in comparisons, which may cause the formula to return a grade rather than leave the result blank. If an empty input should produce an empty output, test for the blank first and run IFS only when there is a value.

With a score in A2, this formula leaves the result blank when A2 is blank; otherwise it assigns a grade using the same thresholds. For a score of 84 it returns B, and for an empty A2 it returns an empty string.

=IF(A2="","",IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",A2>=60,"D",TRUE,"F"))

For text categories, a blank status may fall through to the final TRUE condition and return “Check status.” That can be useful if a missing status should be investigated. If blank means “not entered yet,” handle it separately so the sheet does not show a warning for every unused row. Also distinguish a genuinely empty cell from a formula that returns an empty string if your wider workflow depends on that difference.

If the result is #N/A, check whether all conditions can be false and whether you included a fallback. If the result is unexpected, inspect the source value for spaces, text stored where a number was expected, or cutoffs in the wrong order. A fallback can make a formula cleaner, but a broad fallback such as “Other” may also hide inconsistent source data, so choose a label that communicates what the outcome means.

IFS compared with IF and SWITCH

Use IFS when you have several different conditions and want the result for the first one that is true. It is generally easier to scan than deeply nested IF functions because each condition-result pair sits at the same level. Nested IF can still be useful for compatibility with older spreadsheet tools or for logic that needs a different structure, but long chains can be difficult to edit without accidentally changing parentheses or pairing the wrong result.

Use SWITCH when one expression is being compared against a list of exact values, such as a code that can be “A,” “B,” or “C.” IFS is more flexible for ranges and comparisons such as greater than or less than. Neither function is automatically better: choose the one that best describes the rule and will be easiest for another person to maintain.

Use AND or OR within an IFS condition when a single outcome depends on multiple tests. AND requires all its tests to be true; OR requires at least one. IFS then chooses among those combined conditions in order. If you need to return several separate results, rather than one result for the first matching rule, consider whether a lookup table or a different formula structure is more appropriate.

Google Sheets and Excel both include an IFS function, but this page describes entering formulas in Google Sheets in a web browser. Spreadsheet locale settings can affect separators, and formulas or features beyond IFS can vary between spreadsheet programs. If a sheet will be shared with Excel users, confirm that its formulas and any surrounding functions behave as expected in the recipient’s version.

Enter, copy, and maintain the formula

Click the cell where you want the result, type an equals sign and the formula, and press Enter. To apply it to later rows, select the formula cell and drag its small fill handle down the column, or copy and paste it into the target range. Relative references such as A2 usually adjust to A3, A4, and so on as the formula is copied. If a threshold or lookup value is stored in another cell and must stay fixed, use an absolute reference with dollar signs, such as $F$1.

Keep the input data and output labels consistent. If a formula checks the word “Pending,” use the same spelling in the source column, and consider a dropdown list when people are entering statuses manually. A dropdown can reduce typos, while IFS can still provide the resulting label or action. For a large set of changing categories, keeping the rules in a small reference table may be easier to maintain than editing a very long formula every time a category changes.

Before filling a formula down hundreds of rows, test representative examples, including blank cells and boundary values. If you later revise the rule, update the formula and recheck those same cases. A short note in a nearby heading or cell can also explain what the labels mean, especially when a fallback such as “Review” is intended to trigger a human check rather than represent a final classification.

Frequently Asked Questions

What does IFS mean in Google Sheets?
IFS means the function checks multiple conditions and returns the value associated with the first condition that evaluates to TRUE. It is useful for ordered rules such as score bands or status labels.

What happens if no IFS condition is true?
Sheets returns #N/A when every condition is false and there is no fallback. Add a final TRUE condition paired with a result such as “Other” or “Check input” if you want a default outcome.

Can I use AND or OR in an IFS formula?
Yes. Put AND or OR inside a condition when a rule depends on multiple tests. IFS still evaluates the resulting conditions from left to right and returns the result for the first true condition.

Why does my IFS formula return the wrong category?
Check whether an earlier condition is broader than a later one, whether your thresholds include the intended boundary values, and whether the input has unexpected spaces or data types. Test values at each cutoff to reveal overlaps or gaps.

How do I make IFS return blank for an empty input?
Test whether the input cell is blank before evaluating IFS, using an IF wrapper. That prevents an empty numeric cell from being classified by a comparison that treats it like zero.

Is IFS better than nested IF?
For several ordered condition-result pairs, IFS is often easier to read and update. Nested IF remains an option when you need its particular structure or compatibility with another environment. Choose based on the logic and the people who will maintain the sheet.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.