This tutorial will demonstrate how to convert values given in kilograms (Kg) to pounds (Lbs) or vice versa in Excel.
While the rest of the world uses the metric system as the primary means of weights and measures, the United States, Myanmar, and Liberia are the only three countries that still use the old imperial or British system.
But don’t worry, you can easily convert kilograms (Kg) to pounds (Lbs) or pounds to kilograms in Excel. This post will guide you how to convert given values in Kg to Lbs or vice versa in Excel.
Convert kilograms to pounds and pounds to kilograms in Excel
The United States of America uses ‘pounds’ as one of the basic measurements of mass (weight), while other countries around the world use ‘kilograms’ to measure mass.
You can convert metric (global) and imperial (US) units in Excel manually or by using the CONVERT function.
manual method
To manually convert weight in Excel, you need to know the units of mass:
- 1 kg = 2.2046226218 pounds
- 1 pound = 0.45359237 kg
kg to pound formula
To convert kg to lbs, simply multiply the number with 2.2046226218 or divide by 0.45359237:
=m*2.2046226218
either
=m/0.45359237
Where m is the numeric value we want to convert. Both formulas return the same answer.
First, select the cell where you want the result and type = sign to inform Excel that you are about to enter a formula, not a value. Then enter the above formulas. Be sure to replace ‘m’ with the numeric value you want to convert.
Or, you can divide 20 by 0.45359237 (kg).
pound to kg formula
This is the opposite method of converting from kg to lbs. To convert lbs to kg, simply multiply the number with 0.45359237 or divide by 2.2046226218:
=m*0.45359237
either
=m/2.2046226218
Convert Kg to Lbm/Lbs using the CONVERT function in Excel
Another way to convert kilograms to pounds is by using the CONVERT function. The CONVERT function is the best method to convert one measure to another measure. It is not just limited to weight units. You can convert length, area, temperature, distance, and there are a variety of other metrics within the conversion function.
The formula is as follows:
=CONVERT(number,from_unit ,to_unit)
The CONVERT formula has three arguments:
- number is the numeric value we want to convert.
- from_unit is the unit to convert from.
- to_unit is the unit to convert.
To convert, you must enter both the value and unit types into the formula. The value can be entered as a number or cell reference, but the units must be entered as string abbreviations of the measurement types.
Here, we want to convert the weight measurement in kilograms to pounds. Below is the generic formula for that to happen.
=CONVERT(value,"kg","lbm")
kg means kilogram and lbm means pounds.
Let’s test that in the worksheet.
Let’s use cell reference instead of numbers this time.
‘lbs’ is the most commonly used abbreviation for pounds, but in Excel you need to use ‘lbm’.
To convert pounds to kilograms, enter from_unit like ‘lbm’ and to_unit as ‘kg’ in the formula.
You can also use the fill handle in the lower right corner of the formula cell to drag and copy the formula to the rest of the cells to convert an entire column.
