Explanation
The goal is to display a blank cell based on a specific condition.
If the value in column B is anything else, we want to display nothing.
It is important to understand that the IF function is not case-sensitive.
However, numeric valuesshould notappear in quotes.
Note if you jot down "" directly into a cell in Excel, youwill seethe double quote characters.
In other words, while you would expect ISBLANK to return TRUE, it actually returns FALSE.
More than one condition can be tested by nesting IF functions.
For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.
COUNTBLANK Function
The Excel COUNTBLANK function returns a count of empty cells in arange.
Cells that contain text, numbers, errors, spaces, etc.
Formulas that return empty strings ("")arecounted as blank.
Related videos
The IF function
