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”
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
“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)
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!
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.
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.
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the…
Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.