Microsoft Office Tutorials and References
In Depth Information
Using TYPE to Determine the Type of Cell Value
Figure 12.19.
Figure 12.19. The Watch Window always shows the last cell changed and the
The Watch Window always shows the last cell changed and the
value of that cell. Note that as in this case, the last changed cell might be
value of that cell. Note that as in this case, the last changed cell might be
on another worksheet.
on another worksheet.
Using
Using TYPE
to Determine the Type of Cell Value
The final information function is the TYPE function. You use =TYPE(value)
to determine whether a value is a number, text, logical, an error value, or an
array. Note that dates are treated as numbers.
TYPE to Determine the Type of Cell Value
Syntax:
=TYPE(value)
The TYPE function returns a numeric code that tells you about the type of
value.
The TYPE function returns the following values:
1 For a numeric or date type
2 For a text type
Search JabSto ::




Custom Search