IF vs IFS in Google Sheets: Which Formula Should You Use?

In Google Sheets, use IF to test one condition and return one result when it is true and another when it is false; use IFS to test several conditions in order and return the result for the first one that is true. For a single yes-or-no decision, choose IF; for several ordered outcomes, IFS is usually easier to read.

What IF and IFS mean

IF and IFS are both logical functions: they let a formula choose an output based on whether a test is true. The difference is how many alternatives the formula handles directly. An IF has one logical test and two possible paths. An IFS can check multiple tests and pair each test with a result.

The name can be confusing: IFS is a specific function name, not simply the plural of IF. Capitalization does not change how Google Sheets interprets function names, so IF, if, and If work alike. The function’s arguments, however, must be arranged correctly.

Both functions are available in Google Sheets in a web browser. You enter them in a cell just like other formulas, beginning with an equals sign. If Sheets displays a formula parse error, check the punctuation and the order of the arguments before assuming the function is unavailable.

How IF works

The basic syntax is IF(logical_expression, value_if_true, value_if_false). The logical expression is the test, such as whether a score is at least 70. Sheets evaluates that test and returns the second argument if it is true, or the third if it is false. The results can be text, numbers, cell references, or other formulas.

Suppose a class score is in B2. With the score in B2, this formula returns “Pass” for a score of 70 or higher and “Review” otherwise: =IF(B2>=70,"Pass","Review"). For a score of 82, the result is Pass; for 64, it is Review. The comparison operator >= includes 70 itself.

An IF does not have to return different values in its two branches. You could return a number in one branch and text in the other, or perform a calculation only when the test is met. If the false result is omitted, Google Sheets returns FALSE when the test is false, so it is often clearer to state both outcomes explicitly.

How IFS works

The syntax is IFS(condition1, value1, [condition2, value2, ...]). Each condition is followed by the value to return if that condition is true. Sheets checks the conditions from left to right and returns the value paired with the first true condition. It does not continue on to return later matching results.

For a grading scale, assume a student’s numeric score is in B2. This formula checks the highest grade threshold first: =IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",B2>=60,"D",B2<60,"F"). With a score of 84, it returns B: the first condition is false and the second is true. With 58, it returns F.

The order matters because ranges can overlap. A score of 95 is also at least 80, 70, and 60, but the first test is already true, so the formula returns A. If the 80-point test came first, a 95 would receive B. Put the most specific or highest-priority condition first, and check that the sequence reflects the outcome you intend.

Choosing between IF and IFS

Choose based on the shape of the decision, not just the number of characters in the formula. Use IF when there are two outcomes, such as eligible/not eligible, late/on time, or a discount/no discount. It makes the two branches visible and is easy to explain to someone reviewing the sheet.

Use IFS when you have three or more alternatives that can be expressed as a list of tests: for example, a service tier based on monthly usage or a priority label based on a score. It avoids stacking many IF functions inside one another. That can make future changes less error-prone, especially when someone needs to insert a new outcome in the middle of a long decision.

One test and two outcomes: start with IF.
Several conditions with different results: consider IFS.
Several conditions that all lead to the same result: consider combining the tests with OR or AND inside one IF.
A lookup table of many categories or thresholds: consider whether a lookup-based design would be easier to maintain than a long formula.

For example, if a row is marked urgent when either its status is “Blocked” or its due date is before today, those are two tests that share one output. That is not necessarily an IFS problem: putting both tests in IFS with duplicate results adds repetition. Think first about whether you are choosing between distinct outcomes or checking several ways to trigger the same outcome.

Nested IF compared with IFS

Before IFS is available in a spreadsheet application, several outcomes can be represented by placing an IF inside another IF. Google Sheets supports nested IF formulas too. With the score in B2, this version gives the same A, B, C, or “Needs review” result for scores of 70 or above: =IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C","Needs review"))). For 74, it returns C.

The nested formula is valid, but each added decision creates another layer of parentheses and another place to make a mistake. The equivalent IFS formula is =IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",TRUE,"Needs review"). With the same score of 74, it also returns C. This example uses TRUE as a final catch-all: because TRUE is always true, it supplies a result when none of the earlier tests matched.

The catch-all is especially useful if the conditions do not cover every possible input. Without a final true condition, an IFS formula returns the #N/A error when no condition is true. You can instead include a specific final condition, such as a test for a score below 60, when that is more informative than a general fallback.

Common errors and edge cases

The most common IFS surprise is #N/A. It usually means that none of the listed conditions evaluated to true. Review the full range of possible inputs, including blanks and unexpected text, then decide whether to add an explicit final condition or a TRUE fallback. Do not add a fallback automatically if an unmatched value should be flagged for investigation.

Blank cells deserve deliberate handling. In a numeric comparison, a blank can behave in a way that does not match a reader’s expectation, and a formula might assign it a category unintentionally. If blank means “not entered yet,” test for that first. With a score in B2, this formula leaves the result blank when B2 is empty and otherwise assigns a result: =IF(B2="","",IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",TRUE,"Needs review")). For a blank B2, the result is a blank display; for 74, it is C.

Also check whether the test itself is appropriate. Comparing text with a number, referencing the wrong row, or using > where you meant >= can produce a plausible but incorrect result. When copying a formula down a column, relative references such as B2 adjust to B3, B4, and so on. Use dollar signs for a reference that should stay fixed, such as $B$2, and verify a few rows after filling the formula down.

In the Sheets browser interface, select a cell and type the formula in the cell or formula bar, then press Enter. If the formula is treated as text, check for an apostrophe before the equals sign or a plain-text cell format. Some spreadsheet locales use semicolons instead of commas between arguments; if Sheets rejects a correctly structured comma-separated formula, check the spreadsheet’s locale and the separator it expects. The examples here use commas.

Alternatives for larger rule sets

A long IFS can be appropriate when the rules are short and unlikely to change. If the thresholds, labels, or exceptions are maintained by other people, placing the rules in a small table may be easier to audit than embedding them in a formula. A lookup approach can keep business rules visible as ordinary data, but its setup depends on whether the categories are exact matches or ordered thresholds.

For a small number of exact-value choices, Google Sheets also has SWITCH, which compares one expression with possible values and returns the associated result. It is designed for matching values, not for testing a sequence of inequalities such as “at least 90.” For that kind of ordered range test, IFS or a carefully designed lookup is generally a more natural fit.

Another option is to use conditional formatting when the goal is only to change how a cell looks, not to calculate a label or value. In Google Sheets, open Format > Conditional formatting to create visual rules. Conditional formatting changes appearance; it does not replace an IF formula when another cell needs to contain the result of the decision.

Google Sheets and Excel differences

The core IF and IFS examples shown here also use syntax supported by modern Microsoft Excel. The basic decision logic is therefore familiar if you move a sheet between Google Sheets and Excel. However, menus, locale settings, and some function behavior or availability can differ between spreadsheet products and versions. This page’s instructions refer to Google Sheets in a web browser, not Excel’s ribbon.

Do not assume that a formula copied from a web example will use the right separators for every spreadsheet locale. Also be cautious when a workbook contains other functions or features that are not shared across products. If a file is important, verify key formulas and results after converting or opening it in a different spreadsheet application.

Frequently Asked Questions

Is IFS better than IF in Google Sheets?
Neither is universally better. IF is usually clearer for one test with two outcomes. IFS is often easier to read when several conditions each have their own result.

What happens if no IFS condition is true?
Google Sheets returns #N/A if every condition is false. Add a final condition and result for the remaining cases, or use TRUE as a catch-all if every unmatched input should receive the same fallback.

Can I put IF inside IFS or IFS inside IF?
Yes. These functions can be combined when the decision genuinely needs multiple layers. Keep the formula understandable, and consider splitting complicated logic into helper columns or a rules table so it is easier to inspect.

Does IFS check every condition?
It checks conditions in order and returns the result associated with the first true one. Later matches do not replace that result, so order overlapping conditions from highest priority to lowest.

Why does my Google Sheets formula show a parse error?
Check that every condition has a paired result, parentheses are balanced, text values are enclosed in straight double quotes, and the argument separator matches your spreadsheet locale. Also confirm that the formula begins with =.

Should I use IFS for multiple conditions that share one result?
Not necessarily. If several tests lead to the same outcome, one IF with an OR or AND test may be more concise. Use IFS when different conditions need different returned values.

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.