In this article, we perform a logical test to get results from non-blank cells.
We will use IF & ISBLANK function. The mathematical formulation is a method of Excel 2016 which let you perform many functions.
IF function performs a logic_test and returns values based on the result of the condition.
Syntax of IF function:
ISBLANK function checks the cell and returns True or False on the basis of the cell is blank or not.
Syntax of ISBLANK function is
Example: Cell A2 contains the text XYZ
=ISBLANK (A2), function will return“FALSE”
Cell A3 contains nothing
=ISBLANK (A3), function will return “TRUE”
Let’s understand with an example here
ISBLANK function checks the cell D5.
IF function performs a logic_test if the test is true, it returns blank value else the same value.
The resulting output will be like
As you can see in the above snapshot that the function only return results from Non-Blank cells, leaving the blank cells blank
Hope you learned how to use IF and ISBLANK function in Excel from this article. You can perform these functions in Excel 2013 and 2010. Explore more articles on IF & ISBLANK function. Please mention your unresolved query in the comment box below. We will help you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.