# 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**.