Problems vith Statistical Functions and Large Numbers in Excel (158071)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
- Microsoft Excel 2000
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0c
- Microsoft Excel 2004 for Mac
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
This article was previously published under Q158071 SYMPTOMS
In Microsoft Excel, when you use any of the following statistical
functions in a formula:
STDEV
STDEVP
LINEST
LOGEST
KURT
NEGBINOMDIST
BINOMDIST
The formula may return an incorrect result.
CAUSE
This behavior may occur when the formula refers to very large numbers
that, when summed, multiplied, or squared, exceed 15 digits in length.
REFERENCES
For additional information about the number of significant digits that Excel retains, click the following article number to view the article in the Microsoft Knowledge Base:
65903
Number of significant digits MS Excel retains
Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
---|
Keywords: | KB158071 |
---|
|