Share via

Excel CONVERT function is inaccurate when converting lbm to kg

Anonymous
2016-09-20T20:46:58+00:00

Why does the CONVERT function  inaccurately converting between metric mass and US weight incorrectly.

When using the CONVERT function from "lbm" to "kg" the function returns the following value:

0.453592309748811   (0.453 592 309 748 811)

However, according to United States Code, Title 15, Chapter 6, Subchapter I, § 205. Authorized tables:

1 pound (avoirdupois)=0.453 592 37 kilogram (exactly)

This may not mean much but it does present some issues when performing large batch formulation conversions.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2016-09-20T21:01:38+00:00

    Which version of Excel are you using? I get the following result in Excel 2016 for Windows:

    Was this answer helpful?

    0 comments