XL2000: Faulty Zero Value When You Fill Linear Trend Series (214366)
The information in this article applies to:
This article was previously published under Q214366 SYMPTOMS
When you fill a linear trend series in a worksheet in Microsoft Excel, the series may
contain a value similar to either of the following:
2.84217E-14
-or-
-1.70530E-13
One of these values appears where you expect to see a zero value. For example, if you expect the linear trend series to appear as follows
100 75 50 25 0 -25 -50
it appears as follows:
100 75 50 25 2.84217E-14 -25 -50
CAUSE
This problem may occur if both of the following conditions are true:
- The linear trend series should contain the value zero (0).
-and-
- You are using the right mouse button to create the linear trend series.
Specifically, this problem results from a rounding error that occurs
in Microsoft Excel when you work with near-zero values.
WORKAROUND
To work around this problem, clear the cell that contains the incorrect
value and type a zero (0) in the cell.
To prevent this problem from occurring, follow these steps:
- Select all the cells to be used by the series.
- On the Edit menu, click Fill, and then click Series.
The problem does not occur when you use this method to fill a linear trend series.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCESFor additional information about rounding errors, click the article number below
to view the article in the Microsoft Knowledge Base:
182196 XL2000: Floating-Point Arithmetic May Give Inaccurate Results
Modification Type: | Major | Last Reviewed: | 10/8/2003 |
---|
Keywords: | kbbug kbpending KB214366 |
---|
|