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:
This tutorial explains how the TRANSPOSE function works and shows you the right way to use it to switch data in Excel.
Everyone has different preferences, even for work habits. Some people like to arrange data in vertical columns, while others prefer horizontal rows. If you ever need to switch the direction of your data quickly, the TRANSPOSE function can help
Watch: How to use COUNT & COUNTA Function in Excel? What is COUNT Function? The COUNT function in Excel counts the number of cells in a range that contain numbers Click here to Read full Tutorial…
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
WORKDAY Function in Excel Are you working today? or Do you have Work Off or holiday today? I am asking this question because I am gonna tell you the most commonly used function in Excel…
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.