Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
COUNTBLANK used to calculate the specified range in the number of blank cells. Its grammatical form of COUNTBLANK (range) in which the requirements of Range for the cell in which the number of blank areas. It should be noted that, Even if the cell contains the text of the return value is empty ( "") formula, which will also be taken into the cell, but contains zero cells are not taken into account. As shown in the example, cell B3, including the formula = IF (A3 <30, "", A3), but the formula returns the text value is empty "", so the cell has been calculated for empty cells . The value of cell A3 cells to zero, excluding for empty cells. Comparing Figure 3-A and Figure 3-B the results of the distinction, the difference is between Figure 3-B cell B3 in the formula = IF (A3> 30, "", A3), after the return to the results of the calculation to 0, so for non-empty cells.
Return ERROR.TYPE corresponds to a Microsoft Excel error values in the figures, or, if no error is returned # N / A. Grammatical form of ERROR.TYPE (error_val) for Error_val which need to be an error in its value label. Although error_val error for the actual value, but it is often cited as a cell, and this cell contains the formula for the needs of testing. The following is a function of the return of the results of error_val.
|
