Converting Units in Excel
The numeric values present in Excel consist of various types such as constant, integer, decimal etc. For calculation purposes, the values present in the data need to be converted to other units. Manual conversion takes time and sometimes leads to errors. Excel enables the default functions or formulas with operators to convert the data. This tutorial explains how the data is converted from kilogram to pounds (ibs) and pounds (ibs) to kilograms.
1 pound (ib) = 0.453591 kilograms (kg). To convert the data form pounds to kilogram, divide the cell value by 2.20462
1 kilogram (kg) = 2.20462 pounds (ib). To convert the data from kilograms to pounds, multiply the data by 2.20462.
Excel Convert Function
Excel provides a default function called CONVERT, which is used to convert from one measurement to other measurements. This function helps to convert from various measurements, including length, distance, temperature, area, kilogram, pounds and multiple metrics inside the convert function.
The formula consists of following,
Number- the data or value entered by the user for conversion from one unit to other unit.
from_unit – from unit conversion
to_unit- to unit conversion
To convert the data, the data values and unit types are entered in the formula. Value is entered in the format of number or cell reference, units as a string in the format.
1. How to convert the data from kilogram (kg) to pounds (ibs)?
The steps to be followed for conversion are as follows,
Step 1: Enter the data in the spreadsheet as A1
Step 2: Select the cell where want to display the result namely A2.
Step 3: Enter the formula as =CELL VALUE*2.20462. Here the cell value is A1, hence the formula is A1*2.20462
From the above worksheet, the value in the cell A1 is converted from kilogram to pounds using the formula
2. How to convert the data from pounds (ibs) to kilogram (kg)?
The steps to be followed for conversion are as follows,
Step 1: Enter the data in the spreadsheet as A1
Step 2: Select the cell where you want to display the result namely A2.
Step 3: Enter the formula as =CELL VALUE/2.20462. Here the cell value is A1, hence the formula is A1/2.20462
From the above worksheet, the data is converted from pounds (Ibs) to kilogram (kg) using the formula.
3. How to convert the data from Kilogram to Ibs using formula?
The steps to be followed for conversion are,
Step 1: Enter the data in the spreadsheet. Here the data are entered in the cell range A1.
Step 2: Select the cell where you want to display the result namely B1.
Step 3: Here the ‘CONVERT” function is used to convert the data or cell value from kg to pounds. Enter the formula in the cell B1 as =CONVERT (CELL VALUE, “kg”,”lbm”). Here the cell value is A1. The convert function has three arguments (number, from unit and to unit). lbm stands for pound mass.
From the above worksheet, the value in the cell A1 is converted from kg to pounds (lbm).
4. How to convert the data from Ibs to kilogram using formula?
The steps to be followed for conversion are,
Step 1: Enter the data in the spreadsheet. Here the data are entered in the cell range A1.
Step 2: Select the cell where you want to display the result namely B1.
Step 3: Here the ‘CONVERT” function is used to convert the data or cell value from pounds to kg. Enter the formula in the cell B1 as =CONVERT (CELL VALUE, “lbm”,”kg”). Here cell value is A1.
From the above worksheet, the value in cell A1 is converted from pounds (lbs) to kilogram (kg) using the CONVERT function.
5. How to convert the range of data from kg to pounds using the formula?
If excel contains range of data, the steps to be followed to convert from kg to pounds are,
Step 1: Enter the data in the spreadsheet. Here the data is entered in the range A1:A5.
Step 2: Select a new cell to display the result. Here the cell B1 is selected
Step 3: Enter the formula in the cell B1 as, =CONVERT (CELL VALUE,”kg”,”lbm”). The result will be displayed in the cell.
Step 4: To display the result in the remaining cell, drag the formula towards the cell A5. The cell value will vary according to the individual cell name.
From the above worksheet, the values are converted from kilograms (kg) to pounds (lbm) and result will be displayed in the cell range A1:A5.
6. How to convert the range of data from pounds (lbm) to kg using the formula?
If excel contains range of data, the steps to be followed to convert from pounds (lbm) to kg are,
Step 1: Enter the data in the spreadsheet. Here the data is entered in the range A1:A5
Step 2: Select a new cell to display the result. Here the cell B1 is selected
Step 3: Enter the formula in the cell B1 as, =CONVERT (CELL VALUE,”lbm”,”kg”). The result will be displayed in the cell.
Step 4: To display the result in the remaining cell, drag the formula towards the cell A5. The cell value will vary according to the individual cell name.
From the above worksheet, the values are converted from pounds (lbm) to kilograms (kg) and result will be displayed in the cell range A1:A5.
Summary
From the tutorial, the various functions and formulas to convert one measurement to other measurement is briefly explained.