EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Information Functions in Excel Excel ISBLANK Function

Excel ISBLANK Function

By Jeevan A YJeevan A Y

ISBLANK Function in Excel

ISBLANK in Excel

The ISBlank function in Excel calculates whether the selected cell is Blank by answering Boolean. If the cell we select is blank, we get TRUE; otherwise, we will get FALSE. It is a simple Boolean function whose answer is a TRUE or FALSE statement that justifies whether the cell is Blank. It is quite useful when we have a huge list of cells, some of which have special characters, or dummy characters will seem just like a blank cell.

ISBLANK Formula in Excel

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

The Formula for the ISBLANK Function in Excel is as follows:

ISBLANK Formula in Excel

The Formula of ISBLANK includes only one parameter, i.e. value

Value: This is the targeted cell you want to test.

How to Use ISBLANK Function in Excel?

ISBLANK Function in Excel is very simple and easy to use. Let us understand the working of ISBLANK in Excel by Some Examples.

You can download this ISBLANK Function Excel Template here – ISBLANK Function Excel Template

Example #1

This is the basic example of the ISBLANK Formula in Excel. I have data in column A form A2:A11. I need to check which row has a blank cell, i.e. without any values.

ISBLANK Example 1

Apply the ISBLANK function in B2

ISBLANK Example 1-1

The Formula for ISBLANK Function is given below:

ISBLANK Example 1-2

The result is:

ISBLANK Example 1-3

Drag and drop the formula to the remaining cells.

ISBLANK Example 1-4

This arrow shows the cell which is blank and returns the value as True.

ISBLANK Example 1-5

Example #2

This is an example of a bit advanced. Cleaning the data if our formula shows any errors.

Assume we have data from A2:A15, as shown in the below image.

ISBLANK Example 2

I have applied the formula in column B to check the empty cells.

ISBLANK Example 2-1

It returns the result as:

ISBLANK Example 2-2

Drag and drop the formula to the remaining cells.

ISBLANK Example 2-3

ISBLANK Example 2-4

In the above formula, even though the cells A9 and A14 do not have anything, our formula still says there is something in the cells that show the result as FALSE.

Ok, let me clean the data by using LEN and TRIM functions.

Firstly, I want to check the number of characters in the cell by using the LEN function.

ISBLANK Example 2-5

LEN Function returns the result as:

ISBLANK Example 2-6

Drag and drop the formula to the remaining cells.

ISBLANK Example 2-7

LEN function determines there are characters in the cells.

ISBLANK Example 2-8

Now I need to clean the cell by using the TRIM function.

ISBLANK Example 2-9

TRIM Function returns the result as:

ISBLANK Example 2-10

Drag and drop the formula to the remaining cells.

ISBLANK Example 2-11

TRIM function clears all the unwanted spaces and returns the actual values. Since there are no values in cells A9 & A14, now the ISBLLANK formula returns the result as TRUE.

ISBLANK Example 2-12

Example #3

We can track our checklist by using the ISBLANK function. I have a traveling checklist, and if the particular item is already selected, then I have marked that as YES or else blank.

ISBLANK Example 3

Now I need to identify the status.

I am going to use ISBLKANK with another logical function called IF.

ISBLANK Example 3-1

ISBLANK with IF Function returns the status:

ISBLANK Example 3-2

Drag and drop the formula to the remaining cells.

ISBLANK Example 3-3

The formula IF checks if the selected cell is blank. If the selected cell is blank, the status will be updated as Needed to mention remarks. If the selected cell is not blank, then the status is updated.

ISBLANK Example 3-4

Example #4

We can use the ISBLANK to highlight all the blank cells by using Conditional Formatting.

I have a numbers list in the Excel sheet, but it also includes blank cells with pink color.

ISBLANK Example 4

Step 1: Select the data.

Example 4-1

Step 2: Click on Conditional Formatting at the home tab and select a new rule.

Example 4-2

 

Step 3: Apply the below formula first.

Example 4-3

 Step 4: Now click on Format and select Fill.

Example 4-4

 Step 5: Now click on Ok. This would instantly highlight all the blank cells.

Example 4-5

Example #5

Assume you are collecting the database for your business. Below is the collected data so far. Now the challenge is we do not have all the data. Wherever blank is where we need to find those and mark them as “Not Yet Received”.

Example 5

Ok, in table 1, I have the actual data. Now I need to pull the data from table 1 and mention it in table 1. If the data is there, I need to mark that as “Received” if “Not Yet Received”.

This can be sorted out using the Vlookup function and the ISBLANK function.

 Follow the below steps to learn how to do it.

Example 5-1

Closely look at the formula here.

=IF (ISBLANK (VLOOKUP ($E4,$A$3:$C$10,2,0)), “Not Yet Received”, “Received”)

IF formula is checking the value returned by VLOOKUP, is a formula blank or not.

If the value returned by the VLOOKUP formula is not blank, it will return the result as “Received.”

Example 5-2

Drag and drop the formula to the remaining cells.

Example 5-3

Now highlight all the Not Yet Received results by using Conditional Formatting.

  • Select the data and click on Conditional Formatting and New Rule.

Example 5-4

  • Select the rule type and edit the Rule description.

Example 5-5

  • Now click on Format.

Example 5-6

  • Select the color you want.

Example 5-7

  • This would instantly highlight all the “Not Yet Received ” cells.

Example 5-8

Things to Remember

  • ISBLANK can only find you the blank cells in the cell.
  • ISSBLANK can only be applied to a single cell at a time. We cannot select the range of cells for this formula. If you have selected the range of cells, it will read only the first cell as its reference.
  • ISBLANK is one of many IS functions in Excel. Other IS functions are ISTEXT, ISERROR, ISNA, ISNUMBER, ISREF, etc…

Recommended Articles

This has been a guide to ISBLANK in Excel. Here we discuss the ISBLANK Formula in Excel and how to use ISBLANK Function in Excel, along with Excel examples and downloadable Excel templates. You may also look at these useful functions in Excel –

  1. COUNTIF Not Blank in Excel
  2. Remove (Delete) Blank Rows in Excel
  3. Excel ISNUMBER Formula
  4. Write Formula in Excel
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 223+ Hours of HD Videos
35 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download ISBLANK Function Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download ISBLANK Function Excel Template

EDUCBA

डाउनलोड ISBLANK Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Hurry! - Any Learning Path @ $19 | OFFER ENDING IN ENROLL NOW