XL98: TYPE() Function Doesn't Return Value 8 for Formula (192281)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
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
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbinfo KB192281 |
|---|
|