Yes. In Google Sheets, you can use multiple IF statements by nesting one IF inside another, or use IFS to test several conditions in order. With a score in B2, this nested formula returns a grade; for a score of 84, the result is B: =IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C","Needs review"))).
Which approach is best depends on whether you need several decision branches, combined tests, or separate results in different cells. Understanding the order in which Sheets checks conditions makes these formulas easier to build and troubleshoot.
What “multiple IF statements” means
The phrase usually refers to one of two things. A nested IF formula puts an IF inside another IF, so the formula can choose among more than two outcomes. Alternatively, a sheet may contain several separate IF formulas, each making its own decision in a different cell or row. Both are valid; nested IFs are the usual answer when one cell needs to return one of several results.
A basic IF makes a two-way choice: it checks a condition and returns one result if it is true and another if it is false. To add another decision, the false-result part can contain a second IF. That second IF can have its own true and false results, and the pattern can continue for additional branches.
Basic IF syntax in Google Sheets
The syntax is IF(logical_expression, value_if_true, value_if_false). The logical expression is a test, such as whether a score is at least 70 or a status cell contains the word Paid. The two result arguments can be text in quotation marks, numbers, cell references, or other formulas. If the result should be text, enclose it in straight double quotation marks.
The final argument is optional. If it is omitted and the condition is false, Sheets returns FALSE. In practical formulas, it is often clearer to state the false result explicitly, especially when it should be blank or a readable message. For example, with a delivery status in A2, this returns Ready only when A2 says Complete and otherwise returns an empty cell: =IF(A2="Complete","Ready","").
Google Sheets formulas normally use commas between arguments, as in the examples here. Depending on the spreadsheet’s locale, it may expect semicolons instead. If a formula gives a parse error despite having balanced parentheses, check the file’s locale under File > Settings and use the separator it expects.
Build a nested IF formula step by step
Suppose a teacher wants to assign grade bands from a score. Write the first test, then put another IF in the false-result position to handle scores that did not meet the first threshold. With the score in B2 and a score of 68, this formula returns Review:
With the score in B2, use: =IF(B2>=90,"Excellent",IF(B2>=75,"Pass",IF(B2>=60,"Review","Fail"))). For B2 equal to 68, the first test is false, the second is false, and the third is true, so the result is Review.
Read the formula from the outside inward. A score of 90 or more returns Excellent immediately. If that test fails, the next IF checks for at least 75; if that also fails, the third IF checks for at least 60. Anything that fails all three tests reaches the final result, Fail. That final value is the default outcome, not another condition.
To apply the formula to other rows, place it in the first result row and use the fill handle to copy it down. Relative references such as B2 adjust to B3, B4, and so on. If the formula must always refer to one fixed cell while filling, use dollar signs to make an absolute reference, for example $B$2.
Use IFS for a list of conditions
IFS can be easier to read when there are several conditions and each has a corresponding result. It tests condition-result pairs in order and returns the result paired with the first condition that evaluates to TRUE. The same score bands can be written with IFS. With the score in B2, a value of 68 returns Review:
=IFS(B2>=90,"Excellent",B2>=75,"Pass",B2>=60,"Review",TRUE,"Fail")
The final TRUE condition acts as a catch-all. It ensures there is a result if the score is below 60. Without a condition that covers the remaining possibilities, IFS returns #N/A when none of its conditions is true. A catch-all is particularly useful when inputs may be blank or outside the expected range, though you should decide deliberately what those cases should display.
IFS does not make the tests independent of their order. If several conditions are true, it returns the result for the first true condition. For threshold bands, put the most restrictive or highest threshold first, as in the example. IFS is more compact than a deeply nested IF, but a nested IF may be more familiar to collaborators or useful when a branch itself needs additional logic.
Combine tests with AND and OR
Sometimes a branch depends on more than one fact. AND returns TRUE only when every condition inside it is true; OR returns TRUE when at least one condition is true. They can be placed inside IF’s logical-expression argument, rather than using another nested IF for every test.
With a score in B2 and a completion status in C2, this formula approves a record only when the score is at least 80 and the status is Complete. If B2 is 86 and C2 contains Complete, the result is Approve:
=IF(AND(B2>=80,C2="Complete"),"Approve","Check")
With a payment method in C2, this formula marks a record for review if the method is Cash or Wire. If C2 contains Wire, the result is Review:
=IF(OR(C2="Cash",C2="Wire"),"Review","Standard")
AND and OR can also be combined with nested IFs or IFS when there are several branches. Keep each test understandable: a long formula mixing many conditions is harder to check than a few clearly named helper columns.
Put conditions in the right order
A formula can be syntactically correct and still produce the wrong answer if conditions overlap or are ordered poorly. For instance, if a score of 95 meets both “at least 70” and “at least 90,” then a test for at least 70 placed first captures it before Sheets ever reaches the higher band. Put higher cutoffs first when assigning descending score bands.
Also decide how to handle boundary values. In the grade example, 90 is included in Excellent because the formula uses >=90; 89 is not. The next threshold includes 75, while 74 falls through to the next test. Using > instead of >= changes whether the boundary itself qualifies. Before copying a formula, check values immediately below, exactly at, and immediately above each cutoff.
Blank cells deserve attention too. In numerical comparisons, a blank may behave in ways that do not match the business rule a person expects. If an empty score should remain empty rather than receive a grade, add a blank check before the thresholds. With the score in B2, this returns a blank when B2 is empty and otherwise assigns a band:
=IF(B2="","",IF(B2>=90,"A",IF(B2>=80,"B","Below B")))
Choose between nested IF, IFS, and other tools
Use nested IF when the logic has a small number of branches, especially if later decisions depend on an earlier result. Choose IFS when you have a straightforward ordered list of condition-result pairs. Use AND or OR inside a condition when a single outcome depends on multiple tests. These functions solve different parts of the problem and can be combined when needed.
If the result is simply a category based on an exact value—such as mapping a short code to a label—SWITCH may be more readable than a string of equality checks. For example, it is designed to compare one expression against several possible values. It is less suitable than IF or IFS for ranges such as “greater than or equal to 80.”
If the goal is only to change a cell’s appearance, such as coloring low scores red, a formula that returns text may be the wrong tool. Use Format > Conditional formatting to apply visual rules while leaving the cell’s value intact. Conversely, use IF or IFS when the sheet needs to calculate a label, status, or other output that can be used elsewhere.
Common errors and ways to make formulas maintainable
- Missing parentheses: Each opening parenthesis needs a matching closing one. In a nested formula, count the IF functions and make sure each is closed.
- Text without quotation marks: Text results such as “Pass” need quotation marks. Cell references and function names do not.
- No fallback result: A nested IF should end with the intended default. An IFS formula should include a final catch-all if every possible input needs a result.
- Wrong comparison order: Put thresholds in an order that prevents a broad condition from claiming values meant for a narrower category.
- Unexpected blanks or spaces: A cell that looks empty may contain a space, and imported text may include extra spaces or inconsistent capitalization. Check the source values before rewriting the logic.
For a long decision tree, add brief labels to nearby cells or use helper columns to separate intermediate tests. This can make it easier to find which condition caused an unexpected result. Test representative cases—one for each branch, plus boundary values—before filling the formula over a large range. If several people maintain the sheet, keep outcome wording consistent and explain unusual rules in a note or adjacent documentation.
These functions are available in Google Sheets in a web browser. Excel also has IF, IFS, AND, and OR, so many basic formulas are similar between the programs, although separators can depend on regional settings in either application. If a workbook will move between programs, check the formulas and results after importing or exporting rather than assuming every spreadsheet feature behaves identically.
Frequently Asked Questions
Can I use more than one IF in a Google Sheets formula?
Yes. Put an IF inside another IF’s true-result or false-result argument to add decision branches. Use a final result for cases that do not meet any earlier condition.
Is IFS better than nested IF?
Neither is always better. IFS is often easier to scan for a simple sequence of condition-result pairs. Nested IF is flexible and familiar, and may be clearer when one branch contains a separate decision.
What happens if no IFS condition is true?
Sheets returns #N/A if none of the conditions evaluates to TRUE. Add a final catch-all pair, often TRUE followed by a default result, if you want to avoid that outcome.
Can I use AND or OR with IF?
Yes. Put AND or OR inside IF’s condition. AND requires all supplied tests to be true; OR requires at least one to be true.
Why does my formula show a parse error?
Check for missing parentheses, mismatched quotation marks, and the correct argument separator for the spreadsheet’s locale. Also confirm that text values are quoted and that each function has the required arguments.
Related
- What Number Column Is U in Excel?
- What Number Column Is Y in Excel? Find Its Position
- What Number Column Is Z in Excel?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Data Validation in Excel: Rules, Lists, and Setup TipsData validation in Microsoft Excel controls what users can enter in selected cells. In Excel for Microsoft 365…
- How to Delete a Blank Last Page in Microsoft Word QuicklyTo delete a blank last page in Word, show formatting marks with Home > Paragraph > Show/Hide ¶,…
- How to Find a Circular Reference in Excel Step by StepIn Excel for Microsoft 365 on Windows, select Formulas > Error Checking ▼, point to Circular References, then…
- Switch Excel Sheet View: Normal, Page Layout, and MoreTo switch an Excel worksheet’s display mode in Microsoft 365 for Windows, select View, then choose Normal, Page…
- How to Delete Subtotal Rows in Excel Without Losing DataTo remove subtotals created with Excel’s Subtotal command, click a cell in the list, choose Data > Subtotal,…
- Does Excel Online Have Goal Seek? What to Use InsteadNo. Excel for the web does not currently include the Goal Seek command, so you cannot run a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.