Excel IFS for Blank Cells: Formulas and Common Fixes

To make Excel’s IFS function return a result when a cell is blank, test for a blank first: with the value to check in A2, use =IFS(A2="","Blank",A2>0,"Positive",A2<0,"Negative",TRUE,"Zero"). The first matching condition determines the result, so checking for blank before numeric conditions prevents an empty input from being treated as an ordinary value.

How IFS handles conditions

IFS evaluates conditions in order and returns the value paired with the first condition that is TRUE. Its basic pattern is IFS(condition1,value_if_true1,condition2,value_if_true2,...). Each condition needs a corresponding result, and the arguments must alternate in condition-and-result pairs.

That order matters when one condition could overlap with another. Put a blank test before tests such as “greater than zero,” and put more specific categories before broader ones. Excel stops at the first TRUE condition; it does not continue to check later conditions or combine their results.

IFS does not include an automatic “otherwise” result. If every condition is FALSE, Excel returns #N/A. A final condition of TRUE is a common way to supply a default result, such as “Check entry.” IFS is available in Microsoft 365 and newer perpetual Excel versions, including Excel 2019, 2021, and 2024. In older versions that do not support it, Excel may show #NAME? instead.

Test for a blank before other rules

For many worksheets, the comparison A2="" is the most useful blank test. It evaluates as TRUE when A2 is genuinely empty and also when a formula in A2 returns an empty text string. This makes it a practical choice when a cell looks blank on screen and should be treated as missing data.

For example, with a score in A2 that is either empty or numeric, use this formula to label missing scores, passing scores, and scores below 80. With A2 blank, the result is “Missing”; with 92, it is “Pass”; and with 65, it is “Review.”

With the score in A2 and valid entries limited to blank cells or numbers, use:

=IFS(A2="","Missing",A2>=80,"Pass",A2<80,"Review")

The blank condition comes first so an empty score receives “Missing.” This example assumes that any entered number should fall into one of the two score categories. If the cells might contain words or other invalid entries, add a validation condition rather than relying on numeric comparisons alone.

Distinguish truly empty cells from formulas that look blank

A cell that appears empty is not necessarily an unused cell. It may contain a formula such as ="", which displays no characters but still contains a formula. The distinction matters if you need to find cells that have never been filled in, rather than cells whose displayed result is empty.

ISBLANK checks whether a cell is genuinely empty. It returns FALSE for a cell containing a formula, even when that formula displays an empty string. For a status that should say “Empty” only when A2 has no content or formula, use the following. With A2 truly empty, it returns “Empty”; with a formula in A2 that returns an empty string, it returns “Has content.”

With the cell to check in A2, use:

=IFS(ISBLANK(A2),"Empty",TRUE,"Has content")

Use A2="" instead if a formula-generated empty string should count as blank. The two tests answer different questions: “Does this cell currently display nothing?” versus “Is this cell actually unused?” COUNTBLANK also counts both genuinely empty cells and formulas that return empty strings, so its result may differ from counting cells that are physically empty.

Add a safe default for unexpected entries

A final TRUE condition gives IFS a result when none of the earlier tests match. It is useful for catching unplanned values, but it should come after the meaningful cases. In a score example, a text entry should not accidentally be treated as a passing score simply because a numeric comparison behaves unexpectedly for that input.

With a score in A2, where blank means missing, numbers of 80 or more pass, lower numbers need review, and nonnumeric entries need checking, use:

=IFS(A2="","Missing",NOT(ISNUMBER(A2)),"Check entry",A2>=80,"Pass",TRUE,"Review")

For a blank A2 the result is “Missing”; for the text “absent” it is “Check entry”; for 92 it is “Pass”; and for 65 it is “Review.” The last TRUE catches numbers below 80 because earlier conditions have already handled blanks, nonnumeric values, and passing scores. Adjust the conditions if negative numbers or other numeric values should receive a different message.

Return a blank result instead of a label

Sometimes the goal is to keep a report visually clean rather than display the word “Blank.” IFS can return an empty text string as the result for an empty input. With a number in A2, this example leaves the result empty when A2 is blank, labels positive and negative numbers, and identifies zero. For a blank A2, it returns an empty string; for 0, it returns “Zero”; for 4, it returns “Positive.”

With A2 containing a number or a blank, use:

=IFS(A2="","",A2>0,"Positive",A2<0,"Negative",TRUE,"Zero")

The empty string in the second argument position after the blank condition is the value to return. It does not erase the formula cell: the cell still contains a formula, and functions such as ISBLANK will therefore treat it as nonblank. A displayed blank can also affect later formulas differently from a truly empty cell, so choose this technique for presentation rather than as a way to clear data.

Handle cells that contain spaces

A cell containing one or more spaces is not empty, and the test A2="" will not identify it as blank. This can happen when data is pasted from another system or when someone presses the space bar. If spaces should count as blank, test the length of the trimmed text instead.

With text to check in A2, this formula treats an empty cell and ordinary leading, trailing, or repeated spaces as blank. If A2 contains three ordinary spaces, it returns “Blank or spaces”; if it contains “North,” it returns “Has text.”

With the value to inspect in A2, use:

=IFS(LEN(TRIM(A2))=0,"Blank or spaces",TRUE,"Has text")

TRIM removes ordinary space characters at the edges and reduces repeated ordinary spaces within text. It does not remove every character that may look like a space. In particular, nonbreaking spaces copied from websites can remain. If pasted data is still classified as nonblank, inspect or clean the source text rather than assuming the cell is truly empty.

Choose between IFS, IF, and blank-counting functions

IFS is convenient when you have several separate conditions and want each result to be easy to read. For a single blank check, a regular IF is often shorter. With the value in A2, the formula below returns “Missing” for a blank-looking value and “Entered” otherwise; for A2 containing 12, the result is “Entered.”

With the value to check in A2, use:

=IF(A2="","Missing","Entered")

Nested IF functions can handle multiple tests too, but long chains are harder to scan and maintain. IFS can make those cases clearer, provided you remember to include a final TRUE condition if you need a default. Neither IFS nor IF changes the contents of the cells being tested.

For a count rather than a per-cell label, COUNTBLANK may be more suitable. With the cells to count in A2:A10, use =COUNTBLANK(A2:A10). If two cells in that range are genuinely empty and one contains a formula returning an empty string, the result is 3. COUNTBLANK is useful for summaries, but it does not tell you which individual cells are blank; use a row-level formula or filtering when you need to locate them.

Common errors and troubleshooting

#N/A: No condition evaluated as TRUE. Add a final condition and result, often TRUE,"Other", or check whether the conditions cover every allowed input.
#NAME?: The Excel version may not support IFS, or a function name may be misspelled. Use nested IF functions in an older version that lacks IFS.
A blank-looking cell is not detected: Check whether it contains spaces, a formula returning an empty string, or another invisible character. Choose A2="", ISBLANK, or a trimmed-text test according to what you mean by blank.
A zero is labeled blank: Review the test and the source data. A numeric zero is a value, not an empty cell; do not use a broad condition that treats zero as missing unless that is an intentional data rule.
The wrong category appears: Reorder overlapping conditions. IFS returns the first match, so an early broad condition can prevent a later, more specific condition from being reached.

When entering formulas, use straight quotation marks around text results and balance every parenthesis. Excel installations configured for some regional settings may display or expect semicolons rather than commas as argument separators. The formulas here use commas, as in standard English-language Excel syntax; if Excel rejects a formula, the regional list separator is one setting to check.

Frequently Asked Questions

How do I make IFS return “Blank” if a cell is empty? Put the blank test first. With the cell in A2, use =IFS(A2="","Blank",TRUE,"Not blank"). This treats a genuinely empty cell and a formula result of an empty string as blank.

Does IFS treat zero as blank? No. Zero is a numeric value. A blank test such as A2="" is intended to check for an empty-looking value, not to classify an entered zero as missing. If zero should have its own label, add a condition such as A2=0 in the appropriate position.

Why does ISBLANK return FALSE when the cell looks empty? The cell may contain a formula that returns an empty string, a space, or another character. ISBLANK is TRUE only when the cell itself is empty. Use a comparison with an empty string for formula-generated blanks, or remove spaces if they should count as blank.

Why does my IFS formula return #N/A? IFS returns #N/A when every condition is FALSE and no default condition catches the input. Add a final TRUE condition with a result, or revise the existing tests so they cover all relevant values.

Can IFS return an empty cell? It can return an empty text string, usually written as "", which displays as blank. The formula cell is not actually empty, however, so ISBLANK will return FALSE for it.

What can I use instead of IFS in older Excel? Use nested IF functions, with the blank test first and later conditions following it. For a simple blank-versus-entered check, with the value in A2, use =IF(A2="","Blank","Not blank"). This returns “Blank” for an empty-looking A2 and “Not blank” when A2 contains 12.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.