Microsoft KB Archive/283695

= XL2000: CONVERT Function Returns Incorrect Calculation for Liters and Quarts =

Article ID: 283695

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q283695



SYMPTOMS
When you use the CONVERT function from the Analysis Toolpak to convert liters to quarts, or quarts to liters, the result is incorrect beyond the third decimal place.



CAUSE
The Analysis Toolpak converts 1 liter to 1.056458333 quarts, but it should convert to 1.056689266 quarts.

The Analysis Toolpak converts 1 quart to 0.946558864 liters, but it should convert to 0.946352 liters.



WORKAROUND
To work around this problem, use the following formulas to change between liters and quarts:

Quarts = Liters*.946352

Liters = Quarts/.946352



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

