If you want Excel to show one result when a cell is blank and another when it is not, use an IF formula: =IF(ISBLANK(A2),"Blank","Not blank"). If A2 might contain a formula that returns an empty string, use =IF(A2="","Blank","Not blank") instead; the right test depends on what you mean by blank.
What Does Blank Mean in Excel?
A cell can look empty without being an actually empty cell. It may have been cleared, contain a formula that displays nothing, hold one or more spaces, or have formatting that makes its contents hard to see. These cases can behave differently in formulas, filters, counts, and data checks.
For example, a data-entry sheet might leave A2 empty until someone enters a customer name. In a different sheet, A2 might contain a formula such as one that returns an empty string while a related field is missing. Both cells can appear blank on screen, but only the first is truly empty. A reliable formula starts by deciding which case should count as blank.
Excel’s IF function tests a condition and returns one value when that condition is true and another when it is false. Its general structure is =IF(condition,value_if_true,value_if_false). The two blank-check formulas above use different conditions, so they are not interchangeable in every workbook.
Use IF with ISBLANK for a Truly Empty Cell
ISBLANK returns TRUE only when its referenced cell has no content. It is a good choice for checking whether a user has left a cell genuinely empty. It returns FALSE if the cell contains a value, text, a space, or a formula—even when that formula displays nothing.
With a name expected in A2 and the check formula entered in B2, =IF(ISBLANK(A2),"Enter a name","Ready") returns Enter a name when A2 has never been filled or has been cleared. If A2 contains Maya, it returns Ready. The formula checks the cell itself; it does not test whether the displayed result merely looks empty.
This is useful for data validation checks, completion labels, and identifying missing inputs. If a cell contains a formula, however, ISBLANK will report that it is not blank, even if that formula’s result is an empty string. In that situation, use a comparison with an empty string instead.
Use an Empty-String Test for Formula Results
A formula can return an empty string, written as two quotation marks with nothing between them: "". The cell still contains a formula, but it displays no text. A comparison such as A2="" treats a genuinely empty cell and a cell displaying an empty string as blank for this test.
Suppose A2 contains a formula that returns an empty string until a name is entered. With the check formula in B2, =IF(A2="","Waiting for a name","Ready") returns Waiting for a name both when A2 is genuinely empty and when its formula displays nothing. When A2 displays Maya, the result is Ready.
This comparison is often the practical choice for dashboards and formula-driven reports, where the goal is to react to what the cell displays. It does not treat a cell containing ordinary spaces as blank. It also does not remove or change anything in A2; it only tests the value for the result of the IF formula.
Handle Spaces and Other Invisible Characters
A cell containing a space is not empty, even though it can appear blank. A common cause is pasted data or someone pressing the space bar instead of leaving the field untouched. If ordinary leading, trailing, or repeated spaces should count as blank, TRIM can clean those spaces for the test.
With text in A2 and the test entered in B2, =IF(LEN(TRIM(A2))=0,"Blank or spaces","Has text") returns Blank or spaces if A2 is empty or contains only ordinary spaces. If A2 contains the text Maya with extra spaces around it, the formula returns Has text. TRIM removes leading and trailing regular spaces and reduces repeated internal regular spaces; it does not modify the original cell.
Some copied text includes a nonbreaking space, which TRIM does not remove. If that is a likely source of the problem, replace that character for the test as well. With the same layout, =IF(LEN(TRIM(SUBSTITUTE(A2,CHAR(160),"")))=0,"Blank or spaces","Has text") also removes character 160 before checking. This is more involved, so use it when imported text or web data actually contains that character rather than adding complexity without a reason.
Keep Blank Inputs from Creating Misleading Results
A blank input can affect a calculation in ways that are not useful for a report. For example, a division formula may produce an error when its denominator is zero or an unexpected result when required information has not been entered. An IF check can keep the output empty until the necessary values are present.
With the amount in B2, the divisor in C2, and the result formula in D2, =IF(OR(B2="",C2="",C2=0),"",B2/C2) displays nothing if either input is blank or if the divisor is zero; otherwise, it calculates B2 divided by C2. For B2 equal to 12 and C2 equal to 3, it returns 4. The formula’s empty-string result is a display choice, not a genuinely empty D2: D2 still contains a formula.
That distinction matters if another formula later checks D2. ISBLANK(D2) returns FALSE because the formula is present, while a test such as D2="" can treat its displayed empty-string result as blank. Think through downstream checks before using empty strings to make a sheet look cleaner.
Find or Highlight Blank Cells in a Worksheet
For a one-time check, Excel can select genuinely empty cells in a chosen range. Select the range first, then choose Home > Find & Select > Go To Special > Blanks. Excel selects empty cells within that selection, which can help locate gaps in a list or prepare a range for filling. Cells that contain formulas returning empty strings are not genuinely empty and may not be selected as blanks.
To highlight cells that appear blank, select the range and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With A2 as the top-left cell of the selected range, enter =A2="" to highlight cells that are empty or return an empty string. To highlight only truly empty cells, use =ISBLANK(A2) instead. Choose a format and confirm the rule. Because the reference is relative, Excel adjusts it for each cell in the selected range.
For a recurring list, a formula in a helper column can make the check visible and filterable. For example, a label such as Missing can identify rows needing attention. Before filling apparent gaps in bulk, check whether some cells contain formulas or spaces: selecting a range and typing into it may overwrite information you intended to keep.
Choose the Right Test and Avoid Common Mistakes
Use the test that matches the question you are asking. ISBLANK answers whether a cell contains anything at all. Comparing with an empty string answers whether the cell is empty or its evaluated result is an empty string. TRIM-based checks are for cases where ordinary spaces should also count as blank. These differences also explain why functions that count cells may disagree with what you see on the screen.
For a count of blank cells, COUNTBLANK includes cells that are empty and cells whose formulas return empty strings. With the range A2:A20 containing the items you want to count, =COUNTBLANK(A2:A20) returns the number of cells Excel counts as blank in that range. A cell containing a space is not counted as blank by this function.
Common errors include testing the wrong cell, using ISBLANK when the cell contains a formula, and overlooking spaces introduced by pasted data. Also remember that a formula returning "" can still be counted as a nonempty cell by COUNTA, because the cell contains a formula. When copying a check down a column, verify that its reference moves as intended; absolute references with dollar signs can keep it fixed when that is not what you want.
In Microsoft 365 for Windows, formulas shown here use commas between arguments. Some regional settings require semicolons instead; if Excel rejects a formula with commas, check the list-separator setting used by your installation. Excel for Mac has the same functions and formula logic, though menu placement and some interface details can differ. Excel for the web also supports these common formulas.
Frequently Asked Questions
What is the simplest Excel formula to check whether a cell is blank?
For a truly empty cell, use =ISBLANK(A2). To treat a formula that displays an empty string as blank too, use =A2="". Put the formula in a different cell from A2 to avoid a circular reference.
Why does ISBLANK say FALSE when the cell looks empty?
The cell may contain a formula returning "", a space, or another invisible character. ISBLANK checks whether the cell has content, not whether it looks empty. Compare the cell with an empty string for formula-generated blanks, or use a TRIM-based test when ordinary spaces are the cause.
Does a formula returning "" make a cell truly blank?
No. The formula remains in the cell, even though its displayed result is empty text. That is why ISBLANK returns FALSE for it and why you cannot treat it as a cleared cell for every Excel operation.
How do I show nothing if an input cell is blank?
Wrap the calculation or output in IF and return "" for the blank case. For example, with a required input in A2 and a result in B2, =IF(A2="","",A2) leaves B2 visually empty until A2 has a value. B2 still contains a formula.
Can Excel highlight cells that look blank?
Yes. Use Conditional Formatting with a formula such as =A2="" for a selected range whose top-left cell is A2. Use =ISBLANK(A2) if the rule should apply only to genuinely empty cells.
Related
- Convert PowerPoint to Excel: Steps, Options, and Limits
- Access Database Import from Excel: Steps and Tips
- Excel Attendance Format: A Clear Monthly Attendance Tracker
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Start of Month: Dates, Examples & TipsTo return the first day of the month for a date in cell A2, use =DATE(YEAR(A2),MONTH(A2),1). If A2…
- Excel Import CSV: Formula or the Right Import MethodExcel does not have a built-in worksheet formula that imports a CSV file from your computer. In Microsoft…
- Excel Formula for Finding Matches: A Practical GuideTo find the position of a value, use MATCH with exact-match mode. With the value to find in…
- COUNTIF in Excel: How It Works and ExamplesIn Excel, COUNTIF counts cells in a range that meet one condition. Its syntax is =COUNTIF(range, criteria); for…
- Excel Formula for Highest Value: MAX and Other OptionsTo find the highest value in Excel, use the =MAX(B2:B20) formula, assuming the numbers you want to compare…
- Excel Data Validation: Allow Unique List Values?No: an Excel data-validation dropdown does not, by itself, require unique choices or stop the same choice being…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.