Microsoft KB Archive/192281

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

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.

