To check whether a cell is not blank in Excel, use =NOT(ISBLANK(A2)), replacing A2 with the cell you want to test. The formula returns TRUE when that cell contains something and FALSE when it is genuinely empty.
What NOT(ISBLANK()) Means
ISBLANK is Excel’s function for testing whether a cell is empty. NOT is a logical function that reverses a result: TRUE becomes FALSE, and FALSE becomes TRUE. Combining them turns an “is this empty?” test into an “is this occupied?” test.
With the value North in A2, the formula =NOT(ISBLANK(A2)) returns TRUE. With A2 completely empty, it returns FALSE. This makes the combination useful in formulas that should act only when a cell has been filled in, such as status messages, checks on required fields, or conditional formatting.
ISBLANK takes one cell reference as its argument. NOT can take that test as its argument, so the functions nest naturally. In Microsoft 365 for Windows, enter the formula in a worksheet cell and press Enter. If the cell is in an Excel Table, you can also use a structured reference, though ordinary cell references are often easier to follow in a small example.
What Excel Considers a Blank Cell
The key detail is that ISBLANK checks whether a cell is truly empty, not whether it looks empty on screen. A cell with a number, text, a date, a space, or a formula is not truly empty. Its displayed appearance can be misleading: a formula may return an empty text string, or a custom number format may hide a value, but the cell still contains something.
For example, if A2 contains a formula that displays an empty string, ISBLANK(A2) returns FALSE because A2 contains a formula. Consequently, NOT(ISBLANK(A2)) returns TRUE. This is often the surprising result behind a formula that labels apparently empty cells as filled.
Common cases include:
- A cell that has never been filled, or whose contents were cleared with Delete, is genuinely blank.
- A cell containing a space is not blank, even though the space is difficult to see.
- A cell containing a formula that returns an empty string is not blank to ISBLANK.
- A cell containing zero is not blank, even if a number format hides zero values.
These distinctions matter when cleaning imported data, checking form entries, or deciding whether a row should count as complete. First decide what “blank” means for your task: physically empty, visually empty, or containing no meaningful text. Excel can test each meaning, but the appropriate formula differs.
Use It in an IF Formula
A common use is to display a message only when a cell has a value. With a name in A2, put this formula in B2: =IF(NOT(ISBLANK(A2)),"Entered","Missing"). If A2 contains North, B2 displays Entered; if A2 is genuinely empty, B2 displays Missing.
Here, IF evaluates the logical test first. When the test is TRUE, it returns its second argument; when FALSE, it returns its third. You can replace the messages with a calculation, a status label, or another formula. For instance, a worksheet could show a reminder beside a required field until someone enters a value.
Be aware that the formula above treats a cell containing a formula that returns an empty string as entered. If the intended rule is instead “show Entered only when something is visibly present,” a comparison with an empty string may fit better. With A2 containing a formula that returns an empty string, enter =IF(A2<>"","Entered","Missing") in B2; the result is Missing. If A2 contains North, the result is Entered.
In that comparison, <> means “not equal to.” It regards a truly empty cell and a formula result of empty text as equal to an empty string. It does not treat zero as empty: if A2 contains 0, the formula returns Entered. That may be exactly right for a quantity field, where zero is a real value rather than missing data.
Choose Between ISBLANK and an Empty-String Test
Use NOT(ISBLANK(A2)) when the question is whether the cell itself contains anything, including a formula. Use A2<>"" when the practical question is whether the cell’s value is different from empty text. The two tests agree for many ordinary entries, but differ for formulas that return "".
For a data-entry sheet where formulas are not expected in input cells, NOT(ISBLANK()) is clear and direct. For a report with formulas that intentionally display nothing until a source value exists, an empty-string comparison may better match what the reader sees. Neither test automatically removes spaces or decides whether a value is meaningful. A cell containing a single space passes the nonblank test and also differs from an empty string.
Another function, COUNTA, counts cells containing values or formulas, including formulas that return empty text. It is useful when the goal is to count occupied cells rather than test one cell. For example, with a list in A2:A10, COUNTA can give a total, but its treatment of formula cells may not match a count of visibly filled entries. Consider the contents and formulas in the range before choosing a count method.
As a practical rule, identify the exact condition in plain language first. “Has a value or formula” points to ISBLANK. “Displays something other than an empty string” points to a comparison against "". “Has non-space text” requires cleaning or trimming the content as part of the test.
Ignore Cells That Contain Only Spaces
Copied data can contain ordinary spaces that make a cell look empty. Since a space is a character, NOT(ISBLANK(A2)) returns TRUE for a cell containing one. If you want to regard a cell containing only ordinary spaces as empty, TRIM can remove leading and trailing spaces before LEN measures the remaining text.
With the text to check in A2, use =LEN(TRIM(A2))>0. If A2 contains three ordinary spaces, TRIM reduces the text to nothing, LEN returns 0, and the test returns FALSE. If A2 contains North, the test returns TRUE because its trimmed text has five characters.
TRIM is not a universal cleanup tool. It removes ordinary space characters and reduces repeated internal ordinary spaces to single spaces, but some imported whitespace—such as a nonbreaking space—may remain. If data came from a website or another system, inspect a few troublesome cells and clean the source appropriately. A cell containing a number also needs consideration: it is not blank, but a text-focused cleanup test may not express the rule you want as clearly as ISBLANK.
Use the Test for Conditional Formatting
NOT(ISBLANK()) can highlight filled cells or identify incomplete-looking areas visually. In Excel for Microsoft 365 on Windows, select the target range, then choose Home > Conditional Formatting > New Rule. Choose “Use a formula to determine which cells to format,” enter the formula, choose a format, and confirm.
For example, if the selected range begins at A2, enter =NOT(ISBLANK(A2)). The reference is relative, so Excel checks each cell in the selected range against its own position. If you select A2:A100, A2 is tested for the first cell, A3 for the next, and so on. A filled cell triggers the formatting; a truly empty cell does not.
If the cells contain formulas that return empty text, this rule will still treat those cells as occupied. To highlight only cells whose displayed result is not empty text, use =A2<>"" as the conditional-formatting formula for a range beginning at A2. Check the first cell reference carefully: a mismatch between the selected range’s top-left cell and the formula reference can shift the formatting pattern.
On Excel for Mac, the Conditional Formatting options are also on the Home tab, though dialog details can vary by release. Excel for the web supports conditional formatting as well, but the available rule-editing controls may differ from the Windows desktop dialogs. If a workbook is shared across platforms, use a straightforward rule and confirm how it appears in the versions your colleagues use.
Common Problems and Quick Checks
If NOT(ISBLANK()) says a cell is filled when it looks empty, check whether the cell contains a formula, a space, a hidden value, or a number formatted to display nothing. Select the cell and look at the formula bar; the worksheet display alone may not reveal what is stored there. Clearing the cell’s contents is different from merely applying a format that hides them.
If the result seems reversed, remember that ISBLANK returns TRUE for an empty cell, and NOT reverses that result. Test the underlying ISBLANK function by itself in a spare cell to isolate the cause. Also verify the reference: a formula copied down a column changes its relative reference row by row, which is usually desirable, but may be wrong if every row should check the same input cell.
Check for these issues before changing the formula:
- Is the “empty” cell actually a formula result such as ""?
- Does it contain a space or imported whitespace?
- Is the formula pointing at the intended cell, rather than a neighboring row?
- Does the task require detecting a real value, visible text, or non-space text?
Formula separators can also depend on regional settings. Excel installations configured for a semicolon list separator may require semicolons when entering formulas, even though comma-separated formulas are shown here. If Excel reports a syntax error after pasting a formula, check the list separator expected by that installation rather than changing the function names.
Frequently Asked Questions
Does Excel have an ISNOTBLANK function?
No. Excel provides ISBLANK, and you reverse its result with NOT: =NOT(ISBLANK(A2)). This returns TRUE when A2 is not truly empty.
Why does NOT(ISBLANK(A1)) return TRUE when A1 looks empty?
A1 may contain a formula returning an empty string, a space, or a value hidden by formatting. ISBLANK checks whether the cell is genuinely empty, not just whether it appears empty.
How do I treat a formula returning "" as blank?
Compare the cell with an empty string, as in =A1<>"" when you want TRUE only if A1’s result differs from empty text. A formula returning "" makes this test FALSE.
Does a cell with zero count as blank?
No. Zero is a value, so NOT(ISBLANK(A1)) returns TRUE when A1 contains 0. If zero should be treated as missing for a particular task, use a test designed for that rule rather than changing the meaning of ISBLANK.
Can I use this formula down a whole column?
Yes. Enter it beside the first row and fill it down; a relative reference such as A2 adjusts to A3, A4, and subsequent rows. For a conditional-formatting rule, select the range first and use the top-left cell in the formula reference.
Which Test Should You Use?
For a direct test of whether a cell contains anything at all, use NOT(ISBLANK()). For cells that may contain formulas displaying nothing, compare the result with an empty string. For inputs that may contain only spaces, trim before testing. Choosing based on the data—not just how it looks—prevents the most common errors and makes the worksheet’s logic easier for someone else to understand.
Related
- Unlock an Excel Slicer: Steps, Protection, and Fixes
- Excel File Could Be Corrupted or Unsafe? What to Do
- State Heat Map in Excel: Create, Format, and Troubleshoot
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add a Header in Excel for Microsoft 365: Page SetupTo add a header in Excel for Microsoft 365 on Windows, open the worksheet, choose Insert > Text…
- How to Make a Process Flowchart in PowerPointTo make a process flowchart in PowerPoint, add flowchart shapes from Insert > Shapes, label each step, and…
- Excel Shortcut Cheat Sheet for Windows and MacAn Excel shortcut cheat sheet is a quick reference to keyboard commands for editing cells, moving around worksheets,…
- How to Manually Archive Emails in Outlook 365To manually archive an email in Outlook 365, select it and choose Archive on the toolbar. Outlook moves…
- Excel Data Analysis Experience: Skills, Tasks, and ProofExcel data analysis experience means being able to organize data, check its quality, use formulas or tools to…
- Make a Flowchart in Word for Mac: Steps and Tips That WorkTo make a flowchart in Word for Mac, choose Insert > Shapes, add flowchart shapes such as process…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.