XL2000: LINEST Function Returns Only One Value (214082)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214082

SYMPTOMS

The LINEST worksheet function returns only one value (the slope) when multiple values should be returned.

CAUSE

This behavior occurs when one cell is selected when you type the LINEST formula, and you then press CTRL+SHIFT+ENTER.

WORKAROUND

To return the additional regression statistics, select a range of cells consisting of "n" columns (where n represents the number of known x's) and 5 rows.

NOTE: Because LINEST is an array formula, you must enter the function as an array. To do this, press CTRL+SHIFT+ENTER.

The syntax of the LINEST function is as follows:

=LINEST(known_y's,known_x's)

NOTE: "known_y's" and "known_x's" are ranges on the worksheet containing the y-values and the x-values, respectively.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb KB214082
©2003 Microsoft Corporation. All rights reserved.