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
Rounds total ounces to one decimal first, then splits them into whole pounds and remaining ounces. This carries a rounded 16.0 oz into the next pound.
=IF(B2 < 0, "Invalid Negative Weight", INT(ROUND(B2 * 16, 1) / 16) & " lb " & ROUND(MOD(ROUND(B2 * 16, 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.