This article was previously published under Q158071
In Microsoft Excel, when you use any of the following statisticalfunctions in a formula:
STDEV STDEVP LINEST LOGEST KURT NEGBINOMDIST BINOMDIST
The formula may return an incorrect result.
This behavior may occur when the formula refers to very large numbersthat, when summed, multiplied, or squared, exceed 15 digits in length.
Microsoft Excel supports a maximum of 15 significant digits at all times.This limit applies to a value that is calculated by a formula. Because ofthis limitation, if at any time a formula calculates a value that exceeds15 digits in length, digits beyond the fifteenth significant digit arechanged to zeroes. This may cause the formula to return an incorrectresult.
For example, when you use the STDEV function to calculate the standarddeviation of a set of numbers, part of the function sums the numbers andthen squares the result. If this number exceeds 15 digits in length,digits beyond the fifteenth digit are changed to zeroes. This affects thefinal result delivered by the formula. To see an example of this behavior,enter the following data in a worksheet:
Although both formulas return the same standard deviation, 1, the secondformula returns a zero. Because the square of the sum of the three valuesin B1:B3 is greater than 15 digits in length, digits beyond the fifteenthdigit are changed to zeroes. This causes the formula to return anincorrect result.
This behavior may occur when you use any of the statistical functionslisted in this article and you work with very large values. This is truebecause these functions all use squared values, which makes it probablethat the limit of 15 significant digits is exceeded.
The exact formulas used by functions in Microsoft Excel are listed in theHelp topic for each function in Microsoft Excel Help.
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