Exceljet

Quick, clean, and to the point

Convert pounds to kilograms

Excel formula: Convert pounds to kilograms
Generic formula 
=CONVERT(A1,"lbm","kg")
Explanation 

To build a simple table to convert pounds into kilograms (and stones!) you can use the CONVERT function. In the example shown, the formula in C5, copied down, is:

=CONVERT(B5,"lbm","kg")

Results will update automatically when values in column B change.

How this formula works

This formula relies on the CONVERT function, which can convert a number in one measurement system to another. To perform the conversion, CONVERT relies on "from" and "to" units entered as text. As long as the units  specify valid options, CONVERT will automatically perform a conversion and return a numeric result.

To convert pounds to kilograms, the formula used is in C5, copied down, is:

=CONVERT(B5,"lbm","kg")

Note: CONVERT is case-sensitive, so the text values used for units must match exactly.

Kilograms to pounds

To convert from kilograms to pounds, the formula would be:

=CONVERT(B5,"kg","lbm")

Pounds to Stones

To convert pounds to kilograms, the formula used in D5, copied down, is

=CONVERT(B5,"lbm","stone")

Table set-up

The table in the example shown uses formulas to make it easy to change the staring point and range of the values in column B. The formula in B5 simply points to G4:

=G4

The formula in G5, copied down, is:

=B5+$G$5

When values in G4 or G5 are changed, the values in column B update dynamically.

Other conversions

You can use CONVERT to convert weight, distance, time, pressure, force, energy, power, magnetism, temperature, liquid, and volume. Unit strings must be valid and in the proper case. This page shows available options in each category.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.