Microsoft Office Tutorials and References
In Depth Information
Getting to Know Your Type
16 is returned for errors.
64 is returned for arrays.
Figure 15-6 shows each of these values returned by the TYPE function. Cells
B3:B7 contain the TYPE function, with each row looking at the adjacent cell
in Column A. The returned value of 64 in cell B7 is a little different. This
indicates an array as the type. The formula in cell B7 is =TYPE(A7:A9). This is
an array of values from cells A7:A9.
Figure 15-6:
Getting the
type of the
data.
Here’s how to use the TYPE function:
1. Position the cursor in the cell where you want the results to appear.
2. Enter =TYPE( to begin the function entry.
3. Enter a cell address, or click a cell.
4. Enter a ), and press Enter.
The ERROR.TYPE function returns a number that corresponds to the
particular error in a cell. Table 15-5 shows the error types and the returned numbers.
Table 15-5
Getting a Number of an Error
Error Type
Returned Number
#NULL!
1
#DIV/0!
2
#VALUE!
3
#REF!
4
#NAME?
5
#NUM!
6
#N/A
7
Search JabSto ::




Custom Search