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