EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Information Functions in Excel Excel ISBLANK Function
Secondary Sidebar
Excel Functions
  • Information Functions in Excel
    • ISNUMBER Excel Function
    • ISNA Excel Function
    • Excel ISBLANK Function
    • ISERROR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Excel Charts (56+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training Course
  • Online Excel Data Analysis Certification

Excel ISBLANK Function

By Jeevan A YJeevan A Y

ISBLANK Function in Excel

ISBLANK in Excel (Table of Contents)

  • ISBLANK in Excel
  • ISBLANK Formula in Excel
  • How to Use ISBLANK Function in Excel?

ISBLANK in Excel

IsBlank function calculates if the selected cell is Blank or not by giving the answer in Boolean. If the cell we select is blank, then we get TRUE; else, we will get FALSE. It is a simple Boolean function whose answer is TRUE or FALSE statement gives the justification if the cell is Blank or not. It is quite useful when we have a huge list of the cell, and some of them have special characters, or dummy characters will seem just like a blank cell. There IsBlank is quite useful.

Start Your Free Excel Course

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

ISBLANK Formula in Excel

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 nothing but the targeted cell that 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 is checking if the selected cell is blank. If the selected cell is blank, then the status will be updated as Need 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.

ISBLANK Example 4-1

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

ISBLANK Example 4-2

 

Step 3: Apply the below formula first.

ISBLANK Example 4-3

 Step 4: Now click on Format and select Fill.

ISBLANK Example 4-4

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

ISBLANK 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”.

ISBLANK Example 5

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

This can be sorted out by using the Vlookup function along with the ISBLANK function.

 Follow the below steps to learn how to do it.

ISBLANK 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, a formula is blank or not.

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

ISBLANK Example 5-2

Drag and drop the formula to the remaining cells.

ISBLANK 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.

ISBLANK Example 5-4

  • Select the rule type and edit the Rule description.

ISBLANK Example 5-5

  • Now click on Format.

ISBLANK Example 5-6

  • Select the color whatever you want.

ISBLANK Example 5-7

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

ISBLANK 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
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Primary Sidebar
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

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