Arin Islam
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.
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.
Similar Readings
- How to Convert Feet to Meters in Excel (4 Simple Methods)
- Convert Meters to Miles in Excel (3 Simple Methods)
- How to Convert Decimal Feet to Feet and Inches in Excel (3 Methods)
- Convert Meters to Feet in Excel (4 Useful Methods)
- How to Convert Feet to Inches in Excel (4 Quick Methods)
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!
Related Articles
- Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)
- How to Convert Square Feet to Square Meters in Excel (2 Quick Methods)
- Convert MM to CM in Excel (4 Easy Methods)
- How to Convert Inches to Square Feet in Excel (2 Easy Methods)
- Converting CM to Inches in Excel (2 Simple Methods)
- How to Convert CM to Feet and Inches in Excel (3 Effective Ways)
- Convert Cubic Feet to Cubic Meters in Excel (2 Easy Methods)
