Numeric precision in Microsoft Excel: Difference between revisions

Revision as of 09:33, 18 October 2010

Revision as of 07:19, 27 November 2010

Line 142:

</ref> Choice of variable types in a VBA calculation involves consideration of storage requirements, accuracy and speed.

===Accuracy with Integers===

Excel 2010 also produces accuracy problems with [[integers]]. For example,

=111111111*111111111

produces a result 21 short of the true answer. This is a problem in countries with extreme [[inflation]] where monetary values can increase beyond Excel's capability.

==References==