Complete Excel VBA Course

Microsoft Excel “ISBLANK Function” is a Logical Function and it is used to check if cell in question is  “BLANK OR NON-BLANK”.  “ISBLANK Function” is used as a test to validate if cell contains any value or not.

“ISBLANK Function” returns the output as “TRUE” or “FALSE”. If cell value is “BLANK” or “EMPTY” then function will return value as “TRUE” or if cell value is “NON-BLANK” then function output will be “FALSE”

“ISBLANK Function” has only one argument i.e. (value) and it is easy to apply for validation of cell, it provides the output that is easy to understand i.e. “TRUE” and “FALSE”

Complete Excel VBA Course

Advantage of “ISBLANK Function”:

“ISBLANK Function” can be used in multiple database or cells whether it is Numeric/Alpha (Strings) etc. which makes the function useful and advantageous. Applying the logical function manually (one by one) to validate if cell is “BLANK” or “NON-BLANK” is very tedious and “ISBLANK Function” helps apply the function in large database at once and makes the work easy, saves time and increases efficiency

Where “ISBLANK Function” can be used

“ISBLANK Function” is very useful and can be used in multiple situations. Like it can be used as follows:

– Validation of Application Forms (i.e. to check if all the mandatory fields are filled)

– Checking the cells with other databases if any empty cells

– Likewise, whenever there is requirement of validation of cells if those are empty or not then “ISBLANK Function” can be used

Syntax:

=ISBLANK(value)

Syntax Description:

value, argument is used to give the cell reference. It is the cell number, which is to be checked, if it is “BLANK or Non-BLANK”.

Things to Remember:

We need to understand the function output. If output is “TRUE” it means cell is “BLANK” or Empty and if output is “FALSE” it means cell is “NON-BLANK” or has Value.
Also ensure that correct cell reference is given otherwise function output and decisions may go wrong.

Example 1: Validation of Application Forms

Suppose we have database of application form filled by the applicants and we need to validate that all mandatory fields are filled. We can utilize this function as follows:

Syntax: = ISBLANK(B2)
ISBLANK Function

Likewise, we can apply the “ISBLANK Function” whenever there is requirement of validation of Blank or Empty cells

Hope you liked. Happy Learning.

Don’t forget to leave your valuable comments!

Recommended Articles

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *