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.
type of the
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.
Getting a Number of an Error