Math & Everyday Calculations
Convert Pounds (lb) to Kilograms (kg), Stones & Compound lb + oz Formula
Convert avoirdupois pounds to exact kilograms (* 0.45359237), kilograms back to pounds (/ 0.45359237), UK stones + pounds, and postal pounds + ounces using pure arithmetic that works in every spreadsheet.
Use the exact 1959 International Pound definition: 1 lb = 0.45359237 kg!
Logistics manifests, air-cargo load sheets, clinical pediatric dosing tables, and e-commerce parcel labels constantly convert between US customary avoirdupois pounds (lb), SI kilograms (kg), parcel ounces (16 oz = 1 lb), and UK imperial stones (1 stone = 14 lb). Approximating 1 kg as "2.2 lb" introduces a 0.21% systematic error—over 42 kg of discrepancy on a 20-ton shipping container!
By the 1959 International Yard and Pound Agreement, 1 avoirdupois pound is DEFINED as exactly 0.45359237 kilograms (so 1 kg = 1 / 0.45359237 = 2.20462262185 lb). Using exact multiplication and division works universally across Excel and Arte Sheets without needing the Analysis ToolPak CONVERT add-in—and pairing INT(lb) with ROUND(MOD(lb, 1) * 16, 1) formats decimal scale readings like 12.625 lb into carrier-ready "12 lb 10 oz"!
| Input Weight | Exact Kilograms (kg) | Compound Pounds & Ounces | UK Stones & Pounds |
|---|---|---|---|
| 12.625 lb (Parcel Scale) | 5.727 kg | 12 lb 10 oz (0.625 * 16 = 10) | 0 st 12.6 lb |
| 154.000 lb (Adult Patient) | 69.853 kg | 154 lb 0 oz | 11 st 0.0 lb (154 / 14 = 11) |
| 100.000 kg -> Pounds | 220.462 lb (Exact!) | 220 lb 7.4 oz | 15 st 10.5 lb |
Convert Pounds (lb) to Exact Kilograms (kg)
Multiplies pounds B2 by the exact international constant 0.45359237 kg/lb.
=IF(B2 < 0, "Invalid Negative Weight", ROUND(B2 * 0.45359237, 3))Format Decimal Pounds into Postal "X lb Y oz" Text
Splits whole pounds via INT(B2) and converts the fractional remainder MOD(B2, 1) * 16 into ounces.
=IF(B2 < 0, "Invalid Negative Weight", INT(B2) & " lb " & ROUND(MOD(B2, 1) * 16, 1) & " oz")Convert Kilograms (kg) Back to Pounds (lb)
Divides kilograms B3 by 0.45359237 for exact inverse conversion.
=IF(B3 < 0, "Invalid Negative Weight", ROUND(B3 / 0.45359237, 3))Try the example
Use the original values or change them to test your understanding.