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

Microsoft Excel is used all over the world to organize data and perform financial analysis. It works better than a calculator and it’s easy to use. While working with a dataset you might need to convert values to a different unit. Excel does have some built-in features to do it. You can convert pound values to kilogram values easily. In this article, I will show you how you can convert lbs to kg in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Simple Methods to Convert Lbs to Kg in Excel

Today I will describe 3 simple methods to convert pound (lbs) to kilogram (kg) in excel.

Suppose we have a dataset of some Patient Names and their Weight in pound units.

Convert Lbs to Kg in Excel


1. Use CONVERT Function to Convert Lbs to Kg in Excel

There are different ways to convert values to a specific unit. The CONVERT function in excel converts a numeric value from one measurement unit to another measurement unit. You can call this CONVERT function a pocket calculator for converting units.

Steps:

  • Select a cell to write the formula. Here I have selected cell (E5).
  • Put the formula down-
=CONVERT(D5,"lbm","kg")

Use CONVERT function to Convert Lbs to Kg in Excel

  • Press Enter and drag down the “fill handle” to get the output in all cells.

  • Here you will see we have all our pound (lbs) values converted into kilogram (kg) by using formulas.

Use CONVERT function to Convert Lbs to Kg in Excel

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


Similar Readings


2. Divide or Multiply with a Factor to Convert Lbs to Kg in Excel

To convert lbs to kg there are some basic conversion amounts. The formula for converting stand to-

1 pound (lb) = 0.453592 kilograms (kgs)

1 kilogram (kg) = 2.20462 pound (lbs)

In this method, I am going to divide the pound (lb) values by 2.205 to convert them into kilogram (kg) units.

Step 1:

  • Choose a cell. Here I have chosen cell (E5) to apply the formula.
  • Put the formula down-
=D5/2.205

Divide or Multiply with a Factor to Convert Lbs to Kg in Excel

  • Hit the Enter
  • Pull the “fill handle” down to fill the series.

  • Thus we will get our conversion values in all the cells in a different column.

Divide or Multiply with a Factor to Convert Lbs to Kg in Excel

You can also multiply the pound (lb) units with 0.45359237 to get your desired kilogram (kg) unit. Follow the steps-

Step 2:

  • Select a cell (E5) to write the formula.
  • Apply the following formula in the selected cell-
=D5*0.45359237

Divide or Multiply with a Factor to Convert Lbs to Kg in Excel

  • Press the Enter button to get the result.
  • Now drag down the “fill handle” to fill all the cells from the column.

  • Well, we have successfully converted out pound units to kilogram units just by multiplying with a numeric value.

Divide or Multiply with a Factor to Convert Lbs to Kg in Excel


3. Run a VBA Code to Convert Lbs to Kg in Excel

You can also convert units with VBA code. In this method, I will share with you the VBA code to convert pound units into kilogram units.

Steps:

  • Open the “Microsoft Visual Basic for Applications” by pressing Alt+F11.

Utilize VBA Code to Convert Lbs to Kg in Excel

  • Click the “Module” from the “Insert” section.

  • Apply the following code to the module-
Sub LbstokgConverter()
Dim Lbstokg As Long
Lbstokg = InputBox("How much weight in pounds(lbs)?")
MsgBox "Weight is=" & Lbstokg * 0.45359237 & "kg."
End Sub
  • Press “Run”.

Utilize VBA Code to Convert Lbs to Kg in Excel

  • An “Inputbox” will appear asking for the pound (lb) value.
  • Put a data of your wish. Here I have put 100.
  • Click OK.

Utilize VBA Code to Convert Lbs to Kg in Excel

  • As you can see the “Input” box will show the converted value in a new “Msgbox”. Thus you can get your precious result.


Things to Remember

  • You might find some changes in the converted value with a little fraction. Don’t worry. It’s just a little bit of ups and downs because of the decimal values.

Conclusion

In this article, I have tried to cover all the simple methods to convert lbs to kg in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo