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:
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k