Microsoft Office Tutorials and References
In Depth Information
ERROR.TYPE
The formula:
=COUNTBLANK(H8:H13) returns the result of 4, because 4 of the six cells within the step 5
range are blank. When a date is entered the number of blank cells decreases.
B
Counts blank cells in a range
Figure 7.2
The COUNTBLANK
function returns the
number of blank cells
within the specified
range.
1
Total phases
3
Returns percent complete
ERROR.TYPE
Returns the corresponding number value associated with an error type in Microsoft Excel.
=ERROR.TYPE(error_val).
The ERROR.TYPE function returns a number associated with an Excel error type. The table
example in Figure 7.3 shows the Excel number result and the error type. You can use the
ERROR.TYPE function with the IF function to display custom text messages instead of errors as
shown in cell C22 of Figure 7.3.
This is the error value of the number you’re looking for. This is usually
used in the form of a reference to another cell. So, for example, it would
be a cell.
ERROR_VAL
Search JabSto ::




Custom Search