In this case we're using if with the isblank function: You can prevent these indicators from being displayed by using the following procedure. Hide or display zero values in excel worksheets by using an option in the advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in pivottable reports. Use the countblank function, one of the statistical functions, to count the number of empty cells in a range of cells. The cell function returns information about the formatting, location, or contents of a cell For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula:
Make sure the divisor in the function or formula isn't zero or a blank cell Change the cell reference in the formula to another cell that doesn't have a zero (0) or blank value. Select the cells that contain the zero (0) values that you want to hide The hidden values appear only in the formula bar — or in the cell if you edit the contents directly in the cell — and are not printed when you print the sheet. Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data Select the cell where you want the result to appear.
For example, if the range contains a formula that returns an empty string, the counta function counts that value. Use is functions like iserror or iserr to see if an error condition exists, isblank to check if cells are empty, or isnumber to check if values are numbers.
WATCH
