Clinical work mixes units — pounds and kilograms, inches and centimeters, mg/dL and mmol/L. Keep a small set of conversion factors so a spreadsheet always speaks the right language.
The example
154 lb to kg.
| A | B | |
|---|---|---|
| 1 | From | To |
| 2 | 154 lb | → 69.9 kg |
| 3 | 70 in | → 177.8 cm |
The formula
The formula:
How it works
How it works:
- Weight:
lb / 2.205→ kg;kg * 2.205→ lb. - Height:
in * 2.54→ cm;cm / 2.54→ in. - Glucose:
mg/dL / 18→ mmol/L (and ×18 to reverse). - Excel’s
CONVERTfunction handles many units directly:=CONVERT(154, "lbm", "kg").
Educational use only. These are general Excel formulas for learning spreadsheet techniques — not medical advice or a substitute for clinical judgment, professional guidelines, or verified dosing references. Always confirm calculations against authoritative sources and institutional protocols.
Try it: interactive demo
Enter a value and pick a conversion.
Variations
kg to lb
Reverse weight:
CONVERT function
Built-in:
Temperature
F to C:
Pitfalls & errors
Direction matters. Divide lb by 2.205 for kg; multiply kg by 2.205 for lb.
Glucose factor 18. mg/dL ÷ 18 = mmol/L for glucose specifically.
CONVERT unit codes. Use the exact text codes ("lbm", "kg", "in", "cm").
Practice workbook
Frequently asked questions
How do I convert pounds to kilograms in Excel?
How do I convert mg/dL to mmol/L for glucose?
Is there a built-in conversion function?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class