XL98: TYPE() Function Doesn't Return Value 8 for Formula

ID: Q192281

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

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:

Q179216 OFF98: How to Use the Microsoft Office Installer Program

Additional query words: XL98

Keywords : kbdta xlformula
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbinfo