Google Sheets IFS Function: Syntax, Examples, and Tips

Google Sheets’ IFS function checks conditions in order and returns the value paired with the first condition that is TRUE. Use it to replace a long chain of nested IF functions; add TRUE as the final condition when you want a default result instead of an error if nothing else matches.

What the IFS function does

IFS is a conditional function for choosing among several possible results. Each rule consists of a test and the result to return if that test is true. The function checks the tests from left to right, stops at the first true one, and returns its paired result. It does not continue evaluating later rules to look for a “better” match.

This makes IFS useful for grading scores, assigning labels to order amounts, sorting dates into categories, and applying other ordered rules. It is especially helpful when you would otherwise put one IF function inside another, creating a formula that is difficult to read and edit.

IFS does not automatically supply a result when every condition is false. Without a final catch-all condition, Google Sheets returns #N/A. A common fix is to make the last condition TRUE and pair it with a fallback such as “Other,” “Review,” or a blank result.

How the syntax and evaluation order work

An IFS formula needs at least one condition/result pair. Add more pairs as needed, keeping each condition immediately before the result it controls. Conditions are usually comparisons, such as a score being greater than or equal to a cutoff, or a status cell matching a particular word. Results can be text, numbers, references to other cells, or values produced by another formula.

Order matters whenever conditions overlap. For example, a score of 92 is also greater than or equal to 80 and 70. If the 70-point condition comes first, Sheets returns that condition’s result and never reaches the 90-point rule. Put the most specific or highest-priority rule first, then arrange the remaining rules so that the first match is the one you intend.

Think of IFS as a first-match decision list, not as a set of independent rules. Before using it, write down what should happen for values at the boundaries as well as values in the middle. That small check helps prevent gaps, overlaps, and rules that are technically valid but ordered incorrectly.

Example: assign a grade from a score

Suppose scores are in A2:A20 and you want a letter grade in the next column. With the score for the current row in A2, enter this in B2:

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

If A2 contains 92, the result is A: the first test is true. If A2 contains 84, the 90-point test is false and the 80-point test is true, so the result is B. A score of 59 reaches the final TRUE condition and returns F. The formula also covers every numeric score below 60, rather than leaving those values unmatched.

The thresholds use greater-than-or-equal comparisons, so a score of exactly 90 receives A, exactly 80 receives B, and exactly 60 receives D. If your grading policy uses different cutoffs, change the numbers to match it. The formula only applies the rules you give it; it does not know your organization’s grading scale.

After entering the formula in B2, use the fill handle to copy it down for the remaining rows. Because A2 is a relative reference, it changes to A3, A4, and so on as the formula is filled. If the score is stored in a different column, update that reference before copying.

Set a default and handle blank cells

A final TRUE condition is a simple way to provide a default result. TRUE is always true, so it acts as the last resort after all the earlier tests fail. In the grade example, that fallback returns F. For a product list, a fallback might return “Uncategorized”; for a review workflow, it might return “Check manually.” Choose wording that makes an unexpected or uncategorized value visible to the person using the sheet.

Blank inputs need a decision of their own. If a score cell is empty, you may not want the formula to label it as an F. With scores in A2:A20 and the current score in A2, put a blank check first:

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

If A2 is empty, this formula returns an empty string, which displays as a blank cell. If A2 contains 92, it returns A. The empty-string result is not the same as a genuinely empty cell: the formula is still present, and other functions may treat its result differently from a cell that was never filled. Also, a cell containing spaces is not necessarily empty for this test; remove unwanted spaces from the input if they are causing unexpected results.

Put special cases such as blanks before broad numeric comparisons. More generally, decide what should happen with text entered in a score column, error values, or numbers outside the expected range. A well-designed rule handles those cases deliberately rather than relying on a fallback that could hide an input problem.

Use AND and OR for compound rules

Sometimes one rule depends on more than one fact. Google Sheets’ AND function can combine requirements that must all be met; OR can combine alternatives where any one is enough. These functions can be used inside an IFS condition, while IFS still decides which result to return first.

Suppose scores are in A2:A20 and completion statuses are in B2:B20. With the current score in A2 and status in B2, this rule returns Pass only when the score is at least 80 and the status is Complete:

=IFS(AND(A2>=80,B2="Complete"),"Pass",TRUE,"Review")

For example, A2 equal to 84 and B2 equal to Complete returns Pass. A score of 84 with a status of Incomplete returns Review. Here the final TRUE condition catches every combination that does not meet both requirements. You could use OR instead if either of two conditions should qualify, but make sure the wording of the result matches that looser rule.

IFS compared with IF and SWITCH

Use IF for a simple two-way choice, such as returning “Late” when a date has passed and “On time” otherwise. IF can also handle many choices by nesting one IF inside another, but each added level makes the formula harder to scan and increases the chance of mismatched parentheses or incorrect branches. IFS lays those alternatives out as a sequence of condition/result pairs, which is often clearer for multiple ranges or rules.

IFS is not always the shortest option. If you are comparing one expression against a list of exact values, SWITCH may be easier to understand. For example, a status code that is exactly “N,” “P,” or “C” can be mapped to a label using a single expression and several exact-value cases. IFS is usually a better fit when the conditions use ranges, comparisons, or different tests. Whichever function you choose, ensure that unmatched values have an intentional outcome.

Google Sheets and Excel both support IFS, and the basic function logic is similar in each. The formula examples here are for Google Sheets in a web browser; the same ordinary IFS examples generally work in Excel as well. Excel’s menus and interface differ, and formula separators can depend on regional settings in either program. In Google Sheets, a locale that uses semicolons as argument separators may require semicolons in place of the commas shown here.

Common IFS problems and how to fix them

#N/A appears: Every condition was false. Add a final TRUE condition and a suitable result, or correct the conditions so they cover the values you expect.
The wrong category appears: Check the order. An earlier, broader condition may be catching values before the intended rule. Move the higher-priority rule earlier or narrow the overlapping condition.
A boundary score gets the wrong grade: Check whether you used > or >=. The first excludes the cutoff itself; the second includes it. Confirm the desired treatment of every threshold.
The formula reports a parsing error: Check that every condition has a paired result, that text is enclosed in straight double quotation marks, and that the separators match your spreadsheet’s locale.
Blank-looking rows receive a category: Add an empty-cell check before the other rules. If the source cell contains a formula returning an empty string, test that situation too; visible blanks can have different underlying contents.
Text or errors produce unexpected results: Check the input column for values that do not match the type your comparisons expect. Use a deliberate validation or exception rule rather than assuming every entry is a valid number.

When troubleshooting, test the formula with one value from each category, each exact cutoff, and at least one value that should use the fallback. This is more reliable than checking only a typical case because most logic errors happen at boundaries or in unanticipated inputs.

Practical tips for maintaining an IFS formula

Keep the rules readable. Put each meaningful condition/result pair in a consistent order, and use labels that explain the result to the sheet’s audience. If the rules change often or the list becomes very long, a separate lookup table may be easier for colleagues to maintain than editing a large formula. A table also lets someone review the thresholds and labels without parsing formula syntax.

Consider protecting the formula column if other people will enter data in the sheet, so a paste or accidental keystroke does not replace the classification logic. Test changes on a few rows before filling them down across a large dataset. If you copy the formula to another location, check whether its cell references should move with it or be fixed with absolute references. These habits help keep the result consistent as the sheet grows.

Frequently Asked Questions

Does Google Sheets have an IFS function?
Yes. IFS is a built-in Google Sheets function. It checks condition/result pairs from left to right and returns the result paired with the first true condition.

What happens if no IFS condition is true?
Sheets returns #N/A if all supplied conditions are false. Add a final TRUE condition with a fallback value when you want a result for otherwise unmatched inputs.

Can I use AND or OR inside IFS?
Yes. AND can combine requirements that must all be true, and OR can combine alternatives. Place the combined test where a condition goes, then pair it with the result to return when that test succeeds.

Is IFS better than nested IF?
For several ordered conditions, IFS is often easier to read because it lists each test and result together. For a single yes-or-no decision, IF is usually simpler. The clearer option depends on how many rules you have and whether they are ranges or exact matches.

Can I use IFS for ranges such as score bands?
Yes. Use comparison conditions such as greater than or equal to a cutoff, and order overlapping ranges carefully. Check exact boundary values so each one receives the intended category.

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.