No. A normal Excel worksheet cell does not contain a SQL-style NULL value: it can be truly empty, contain a formula that returns an empty string, or hold something such as the literal text NULL. Those cases can look alike on screen but behave differently, so the right test depends on what you mean by “missing.”
What “null” means in Excel
People often use “null” informally to mean that a cell has no useful value. In databases, NULL has a specific meaning: the value is unknown or absent, and comparisons involving it follow special rules. In an ordinary Excel worksheet, there is no built-in worksheet value called NULL and no worksheet function named ISNULL. Instead, Excel represents several different situations that users may treat as missing.
This distinction matters when you check records, count entries, build formulas, or import data. A formula that correctly identifies a genuinely empty cell may not identify a formula that displays nothing. Likewise, a cell containing the word NULL is text, not a special null value.
Four cell states that look empty or missing
Consider these common cases:
- Truly empty: Nothing has been entered in the cell. This is the case ISBLANK is designed to detect.
- Formula returning an empty string: A formula such as
=""is present, but its displayed result is zero characters. The cell is not truly empty. - Text or spaces: The cell contains text such as
NULL,n/a, or one or more spaces. These are values, even if they look like missing data. - Zero: The cell contains the number 0. Zero is a real numeric value, not a blank, though a number format may hide it.
Errors such as #N/A are another distinct category. They can be used to signal unavailable information, but they are error values, not empty cells or a general-purpose NULL. Choose a representation deliberately: downstream formulas and reports will treat each category differently.
How Excel checks for an actually empty cell
Use ISBLANK when your definition of missing is “the cell has no content at all.” With a value or formula in A2, enter =ISBLANK(A2); it returns TRUE only if A2 is genuinely empty. If A2 contains a formula that displays nothing, ISBLANK returns FALSE because the formula itself is in the cell.
This makes ISBLANK useful for checking whether a user has entered anything, but it can be too strict for a report where a formula-produced empty string should also count as missing. A frequent surprise is that a cell that looks blank after a formula runs is not blank to ISBLANK.
To treat a truly empty cell and a zero-length text result alike, compare the cell with an empty string. With the value or formula being checked in A2, use =A2="". It returns TRUE for a genuinely empty cell and for a formula returning an empty string. It returns FALSE for a cell containing ordinary text, a space, or zero.
That comparison is convenient, but it answers a broader question than ISBLANK. It does not prove the cell is empty; it tells you that its value compares equal to an empty string. Make that distinction clear in a workbook if other people will maintain the formulas.
Choosing the right test for your task
Start by deciding which cases your workflow should consider missing. For example, a blank form field may mean no response, while a zero in a sales column may be a valid reported result. A formula returning an empty string might mean “not applicable yet,” or it might merely be a display choice. There is no single test that interprets all these business meanings correctly.
- Use
ISBLANKwhen only a genuinely untouched cell counts as empty. - Use a comparison with
""when both truly empty cells and formulas returning empty text should count as empty. - Check explicitly for text such as
NULLwhen that literal was used in an imported file; it is not automatically recognized as missing. - Keep zero separate from missing data when zero is a valid measurement, amount, or count.
For example, with an input in A2, use =IF(A2="","Missing","Present") if both a blank A2 and a formula result of empty text should be labeled Missing. If only a truly empty cell should receive that label, use =IF(ISBLANK(A2),"Missing","Present") instead. In each case the formula returns a label, not a special null value.
Counting blanks and formulas that display nothing
Counting functions also use different definitions. COUNTBLANK counts genuinely empty cells and cells whose formulas return empty text. COUNTA counts cells containing values, including formulas that return empty text. That difference can make a total seem inconsistent if a range contains formulas designed to hide their displayed result.
Suppose A2 is empty, A3 contains a formula returning an empty string, A4 contains one space, A5 contains numeric zero, and A6 contains the text NULL. With that layout in A2:A6, =COUNTBLANK(A2:A6) returns 2: A2 and A3 count as blank. With the same layout, =COUNTA(A2:A6) returns 4: A3 has a formula, and A4, A5, and A6 contain entries. These totals are not contradictory; the functions answer different questions.
For a single-cell diagnostic, LEN can tell you whether the evaluated text has zero characters, though it does not distinguish a genuinely empty cell from a formula returning empty text. With the value in A2, =LEN(A2)=0 returns TRUE for either of those cases, but FALSE for a space because a space is a character. It also is not a universal cleanup test for every kind of data or error.
Why blank checks sometimes produce surprising results
A cell can appear empty without being empty. A formula may return ""; a font color may match the background; a custom number format may suppress a displayed zero; or a cell may contain spaces. Before changing a formula, inspect the source cell and its formula bar. A display-only effect is different from missing content.
Whitespace is a particularly common problem in data copied from websites or exported systems. A cell containing an ordinary space is not blank, and a comparison with "" will not classify it as empty. Nonbreaking spaces and other invisible characters can also survive simple cleanup. If you need to normalize imported text, test the actual source values and clean them consistently rather than assuming every visually empty cell is equivalent.
Another common mistake is treating zero as missing. If a formula checks for blankness by testing whether a value is zero, it may discard legitimate results. Conversely, arithmetic can treat an empty cell like zero in some calculations, so a formula that adds values may return a plausible number even when an input was never entered. Validate required inputs separately from doing the calculation.
What happens to NULL in imported data
Files from databases and other systems may use NULL to mean missing. When data is brought into Excel, check how the import process represented it: it might appear as an empty worksheet cell, the literal text NULL, or another marker. The same visual table can therefore contain values that require different tests. Do not assume that the word NULL in a cell has database behavior.
Power Query, Excel’s data import and transformation tool, does have a distinct null value in its query language. That is separate from the worksheet formula language. During cleanup, decide whether null and empty text should remain distinct or be converted to one consistent representation before loading the results. If the distinction matters after loading, verify the actual worksheet output rather than relying on how the source appeared in the query editor.
Excel’s data model and DAX also have their own blank-handling functions and behavior. Those are not interchangeable with worksheet formulas such as ISBLANK. When a workbook mixes worksheet formulas, Power Query, and the data model, identify which layer performs each check; a rule that works in one layer may not express the same test in another.
A reliable workflow for missing values
For a dependable spreadsheet, define what counts as missing before writing formulas. Then preserve enough information to distinguish a genuinely empty response from a valid zero or an explicit status such as “not applicable.” If an import supplies a text marker, document whether it will remain text or be converted to an empty value.
- Inspect representative cells, including their formulas and underlying contents, rather than judging only by appearance.
- Choose the missing-value rule for the task: truly empty, empty or empty-string, or a specified marker.
- Test the rule on examples containing a blank, a formula result of empty text, a space, zero, and the marker used by the source.
- Use the same definition in counts, filters, validation checks, and summaries so totals agree.
- Keep valid values such as zero distinct, and note any conversions made during import or cleanup.
If a workbook is shared, a short note beside a data-cleaning step can prevent future users from “fixing” a deliberate distinction. For instance, explain whether a blank means unanswered, whether zero means a measured zero, and whether a formula returning empty text is excluded from a count. Those definitions are part of the data model, not just formatting choices.
Frequently Asked Questions
Does Excel have an ISNULL function?
No worksheet function named ISNULL is available for ordinary Excel formulas. Use ISBLANK for truly empty cells, or a comparison with an empty string when formula results of empty text should also count.
Is a cell containing a formula that returns nothing blank?
No. It contains a formula, so ISBLANK returns FALSE. It may look blank, and COUNTBLANK will count its empty-string result, but the cell is not genuinely empty.
Does the text NULL mean the cell is empty?
No. NULL typed into a worksheet cell is ordinary text. A formula will treat it as text unless you explicitly check for that marker or transform it.
Does COUNTBLANK count formulas that return an empty string?
Yes. COUNTBLANK includes both genuinely empty cells and cells whose formulas return empty text. COUNTA, by contrast, counts a cell containing a formula even when its displayed result is empty.
How can I tell a blank from zero?
Use ISBLANK when you need to identify a truly empty cell. A cell containing 0 is not blank. Avoid relying on appearance alone, because number formatting can hide a zero.