Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: LINEST Function Returns Only One Value

XL2000: LINEST Function Returns Only One Value

View products that this article applies to.

This article was previously published under Q214082

↑ Back to the top

Symptoms

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

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB214082, kbprb

↑ Back to the top

Article Info
Article ID : 214082
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 399