Article ID: 192281
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
This article was previously published under Q192281
SYMPTOMS
In Microsoft Excel, when you use the TYPE() function on a worksheet to
return the type of information in a cell, the value 8 is not returned when
the cell contains a formula.
CAUSE
The TYPE() function returns information about the type of value that is
contained in a cell. Microsoft Excel Help indicates that the TYPE()
function returns 8 when the cell you are evaluating contains a formula.
However, when the cell contains a formula, the TYPE() function returns a
number based on the value returned by the function, not the function
itself.
Example
A1: =SUM(B1:C3)
A2: =TYPE(A1)
Because the function in cell A1 returns a number value, the TYPE()
function in cell A2 returns the value 1, for a number value, instead
of the value 8 for a formula value.
REFERENCES
For more information about the TYPE function, click the Office Assistant,
type
type function, click Search, and then click to view "TYPE."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
179216 OFF98: How to Use the Microsoft Office Installer Program
Additional query words: XL98
Keywords: kbinfo KB192281