How to Convert Kg to Lbs in Excel (4 Easy Methods)

by admin |Lượt xem: 4

Looking for ways to know how to convert kg to lbs? Then, this is the right place for you. Sometimes, we need to change kg to lbs. Such as, to calculate BMI some calculators want the values of weights in lbs. Here, you will find 4 different step-by-step explained ways to convert kg to lbs in Excel.

Table of Contents

Download Practice workbook

4 Ways to Convert Kg to Lbs in Excel

Here, we have the following dataset containing the Age and Weight of some Children. Weights are given in Kilogram(kg). You can convert these kilograms (kg) values to Pound(lbs) by using the following methods.

1. Using Generic Formula to Convert Kg to Lbs

To convert kg to lbs we will use the Generic Formula. In other words, we will multiply the kg value by 2.20462.

Steps:

First, select Cell E5.
Then, insert the following formula.

=D5*2.20462

Now, press ENTER.
Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Finally, values are now converted into lbs from kg.

2. Use of Paste Special Feature to Convert Kg to Lbs

We can also convert kg to lbs by using the Paste Specific Feature. To use this method, we inserted 2.20462 in Cell C13 as we know 1kg= 2.20462lbs.

Steps:

First, Copy the values of the Cells D5:D10 by using the keyboard shortcut CTRL+C.

Now, Paste the values in Cells E5:E10 by using the keyboard shortcut CTRL+V.

After that, Copy Cell C13 and select the Cells E5:E10.

Then, open the Home tab >> click on Paste >> select Paste Special.

The Paste Special box will open.
Then, select Multiply.
After that, press OK.

Finally, values are now converted into lbs from kg.

3. Using CONVERT Function to Convert Kg to Lbs

Besides these two methods, we can convert kg to lbs using the CONVERT Function too. This function can convert units units of different measurement systems.

Steps:

To begin with, select Cell E5.
Then, type the following formula.

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

Now, press ENTER to get the value in lbs.
Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Finally, the weights are converted to lbs from kg.

4. Excel VBA to Convert Kg to Lbs

For the final step, we will use VBA to convert kg to lbs. VBA is a programming language. When you run the macros, you can see the result in the resultant cell.

Steps:

First, open the Developer tab >> click on Visual Basic.

Otherwise, you can use the keyboard shortcut ALT+F11 to do this too.

Microsoft Visual Basic for Application bar will appear.
Then, from Insert >> select Module.

After that, a Module will open.

Write the following code in the Module.

Option Explicit Sub Convert_Kg_lbs() Dim row_number As Integer For row_number = 5 To 10 Cells(row_number, 5).Value = Cells(row_number, 4).Value * 2.20462 Next End Sub

Code Breakdown

First, we created Sub Procedure as Convert_Kg_lbs().
Then, we declared a variable row_number as Integer.
Next, we used a For Loop to go through from row 5 to row 10.
Then, within the For Loop used Cells.Value property to refer to the cell value of Column 4. Where Converted the Kg to Lbs by multiplying the value by 2.20462.
Finally kept the converted values in Column 5 by using Cells.Value property.

Finally, Save the code and go back to your sheet to execute your code.
First, from the Developer tab >> select Macros.

The Macro dialogue box will open up.
Inside the box choose your Macro. In our case, we chose Convert_Kg_Ibs code.
Then, press Run.

Finally, the weights are converted from kg to lbs.

Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Conclusion

So, in this article, you will find 4 ways to convert kilogram (kg) to Pound (lbs) in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!