Ninja Excel BlogExcel formulas and functionsKilos to Pounds: Convert units like an expert

Kilos to Pounds: Convert units like an expert

Balance Statue

Knowing how to convert units is a very useful tool, since it is something that is used on a daily basis. In this article you will quickly learn how to convert units, specifically from Kilos to Pounds and from Pounds to Kilos, through three methods.

Key information:

We can convert units through a basic formula, use the CONVERT function or through the Ninja unit converter. In this article we will convert from Kilos to Pounds and vice versa.

How to convert from Kilos to Pounds

To convert units, such as converting from Kilos to Pounds and from Pounds to Kilos, it can be done in three ways: through a simple formula, using the CONVERT function or using the Ninja Unit Converter. Let's look at each method. 

Way 1: Convert units with formula

This way consists of using a mathematical equation to transform units of measurement, that is, we will transform units through a simple equation. We will see how to convert from Pounds to Kilos and then, from Kilos to Pounds.

From Pounds to Kilos

First, we want to know how many Kilos are equivalent to 5 Pounds of potatoes. For this, we need to know that:

1 Kilo is equivalent to 2.20462 Pounds. 

How to convert from Pounds to Kilos in Excel through a simple formula. The image shows the value we are looking for and the information we have.

To find the number of Kilos, we must divide the number of Pounds by 2.20462, since in this way we convert Pounds into Kilos. 

Therefore, in this case, we must multiply (1×5) and divide by 2.20462.

How to convert from pounds to kilos in Excel. Shows the formula that is used by checking the cells used

That is, the equation used is:

Formula used to convert pounds to kilos in Excel.

The result we will obtain will be:

How to convert from Pounds to Kilos in Excel through a simple formula. The image shows the value we found.

Therefore, 5 Pounds of potatoes are equivalent to approximately 2.27 Kilos of potatoes.

From Kilos to Pounds

Now, we want to know how many pounds are equivalent to 2 kilos of potatoes. For this, we need to know that:

1 Pound is equivalent to 0.453592 Kilos. 

How to convert from kilos to pounds in Excel through a simple formula. The image shows the value we are looking for and the information we have.

Again, we use the rule of three, but in this case, we must multiply (1×3) and divide it by 0.453592.

How to convert from kilos to pounds in Excel. Shows the formula that is used by checking the cells used

That is, the equation used is:

Formula used to convert from kilos to pounds in Excel.

The result we will obtain will be:

How to convert from Kilos to Pounds in Excel through a simple formula. The image shows the value we found.

Therefore, 2 Kilos of potatoes are equivalent to approximately 4.41 Pounds of potatoes.

Way 2: Convert units with the CONVERT function

This way consists of using Excel's CONVERT function. This function allows you to transform numerical values from one unit of measurement to another, that is, it allows you to change the unit of measurement quickly and easily, such as, for example, from Kilos to Pounds.

First of all, let's get to know this function.

  • Purpose: The CONVERT function allows us to transform from one unit of measurement to another.
  • Syntax:​​​​​​ =CONVERT(number; from_unit; to_unit)
  • Arguments:
    • number: Number to be converted.
    • from_unit: Unit that corresponds to the number.    
    • a_unit: Unit to which we want to convert.

Tip Ninja: The arguments from_unit and to_unit, being the units of measurement, must be enclosed in quotes, since they correspond to text.

As we are looking to convert Kilo and Pound, we must know that the abbreviation for the unit of measurement Kilo is “kg” and for Pound is “lbm”. We will see how to convert from Pounds to Kilos and then, from Kilos to Pounds.

From Pounds to Kilos

First, we want to know how many Kilos are equivalent to 20 Pounds of tomatoes. 

How to convert from Pounds to Kilos in Excel through the CONVERT function. The image shows the value we are looking for and the information we have.

Therefore, we want to go from lbm to kg, with the number argument being the cell that contains the number “20”.

How to convert from pounds to kilos in Excel with the CONVERT function. Shows the formula that is used by checking the cells used

The elements of the function are:

  • number: E2
  • from_unit: “lbm”
  • a_unit: “kg”

That is, the CONVERT function is:

Formula used to convert from pounds to kilos in Excel with the CONVERT function.

The result we will obtain will be:

How to convert from Pounds to Kilos in Excel through the CONVERT function. The image shows the value we found.

That is, 20 Pounds are equivalent to approximately 9.1 Kilos of tomatoes.

From Kilos to Pounds

Now, we want to know how many Pounds are equivalent to 10 Kilos of tomatoes. 

How to convert from kilos to pounds in Excel through Excel's CONVERT function. The image shows the value we are looking for and the information we have.

Therefore, we want to go from kg to lbm, with the number argument being the cell that contains the number “10”.

How to convert from kilos to pounds in Excel with the CONVERT function. Shows the formula that is used by checking the cells used

The elements of the function are:

  • number: B2
  • from_unit: “kg”
  • a_unit: “lbm”

That is, the CONVERT function is:

Formula used to convert from kilos to pounds in Excel with the CONVERT function.

The result we will obtain will be:

How to convert from Kilos to Pounds in Excel through the CONVERT function. The image shows the value we found.

That is, 10 Kilos are equivalent to approximately 22 Pounds of tomatoes.

Way 3: Convert units with Ninja Converter

 Download here Ninja's unit converter. 

This way consists of using the Ninja Unit Converter. Download it for free to convert all types of units quickly and dynamically.  

Since we are converting Kilos and Pounds, we must select the “Mass” category from the list of measurement unit types. 

How to convert Pounds to Kilos and Kilos to Pounds in Excel via a Ninja unit converter. The image shows the categories of units of average such as area, length, mass, temperature and volume

When selecting “Mass” the categories in cells B8 and D8 contain only mass unit types. 

Tip Ninja: If you want to create your own unit converter, we recommend you visit the blog VBA, where they will teach you how to program macros in Excel.   

We will see how to convert from Pounds to Kilos and then, from Kilos to Pounds through the Ninja converter.

From Pounds to Kilos

First, we want to know how many Kilos are equivalent to 7 Pounds of apples. 

For this, we must change the unit categories of cells B8 and D8 of the converter. As we are looking to transform Pounds to Kilos, we select “Pound” in the list in cell B8 and “Kilogram” in the list in cell D8.

How to convert from Pounds to Kilos in Excel through a Ninja unit converter. The image shows the types of measurement units that we must choose, in the example we use Pound and Kilogram. such as area, length, mass, temperature and volume

Finally, since we are looking to convert 7 Pounds of apples to Kilos, we must write “7” in cell B7. 

How to convert from Pounds to Kilos in Excel through a Ninja unit converter. The image shows the result obtained after converting 7 pounds to kilos.

That is, 7 Pounds are equivalent to approximately 3.18 Kilos of apples.

From Kilos to Pounds

Now, we want to know how many Pounds are equivalent to 15 Kilos of apples. 

To do this, we must perform the same steps, but since we want to convert from Kilos to Pounds, we must change the mass units of cells B8 and D8. 

Therefore, we obtain the following result:

How to convert from Kilos to Pounds in Excel through a Ninja unit converter. The image shows the result obtained after converting 15 Kilos to pounds.

That is, 15 Kilos are equivalent to approximately 33.1 Pounds of apples.

Common mistakes

* #N/D

This error occurs when the arguments of the CONVERT function have some error. We recommend you review:

  1. Check that some type of unit was determined in the from_unit and to_unit arguments.
  2. Check that you are converting to units from the same category, for example, mass or length.
Common errors of converting pounds to kilos or kilos to pounds, this error happens in the CONVERT function of Excel. Error #N/D

Ninja Tip:  You can use the IF.ERROR or IF.ND functions to handle errors.

Fernanda is a strategy and development analyst, she trained as a commercial engineer at the Universidad Católica de Chile and also as a mathematics professor at the Universidad de los Andes.

white ninja excel logo

The leading Excel training platform for companies.

Company

Copyright © 2024 Ninja Excel.

English