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 still using 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 on how to convert values given 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 mass (weight) measurements while other countries in the world use ‘kilograms’ to measure mass.
You can convert metric (global) and imperial (US) units in Excel either manually or by using the CONVERT function.
To manually convert weight in excel, you need to know units of mass:
- 1 kg = 2.2046226218 lbs
- 1 lbs = 0.45359237 kg
Kg to Lbs Formula
To convert kg to lbs, simply multiply the number with 2.2046226218 or divide by 0.45359237:
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’re about type a formula not a value. Then, enter the above formulas. Make sure to replace ‘m’ with the numeric value you wish to convert.
Or, you can divide 20 by 0.45359237 (kg).
Lbs to Kg Formula
This is the opposite method of kg to lbs conversion. To convert lbs to kg, simply multiply the number with 0.45359237 or divide by 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 measurement to another measurement. It’s not limited to only weight units. You can convert length, area, temperature, distance and there is a range of other metrics inside the convert function.
The Formula is as follows:
The CONVERT formula has three arguments:
numberis the numeric value we want to convert.
from_unitis the unit to convert from.
to_unitis the unit to convert to.
To convert, you need to enter both the value and unit types into the formula. The value can be entered as a number or cell reference, but 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 to make that happen.
kg stands for kilogram and
lbm stands for pounds.
Let’s test that in the worksheet.
Let’s use cell reference instead of numbers this time.
‘lbs’ is most commonly used abbreviation for pounds, but in excel you need to use ‘lbm’.
To convert pounds to kilogram, enter
from_unit as ‘lbm’ and
to_unit as ‘kg’ in the formula.
You can also use the fill handle at the bottom right corner of the formula cell to drag and copy the formula to the rest of the cells to convert an entire column.