How to Convert Kg to Lbs or Vice Versa in Excel: 3 Simple Ways
Prologue
In this article, you’ll learn about 3 ways to convert kg to lbs or vice versa in Excel. This covers the usage of two arithmetic formulas, the CONVERT function, and VBA.
There are a lot of measurement systems in the world. Not every country follows the same measurement process. So, you’ll need to learn about unit conversion. Especially if you work in a trading or import oriented business.
When used properly, Excel can be the best tool for converting between units. Reading this article will teach you not only the basics, but also how to apply what you have learned to other unit conversions.
How to Convert Kg to Lbs in Excel
This section will cover 3 ways to convert kilograms to pounds in Excel. Firstly, we will look at arithmetic formulas. The CONVERT function is the second technique. Lastly, VBA will then be used to achieve this.
Using Arithmetic Operations to Convert Kg to Lbs in Excel
We can convert pounds to kilograms by dividing and multiplying. Let’s go through how to do this by multiplying first.
Using Multiplication
We can multiply the kg values by 2.20462 to transform them into lbs.
- Frsityl, insert the following formula in cell C3 and fill it in the rest of the cells.
=B3*2.20462
- Thus, you’ll convert kg to pounds.
Using Division
We can simply divide the kg by 0.453592 to change it into the pound value.
- To begin with, insert the formula below in cell C3 and fill it in the rest of the cells.
=ROUND(B3/0.453592,2)
Here, because of the ROUND function, the result will be rounded and show only two digits after the decimal.
Using CONVERT Function
You can use the CONVERT function to transform kilograms into pounds. Use the following formula in cell C3 and fill this up until cell C6.
=CONVERT(B3,”kg”,”lbm”)
Here, ‘lbm’ means pound mass.
Applying VBA to Convert Kg to Lbs
In this last method, we’ll employ VBA to convert kg to lbs. Before applying VBA code, you may need to know how to insert code into the VBA Module.
- Firstly, select Visual Basic from the Developer tab. Alternatively, you can press Alt+F11 to do the same.
- Secondly, Select Module from the Insert icon. It will bring up the ‘Module1’ window. You’ll place your code here.
- Thirdly, type the following code in that ‘Module1’.
Sub ConvertKgToLbs()
Set kgRange = Sheets(“kl-VBA”).Range(“B3:B6”)
For Each cell In kgRange
cell.Offset(0, 1).Value = cell.Value * 2.20462
Next cell
End Sub
Decoding VBA Code
- Firstly, give a name to the subprocedure.
Sub ConvertKgToLbs()
- Secondly, set the range of the kilogram as the input range.
Set kgRange = Sheets(“kl-VBA”).Range(“B3:B6”)
- Thirdly, create a for loop to go through each cell of the input range.
For Each cell In kgRange
- Afterward, using the Offset property, set the output to be on column C. Moreover, the output value will be multiplied by 2.20462. This multiplication will change the cell value to pound.
cell.Offset(0, 1).Value = cell.Value * 2.20462
- After that, go to the next cell.
Next cell
- Finally, end the subprocedure.
End Sub
- Then, execute this code to convert kilogram to pound.
How to Convert Lbs to Kg in Excel
This section will cover 3 ways to convert pounds to kilograms in Excel. First, we will look at arithmetic formulas. The CONVERT function is the second technique. VBA will then be used to accomplish this.
Applying Arithmetic Operations to Convert Lbs to Kg in Excel
You can convert pounds to kilograms by dividing and multiplying. Let’s go through how to do this by dividing first.
Applying Division Formula
If you divide pounds by 2.20462, you’ll get the corresponding kilogram value. As it is being divided by a fraction, there can be too many decimals. So, using the ROUND function will ensure the output is better visible.
Fill in cell C3 with this formula until it reaches cell C6.
=ROUND(B3/2.20462,2)
Here, the 2 in the formula instructs it to round up to two decimal places.
Applying Multiplication Formula
You can multiply the pound values by 0.453592 to change them into kilogram values. Insert the following formula in cell C3 and fill the formula up to cell C6.
=B3*0.453592
Using CONVERT Function
In this second method, we’ll show you how to use the CONVERT function to transform pounds into kilograms. Type the following formula in cell C3 and fill the formula up to cell C6.
=CONVERT(B3,”lbm”,”kg”)
Applying VBA to Convert Lbs to Kg
You can also use the VBA Macro to convert pounds to kilograms. Firstly, press Alt+F11 to bring up the VBA window. Then, type the following code in the Module window.
Sub ConvertLbsToKg()
Set kgRange = Sheets(“lk-VBA”).Range(“B3:B6”)
For Each cell In kgRange
cell.Offset(0, 1).Value = cell.Value / 2.20462
Next cell
End Sub
This code is similar to the previous, so we’ll skip the explanation here. Then, execute the code, and it will show the converted values in cell range C3:C6.
How to Convert Kg to Oz and Stones
In Britain, Australia, and Ireland, the stone measurement is still frequently used to determine the weight of an individual. Additionally, the ounce is used to measure packaged goods in the USA.
You can use the CONVERT function to change kg to oz and kg to stones in Excel. For ounces and stones, you need to type ‘ozm’ and ‘stone’ respectively. The formulas used in cells C3 and D5 are given below.
=CONVERT(B3,”kg”,”ozm”)
=CONVERT(B5,”kg”,”stone”)
Answers to Commonly Asked Questions
Question 1: How do I convert grams to pounds in Excel?
ExcelFlash: To convert grams to pounds in Excel, you can use the CONVERT function. Gram is denoted by ‘g’ in that function. The formula for cell C3 is:
=CONVERT(B3,”g”,”lbm”)
Question 2: What does lb mean? Why is it called lbs?
ExcelFlash: The abbreviation lb means pound. The plural of pound is pounds. Here, lb comes from the Latin word ‘libra’, which means scale or weight.
Question 3: What is the weight formula in Excel?
ExcelFlash: When you multiply the mass of an object (m) with the gravitational acceleration (g), you’ll get the weight of that object. The formula is as follows:
W=m*g
Here, g varies depending on the location of the object. Generally, the value of g is considered to be 9.81 m/s^2.
Question 4: What is the total and net weight?
ExcelFlash: Total weight is the weight of everything a product comes with, for example, the packaging material or container. On the other hand, net weight is the weight of the product itself. Now, let’s consider a bar of soap. It has packaging. The weight of that product will be the total weight. Then, if you remove the packaging and measure the weight of the product, it will be the net weight of that bar of soap.
Things to Remember
- You have to use ‘lbm’ instead of ‘lbs’ inside the CONVERT function.
- To improve clarity, use the ROUND function to round values up to specific decimals for friction values.
- You can also create a custom function to convert kilograms to pounds in Excel using VBA.
Epilogue
You’ve seen 3 ways to convert kg to lbs in Excel. If you have any feedback for us, feel free to comment below. You can also follow ExcelFlash on Twitter and YouTube.