Google Sheets Multiple IFs: Formulas and Better Options

How-to basics · Updated November 21, 2026

To use multiple IF conditions in Google Sheets, nest one IF function inside another, or use IFS to test several conditions in order. For example, a score-grading formula can check the highest cutoff first and return the matching grade; choose IFS when the rules are easier to read as a list, and nested IF when you need explicit branching.

What “multiple IFs” means in Google Sheets

A basic IF checks one condition and returns one result when it is true and another when it is false. Multiple IFs add more possible outcomes. You might classify scores into grades, label orders by status, or assign a shipping category based on an order total.

Google Sheets has no separate function named “multiple IF.” The usual approaches are to put an IF inside another IF, use IFS for a sequence of tests, or choose a different function such as SWITCH when you are matching one value against several exact choices. These functions are available in Google Sheets in a web browser. Excel also has IF, IFS, and SWITCH, though menus and some spreadsheet settings differ between the programs.

How nested IF formulas work

In a nested formula, the false-result argument of one IF contains another IF. Sheets checks the first condition. If it is true, Sheets returns that condition’s result and stops; if it is false, it moves to the next IF. The order matters, especially when the conditions are ranges that overlap.

With a student’s numeric score in A2, this formula assigns a grade:

=IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C","Needs review")))

If A2 contains 84, the result is B: 84 is not at least 90, but it is at least 80. A score of 72 returns C, while a score of 65 returns Needs review. The final text is the fallback result when none of the earlier thresholds is met.

For score ranges, put the highest threshold first and work downward. If the 80-point test came before the 90-point test, a score of 95 would satisfy the 80-point condition and return B before Sheets ever checked for an A. This “first true condition wins” behavior is a common source of incorrect results.

Using IFS as a readable alternative

IFS takes condition-and-result pairs in sequence. It can make a long chain easier to scan because the conditions are not buried inside one another. Using the same score in A2, the equivalent formula is:

=IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",TRUE,"Needs review")

For an A2 value of 84, this also returns B. The final TRUE acts as a catch-all: it is always true if Sheets reaches it, so the formula returns Needs review when no earlier score rule matched. Without a final fallback, IFS returns #N/A if every condition is false. Include a fallback when all possible inputs should produce a result.

Like nested IF, IFS tests its conditions from left to right and returns the result for the first true condition. It does not make badly ordered thresholds correct; arrange the rules carefully. Use nested IF if different branches need more complicated logic, or IFS when the rules are a straightforward sequence of tests.

Combining conditions with AND and OR

Sometimes a result depends on more than one fact. Put AND or OR inside the IF condition to combine tests. AND is true only when every test is true; OR is true when at least one test is true.

Suppose B2 contains an order total and C2 contains its payment status. This formula marks an order eligible only when its total is at least 1,000 and its status is Paid:

=IF(AND(B2>=1000,C2="Paid"),"Eligible","Not eligible")

With B2 equal to 1,250 and C2 equal to Paid, the result is Eligible. If the total is 1,250 but the status is Pending, the result is Not eligible because both AND conditions must be true. To accept an order that meets either of two alternatives, use OR instead.

With a request type in A2, the following returns Priority when the request is either Urgent or Escalated:

=IF(OR(A2="Urgent",A2="Escalated"),"Priority","Standard")

For a more complex rule, nest AND or OR within an IFS condition, or combine them in a nested IF. Parentheses help show which tests belong together. Before using a formula for consequential classifications, write the rule in plain language and verify a case where each condition is true as well as cases where it is false.

When SWITCH is a better fit

If one cell contains a label or code and each exact value maps to a different result, SWITCH can be clearer than multiple IFs. For example, with an order status in A2:

=SWITCH(A2,"New","Open","In progress","Active","Done","Closed","Unknown status")

If A2 contains In progress, the result is Active. SWITCH compares A2 with each listed value and returns the associated result for the first match. Its final argument, Unknown status, is the default if no match is found. Without a default, an unmatched value produces #N/A.

SWITCH is for matching a value against alternatives, not for testing a sequence of inequalities such as “at least 90.” For ranges, use IFS or nested IF. For a small number of exact choices, SWITCH can make the mapping more obvious to someone maintaining the sheet later.

Build and check a multiple-IF formula

A careful setup makes formulas easier to troubleshoot. Before writing the expression, decide what input is being tested, what each outcome should be, and what should happen when no rule applies. Then build the formula from the simplest condition outward.

  1. List the rules in the order they should be evaluated. For overlapping numeric ranges, put the most restrictive or highest cutoff first.
  2. Choose the structure: nested IF for explicit branches, IFS for sequential conditions, or SWITCH for exact-value mappings.
  3. Enter the formula in the result cell and check that text results are enclosed in straight double quotes and parentheses are balanced.
  4. Test boundary values, such as 69, 70, 79, 80, 89, and 90 for the grade example. These reveal off-by-one errors that an ordinary value may not expose.
  5. Check blank cells, unexpected labels, and values outside the expected range. Add a fallback or a separate blank check if those inputs need a distinct result.
  6. Copy the formula down a few rows and confirm that the cell references change as intended. Use dollar signs in references only when a row or column must stay fixed.

In Google Sheets, formulas are entered directly in a cell or in the formula bar. If a formula is rejected despite having the right logic, check the spreadsheet’s locale: some locales use semicolons instead of commas between function arguments. The examples here use commas. Locale settings can also affect number and date interpretation, so confirm how the sheet reads values before relying on comparisons.

Common errors and practical fixes

A formula can be syntactically valid yet return an unexpected answer. The most useful check is to compare the result with the exact input and the first condition that should match.

  • Wrong condition order: A broad test can capture values intended for a later rule. Put higher cutoffs first for descending grade bands, then test one value around every boundary.
  • No fallback: An IFS or SWITCH formula without a final default can return #N/A when nothing matches. Add a final TRUE condition to IFS or a default result to SWITCH if that is the intended behavior.
  • Text that does not match: A status such as “In progress” will not match “In Progress” as an exact string if the spelling or spacing differs. Check for extra spaces, inconsistent labels, and data-entry variations.
  • Numbers stored as text: A value that looks like 80 may be text rather than a number, affecting numeric comparisons. Check the source data and convert or clean it if needed.
  • Blank cells receiving an unintended label: A blank score can fall through every threshold and receive the fallback result. If blanks should remain blank, add a blank check at the beginning of the logic.
  • Unbalanced parentheses or quotes: Nested formulas are easy to mistype. Build the formula gradually and make sure each opening parenthesis has a closing one and each text result has paired straight quotes.

For example, if an empty score should show an empty result instead of Needs review, add an initial test for whether A2 is blank. The important point is to decide how blanks should behave; otherwise, the fallback may make missing data look like a genuine category.

Choosing the right approach

There is no single best formula for every case. The best choice is usually the one that makes the rule easiest to read, check, and update. A short two-way decision needs only IF. A long set of score bands often suits IFS. Exact status mappings may be clearest with SWITCH. AND and OR are useful additions when a rule depends on several facts at once.

When the rules become extensive or change frequently, consider storing the rules in a separate lookup table rather than adding ever more branches to one formula. A table is easier to review and update, particularly when nontechnical collaborators maintain the sheet. For a large or complicated decision process, splitting the logic into helper columns can also make each step visible and easier to debug. Keep the original rule set documented so that a shorter formula does not obscure what the spreadsheet is deciding.

Frequently Asked Questions

How many IF functions can I nest in Google Sheets?

Google Sheets allows nested functions, but a deeply nested formula can be difficult to read and maintain. For a simple sequence of alternatives, use IFS or SWITCH where appropriate, or put parts of the logic in helper columns. If a formula is close to a product or spreadsheet limit, consult Google Sheets’ current function and file limits rather than assuming there is no limit.

Is IFS better than nested IF?

Neither is always better. IFS is often easier to scan when you have several independent conditions checked in order. Nested IF can express explicit true and false branches and may suit more complex branching. Both depend on condition order, and both need sensible handling for inputs that do not match.

Can I use multiple conditions in one IF?

Yes. Use AND when all included tests must be true, or OR when any one of them is enough. Put that function inside IF’s condition, then provide the true and false results. This differs from chaining IF functions, which generally tests separate alternatives in sequence.

Why does my multiple-IF formula show #N/A?

One common cause is an IFS formula in which none of the conditions is true, or a SWITCH formula with no matching value and no default. Add a catch-all result if unmatched inputs should have a label. Also check whether a value is blank, misspelled, or stored in a different form than expected.

Can I use these formulas in Excel too?

IF, IFS, SWITCH, AND, and OR are also available in current Excel versions, and the basic logic is similar. Menu paths are not relevant to entering these formulas, but argument separators can vary with locale in either program. If you move a sheet between Google Sheets and Excel, check the formulas and results in the destination application.

Related

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.