With globalization and the internet, we can reach information from all around the world. Struggling between units has become a daily work while dealing with intercontinental standards. In this guide, we are going to show you how to convert kg to lbs and lbs to kg.

Download Workbook

Manual Approach to convert Kg to Lbs

As the first approach, we are going to show you the manual way. You can convert kg to lbs by a simple math calculation. 1 kg is approximately equal to 2.2 lbs. Thus, you need to multiply the kilogram-value by 2.2 to get the value as pounds.

Let's say the cell C2 contains the kilogram-value. Use the formula below to find the pound-value.

=C2*2.2

In a similar way, you can convert pounds to kilograms by manual calculation as well. As you can see in the above screenshot, dividing a pound-value by 2.2 returns the value in kilograms basis. If we assume the cell C5 contains the pound value, the conversion formula will be

=C5/2.2

Continue reading to learn a more dynamic and relatively easy to remember approach.

Using CONVERT Function

Another way to convert kg to lbs is the CONVERT function. The CONVERT function can convert a number from one measurement system to another. The cool thing is that the function is not limited with kg and lbs only.  You can convert weight, distance, temperature and more categories of measurements.

You can find more information about the CONVERT function with samples in our guide: Excel CONVERT Function

Briefly, you need to supply the value and both measurement types to the function. Excel accepts string abbreviations of the measurement types:

  • Kilograms: "kg"
  • Pounds: "lbm"

As a result, to convert the value in cell B5, you need to use the formula below:

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

To make the conversion in an opposite way, replace the measurement arguments. The following formula converts the value from pounds to kg.

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