How to convert pounds to kilograms in Excel

In this article, we will learn How to convert pounds to kilograms in Excel.

Scenario:

Conversion of one measurement field to another measurement field can be done in excel. Conversion like Length measurements, weight measurement, volume or area measurements are some different types of conversions. As we know,

1 pound =0.4536 Kilograms 

Let's understand more about conversions.

How to solve the problem?

Here we will be using the CONVERT function of Excel. Follow the link to learn more about conversions. Here we need to convert the weight measurement in pounds to weight measurement in Kilograms. Below is the generic formula to make you understand better.

Generic formula:

=CONVERT(value,"lbm","kg")

value : value to convert

"lbm" : pounds, convert from unit

"kg" : kilograms, convert to unit

 

Example :

All of these might be confusing to understand. So, let's test this formula via running it on the example shown below. For example, we have some weight measurement in pounds and need the same measurements in kilograms. Just follow the formula with correct keywords to get the result.

Use the formula

=CONVERT(C5,"lbm","kg")

Here you can see, the value is given using the cell reference and other two arguments are given in quotes. 

As you can see, 75 pounds equals 34.02 Kilograms. Now copy the formula to other cells using the shortcut Ctrl + D. 

Yeah, It's that easy in Excel. Here are all the measurements in Kilograms. Now if we need to convert Kilograms to Pounds, we will be using the same formula but arguments in different order. For, more explanation see below.

How to convert Kilograms to Pounds in Excel?

Here, we have a similar situation, as had earlier. Now we will break down the problem with a similar pattern. CONVERT function has three arguments, 1st the value, 2nd from_unit and 3rd is to_unit. Now we will use the below formula to calculate the Kilograms from Pounds. For this, we will convert the same values to Pounds. So as to recheck the results obtained from the 

Use the formula:

=CONVERT(D5,"kg","lbm")

Copy the formula to the rest of the cell to check the results.

As you can see the formula works fine for both sides. You must be thinking if 1 Pound = 0.4536 kilograms, why can't we use the basic mathematical formula to calculate the result. We can use the mathematical formula also.

Use the formula:

=C3 * 0.4536


In the D column we have results using the CONVERT function and in column E we have results using the basic mathematical formula. Now we know 1 Kilogram = 2.2 pounds, the same can be done using the same formula.

Here are all the observational notes regarding using the formula.

Notes:

  1. You can use the CONVERT function to convert weight, distance, time, pressure, force, energy, power, magnetism, temperature, liquid, and volume.
  2. Use the correct conversion rate in the mathematical formula or use the CONVERT function formula.

Hope this article about How to convert pounds to kilograms in Excel is explanatory. Find more articles on conversion here. If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 

Related Articles:

How to convert Stone to lbs weight in Excel : Convert Stone to lbs measurement using CONVERT function in Excel.

How to convert Inches to decimals and feets to decimal in Excel : Convert minutes to hours and minutes time measurement with basic mathematical formulation.

How to Convert Date and Time from GMT to CST in Excel : Date and time from GMT to CST time conversion using the TIME function and other basic tools.

Popular Articles:

50 Excel Shortcut to Increase Your Productivity : Get faster at your task. These 50 shortcuts will make you work even faster on Excel.

How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets. 

How to use the COUNTIF function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.

How to Use SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube