Prem Rawat

Peace is Possible

— Prem Rawat

True peace begins within you. Discover the peace that already exists inside yourself, and let it bring more love, happiness and understanding into your life.

Visit YouTube Channel

How to Check Whether a Cell Is Not Blank in Excel (Formula & Examples)

Learn how to check whether a cell is not blank in Excel using IF, ISBLANK, AND, OR, and COUNTA functions with simple formulas and practical examples.

 

How to Check Whether a Cell Is Not Blank in Excel (Formula & Examples)

    Learn how to check whether a cell is not blank in Excel using simple formulas. Explore IF, ISBLANK, AND, OR, and COUNTA functions with practical examples to manage spreadsheet data efficiently.

How to Check Whether a Cell Is Not Blank in Excel

When working with data in Microsoft Excel, you may often need to check whether a cell contains something or is completely empty. For example, you might want to identify employees who have submitted their reports, check whether customers have entered their payment details, or find out which rows contain information.

Excel makes this easy with the NOT BLANK condition. You can use the IF, ISBLANK, and COUNTBLANK functions to check whether a cell contains data and perform different actions based on the result.

In this guide, you'll learn how to check whether a cell is not blank in Excel, with simple formulas and practical examples.

What Does Not Blank Mean in Excel?

A cell is considered not blank when it contains a value, text, a number, a date, or a formula.

For example:

Cell

Content

Not Blank?

A1

John

Yes

A2

250

Yes

A3

20-Nov-2026

Yes

A4

(Empty)

No

A5

=10+20

Yes

A6

=""

Depends on the formula used

Checking whether a cell is not blank helps you manage incomplete records, validate information, and automate spreadsheet tasks.

How to Check Whether a Cell Is Not Blank Using Excel

The simplest way to check whether a cell is not blank is to use the IF function with the <> operator.

Formula:

=IF(A1<>"","Not Blank","Blank")

How it works:

  • A1 is the cell you want to check.

  • <> means not equal to.

  • "" represents an empty text string.

  • "Not Blank" appears when the cell contains a value.

  • "Blank" appears when the cell is empty.

Example:

Suppose cell A1 contains the name "John".

=IF(A1<>"","Not Blank","Blank")

Result: Not Blank

If A1 is empty, the result will be Blank.

This formula is useful when you want Excel to display a clear message instead of simply returning TRUE or FALSE.

How to Check a Non-Blank Cell Using the IF and ISBLANK Functions

Another method is to combine the IF and ISBLANK functions.

The ISBLANK function checks whether a cell is completely empty. It returns TRUE for an empty cell and FALSE when the cell contains something.

Formula:

=IF(ISBLANK(A1),"Blank","Not Blank")

Example:

A (Customer Name)

B (Status)

David

Not Blank

Sarah

Not Blank

(Empty)

Blank

Michael

Not Blank

Enter this formula in cell B2:

=IF(ISBLANK(A2),"Blank","Not Blank")

Drag the formula down to check the remaining cells.

Important: ISBLANK returns FALSE if a cell contains a formula, even when that formula displays an empty string (""). If you want to treat such cells as blank, use the A1="" comparison instead.

How to Check Whether a Cell Is Not Blank Using the IF Function

If you only need a TRUE or FALSE result, you don't need to use the IF function.

Simply enter:

=A1<>""

Excel returns:

  • TRUE – The cell is not blank.

  • FALSE – The cell is blank or evaluates to an empty string.

This is one of the quickest ways to check whether a cell contains a value.

How to Use the Not Blank Condition with Multiple Cells

Sometimes, you may need to check whether multiple cells contain information before performing an action.

For example, suppose you maintain an employee record with the following columns:

Employee

Email

Phone

Status

John

john@email.com

9876543210

Complete

Sarah

sarah@email.com

(Empty)

Incomplete

David

(Empty)

9876501234

Incomplete

If you want to mark a record as complete only when both the email and phone number are available, use:

=IF(AND(B2<>"",C2<>""),"Complete","Incomplete")

The AND function checks whether both conditions are TRUE.

If either cell is empty, Excel returns "Incomplete".

How to Check Whether at Least One Cell Is Not Blank

You may also want to check whether at least one of several cells contains information.

For this, use the OR function.

Formula:

=IF(OR(A1<>"",B1<>"",C1<>""),"Data Available","No Data")

This formula checks cells A1, B1, and C1.

  • If at least one cell contains data, the result is "Data Available".

  • If all three cells are empty, the result is "No Data".

This is particularly useful for checking customer forms, registration sheets, and data entry records.

How to Count Non-Blank Cells in Excel

If you want to count how many cells contain information in a range, use the COUNTA function.

Formula:

=COUNTA(A2:A10)

This formula counts cells that are not empty in the range A2 to A10.

For example, if seven cells contain information and three are empty, the result will be:

7

Keep in mind that COUNTA also counts formulas that return an empty string (""). If you want to count cells that display non-empty results, you can use:

=COUNTIF(A2:A10,"<>")

Practical Example: Check Whether a Customer Payment Cell Is Not Blank

Imagine you maintain a customer payment sheet in Excel. You want to identify whether a payment amount has been entered.

Your spreadsheet might look like this:

Customer Name

Payment Amount

Payment Status

Alex

5,000

Received

Robert

2,500

Received

James

(Empty)

Pending

Emma

3,000

Received

Enter the following formula in C2:

=IF(B2<>"","Received","Pending")

Copy the formula down to the remaining rows.

Excel will automatically display "Received" when a payment amount is entered and "Pending" when the cell is empty.

This simple approach can help you manage customer payments, outstanding balances, invoices, and business records more efficiently.

Difference Between Blank and Not Blank Formulas in Excel

Excel provides several ways to check empty and non-empty cells. The right formula depends on what you want to identify.

Formula

Purpose

Result

=A1<>""

Checks whether a cell is not blank

TRUE/FALSE

=ISBLANK(A1)

Checks whether a cell is completely empty

TRUE/FALSE

=IF(A1<>"","Yes","No")

Displays a message for non-blank cells

Yes/No

=COUNTA(A1:A10)

Counts non-empty cells

Number

=COUNTIF(A1:A10,"<>")

Counts cells that are not empty according to the criteria

Number

=IF(AND(A1<>"",B1<>""),"Complete","Incomplete")

Checks whether two cells are not blank

Complete/Incomplete

Common Mistakes to Avoid When Checking Non-Blank Cells

Even though checking non-blank cells is straightforward, a few situations can produce unexpected results.

Confusing ISBLANK with an empty-looking cell

A cell containing a formula such as ="" looks empty, but ISBLANK returns FALSE because the cell contains a formula.

Using spaces instead of empty cells

A cell containing a space is not technically blank. Therefore, =A1<>"" returns TRUE.

If you want to ignore cells containing only spaces, use:

=TRIM(A1)<>""

Forgetting to update cell references

When copying formulas down a worksheet, make sure the cell references point to the correct rows.

Using COUNTA without understanding its behaviour

The COUNTA function counts cells containing formulas, including formulas that return empty text. This can affect your results when working with automatically generated reports.

Frequently Asked Questions (FAQs)

1. How do I check if a cell is not blank in Excel?

Use =A1<>"". It returns TRUE if the cell is not empty and FALSE if it is empty or evaluates to an empty string.

2. Which Excel function checks whether a cell is blank?

The ISBLANK function checks whether a cell is completely empty.

3. How do I display text if a cell is not blank?

Use =IF(A1<>"","Available","Empty") to display a message based on the cell's content.

4. Can Excel check whether multiple cells are not blank?

Yes. Use the AND function to check whether all selected cells contain data, or OR to check whether at least one cell contains data.

5. Does Excel consider a formula returning an empty string as blank?

No. ISBLANK considers that cell non-blank because it contains a formula. However, a comparison such as =A1="" treats its displayed empty-string result as blank.

Final Thoughts

Checking whether a cell is not blank in Excel is a simple but useful technique for managing spreadsheet data. Whether you're tracking customer payments, checking employee information, validating forms, or preparing business reports, the right formula can save time and reduce manual work.

For most everyday situations, =A1<>"" is the easiest solution. If you need to display a message, combine it with the IFfunction. For more advanced checks, use AND, OR, or COUNTA depending on your requirements.

Once you understand these formulas, you can build more reliable and automated Excel spreadsheets without manually checking every cell.

COMMENTS

Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content