Google Sheets IFS: How to Handle Blank Cells

In Google Sheets, handle a blank in IFS by testing for it before your other conditions; for example, with the value to check in A2, use =IFS(A2="","Blank",A2>=10,"At least 10",TRUE,"Under 10"). The test A2="" catches an empty cell and a formula result of an empty string, while ISBLANK(A2) checks only whether the cell is truly empty.

What IFS does in Google Sheets

IFS checks conditions in order and returns the value paired with the first condition that is TRUE. Its basic structure is IFS(condition1, value1, condition2, value2, ...). Each condition needs a corresponding result, and the function can contain several condition-and-result pairs. It is useful when you would otherwise nest multiple IF functions, such as when assigning a label based on a score or status.

The order matters. Once a condition is true, later conditions do not determine the result. If no condition is true, Sheets returns #N/A unless you include a final condition that catches the remaining cases. A common catch-all is TRUE, paired with a default result. This also makes the formula’s intended fallback visible to anyone who reads it.

For example, a status formula might first recognize an empty input, then check specific words, and finally return a general review label. That order is important because a broad condition placed too early can match before a more specific condition gets a chance.

Why a blank can produce an unexpected result

A cell that looks blank is not always empty. It may contain a formula that displays an empty string, spaces pasted from another source, or a value formatted so it is difficult to see. Meanwhile, a genuinely empty cell can behave like zero in some numeric comparisons. As a result, a condition such as A2<10 may be true when A2 is empty, even though you meant to classify only entered numbers.

That is why a numeric test alone is not a dependable way to identify missing input. If an empty score should stay unclassified, put an explicit blank check first. For a blank cell, the formula should return the blank-handling result before it reaches comparisons such as >=90 or <10.

There is another important distinction: returning "" from a formula makes the result display as blank, but the cell still contains a formula. It is not the same as deleting the formula or leaving the cell genuinely empty. This distinction can affect checks in other formulas and how data is counted or processed.

Put the blank test before other conditions

Use a blank condition as the first pair in IFS when missing input should take priority. With a status in A2, this formula returns a prompt for a blank and handles two named statuses before using a fallback:

With the status to check in A2, use:

=IFS(A2="","Enter a status",A2="Paid","Complete",A2="Pending","Follow up",TRUE,"Review")

If A2 is empty, the result is Enter a status. If it contains Paid, the result is Complete; if it contains Pending, the result is Follow up. Any other value returns Review. The final TRUE ensures the formula has a result for unexpected entries rather than returning #N/A.

For a score, you might prefer to leave the output visually blank until someone enters a value. With the score in B2, use:

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

An empty B2 displays as blank. Scores of 90 or more receive A, 80 through 89 receive B, and 70 through 79 receive C; lower values return Needs review. The higher thresholds come first so a score of 95 is not stopped by a lower threshold. If the score is stored as text rather than a number, numeric comparisons may not behave as intended, so check the source data as well.

Choose between an empty check and ISBLANK

Use A2="" when your practical question is “Does this cell have no visible value?” It is true for a genuinely empty cell and for a formula whose result is an empty string. That is often the right test for an input field that might be populated by either manual entry or another formula.

Use ISBLANK(A2) when you specifically need to know whether the cell contains nothing at all. A formula returning "" means A2 is not truly empty, so ISBLANK(A2) returns FALSE in that case. A space character also means the cell is not empty. This difference explains why switching from one test to the other can change the result even when both cells look blank on screen.

To label a truly empty cell differently from a formula-generated blank, test the stricter condition first. With a value or formula in A2, use:

=IFS(ISBLANK(A2),"No entry",A2="","Formula displays blank",TRUE,"Has a value")

A genuinely empty A2 returns No entry. If A2 contains a formula that returns an empty string, the second condition returns Formula displays blank. Any other content returns Has a value. For ordinary input validation, that distinction may be unnecessary; choose the test based on what the sheet needs to recognize.

Handle spaces and other nearly blank entries

Sometimes a cell contains ordinary spaces rather than no content. In that case, A2="" is FALSE because the space is a character. If users may paste or type accidental spaces, trim the text before checking it. With text in A2, use:

=IFS(TRIM(A2)="","Missing",TRUE,A2)

This labels an empty cell, an empty string, or text made only of ordinary spaces as Missing; otherwise it returns the original content from A2. In Google Sheets, TRIM removes leading and trailing ordinary spaces and reduces repeated spaces between words. It does not remove every kind of invisible character, such as a nonbreaking space that may come from a web page. If a value still appears blank but is not detected, inspect the source or clean that specific character rather than assuming all whitespace is identical.

Be cautious about applying text cleanup to values that are meant to remain numeric or to identifiers where spaces are meaningful. A cleanup step should match the kind of data in the column. For a simple status field, trimming pasted text can be helpful; for a code or address, changing characters may not be appropriate.

Return a blank, a message, or a default value

When missing data needs attention, a visible message such as Enter a score can make the problem obvious. When a report should look uncluttered until data arrives, "" is often a more suitable display result. A third option is a numeric or text default, but use one only when it accurately represents the missing case. Treating an unknown score as zero, for example, can distort an average or imply a real score was recorded.

With a score in B2, the earlier grading formula returns an empty string when B2 is blank. That output can look empty in a chart or report, but B2 still contains a formula. A separate formula that counts truly empty cells may therefore treat it differently from a cell that was never populated. If a downstream calculation depends on whether an input was supplied, test the original input cell rather than relying only on the displayed result.

Also decide how the formula should handle invalid entries. A final TRUE condition can return a message such as Check entry, which is usually clearer than allowing an unrecognized status to appear as #N/A. If the error is useful for finding a missing case during formula development, you can leave out the fallback temporarily, then add a deliberate default when the logic is complete.

Common IFS blank problems and fixes

The formula returns a category for an empty cell. A numeric comparison may match an empty cell as zero. Add the appropriate blank test as the first condition.
The blank test does not catch a cell that looks empty. Check whether the cell contains a formula returning "", ordinary spaces, or other invisible characters. Choose A2="", ISBLANK(A2), or a cleanup step according to the actual content.
The result is #N/A. None of the conditions matched. Add a final TRUE condition with a suitable fallback if every possible input needs a result.
A formula result looks empty but is not truly empty. Returning "" hides visible content; it does not remove the formula. Use the original input cell for tests about whether data was entered.
A threshold result seems wrong. Check the order of the conditions. Put more restrictive or higher-priority conditions before broader ones, because IFS returns the first match.

In Google Sheets, formulas are entered in a cell or the formula bar in the browser. The examples use commas between arguments, as in a US-style spreadsheet locale. Depending on the spreadsheet’s locale, Sheets may require semicolons instead; follow the separator shown by formulas that work in that file. Excel also has an IFS function, but the examples here are written for Google Sheets and its spreadsheet locale settings.

When to use IFS instead of IF

IFS is a good fit when you have several separate conditions and want to keep their results in a readable sequence. It is especially convenient for ordered bands, categories, or named states. However, it does not replace the ordinary IF function in every case. For one yes-or-no decision, IF may be shorter and easier to follow; for a range of related decisions, IFS can avoid deeply nested parentheses.

Choose based on how the logic reads, not just the number of conditions. If the formula is long, add notes in nearby cells or split the work into helper columns so the input check and classification are easier to audit. For example, a helper column could identify whether a required input is present, while another column assigns a grade only after that check passes. This can be simpler to maintain in a shared sheet than a single formula with many intertwined rules.

Frequently Asked Questions

How do I make IFS return blank if a cell is empty?
Put a blank test first and pair it with an empty string. With the value in A2, use =IFS(A2="","",A2>=10,"Pass",TRUE,"Review"). A2 is blank or returns an empty string, so the result displays blank; other values follow the later conditions.

Why does ISBLANK return FALSE for a cell that looks empty?
The cell may contain a formula, including one that returns "", or it may contain a space. ISBLANK is TRUE only when the cell itself is empty. Use a comparison to "" if you want to catch formula-generated empty strings too.

Does IFS need a final TRUE condition?
No, but without a matching condition for a particular input, IFS returns #N/A. Add TRUE and a default result when you want the formula to handle every remaining case.

Can IFS tell a truly empty cell from a formula blank?
Yes. Test ISBLANK(A2) before A2="". The first test catches a genuinely empty cell; the second can then catch a formula result of an empty string.

Why does IFS treat a blank score as zero?
An empty cell can behave like zero in numeric comparisons, so a condition such as B2<10 may match. Add a blank check before the numeric conditions to keep missing scores separate from actual numbers.

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.