Microsoft KB Archive/214082

= XL2000: LINEST Function Returns Only One Value =

Article ID: 214082

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.

Additional query words: arrays 1 XL2000

Keywords: kbprb KB214082

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.