COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.
Syntax:
=COUNTBLANK(range)
range argument is used to give range from which Blank cell’s count is required
The IF function is often used to return empty strings. For example, if A1 contains 21, this formula in B1 will return an empty string:
=IF(A1>30,"Overdue","")
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:
Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
LOWER function is used for changing the format of any text or string to LOWER case.
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.
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…