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”
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!
This tutorial shows how to quickly change CSV files into Excel in any version, from 365 to 2007, without common problems.
There are two main ways to move a CSV file to Excel: by opening it directly or by importing it as external data. This article gives step-by-step instructions for both methods, explains their pros and cons, and highlights potential problems with tips to fix them
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.
What is Absolute Value in Excel? The absolute value of a number is its distance from zero on the number line, regardless of direction, so it’s always a non-negative number. The ABS function in Excel…
This guide will show you quick and easy methods to find the number of days between dates in Excel.
Do you need to know how many days are between two dates? Maybe you want to find out the days between today and a date in the past or future, or just count the working days between two dates? Whatever you need, one of the examples below will help you find the solution
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.