Microsoft KB Archive/98650

{| = XL3: LINEST Returns #NUM! Error for r^2 =
 * width="100%"|

Last reviewed: February 2, 1998

Article ID: Q98650 The information in this article applies to:
 * Microsoft Excel for Windows, version 3.0
 * Microsoft Excel for the Macintosh, version 3.0

SYMPTOMS
If you are using the LINEST function in Microsoft Excel version 3.0, you receive the #NUM! error value for r^2 (coefficient of determination).

CAUSE
This problem occurs if all of the values for the known_y's argument are the same.

STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel version 3.0. This problem was was corrected in Microsoft Excel version 4.0.

MORE INFORMATION
In Microsoft Excel version 4.0, 1 is returned for r^2.
 * }