Excel Tutorial

Excel Tutorial Shortcut Keys in Excel Formatting in Excel Notes in Excel Formats in Excel Cells and Ranges in Excel Excel Function and Formulas Conditional Formatting in Excel Data Validation in Excel Charts in Excel Excel Ribbon Toolbar Basics of Excel Spell Check in Excel Data Analysis in Excel AutoFill in Excel Goal Seek in Excel Solver in Excel Pivots Table in Excel Go-To Special function in Excel Blank cells in Excel Count Cells with Text in Excel Date and Time in Excel-VBA Dependent Drop-down List in Excel Operators in Excel Dependent Combo box in Excel VBA Error Bar in Microsoft Excel Excel Axes Excel File using Password Excel Unique Values Frequency Distribution in Excel Gauge Chart in Excel Histogram in Excel Sum Every Nth Row in Microsoft Excel SumIF Formula in Microsoft Excel Multiplication in Excel Unique Values in Excel Trendline in Excel Excel Themes Copying formula in Excel Check Marks in Excel Calculating the Last Day of the Month in Excel Calculating Age in Excel Insert Row in Excel

Functions

Excel MAX() Function Excel INT() Function Excel MOD() Function Excel ROUND() Function Excel ROUNDUP() Function Excel AVERAGE() Function Excel COUNT() Function Excel COUNTA() Function Excel COUNTBLANK() Function Excel MIN() Function Excel EDATE() Function Excel EOMONTH() Function Excel HOUR() Function Excel MINUTE() Function Excel SECOND() Function Excel TIME() Function Excel WORKDAY() Function Excel WORKDAY.INTL() Function Excel DAYS() Function Excel WEEKNUM() Function Excel WEEKDAY() Function Excel SMALL() Function Excel LARGE() Function Excel LEFT() Function Excel RIGHT() Function Excel MID() Function Excel FIND() Function Excel SEARCH() Function Excel EXACT() Function Excel SUBSTITUTE() Function Excel TEXT() Function Excel VALUE() Function Excel AND() Function Excel OR() Function Excel IFERROR() Function Excel IF() Function Excel Nested IF’s Function Excel IFNA() Function Excel COUNTIFS() Function Excel VLOOKUP() Function Excel HLOOKUP() Function Excel INDEX() Function Excel MATCH() Function Excel OFFSET () Function Averageif Function in Excel

How To

How to import Microsoft Access data into the Microsoft Excel How to use TODAY function in Excel How to Alphabetize in Excel How to remove duplicate values from excel How to lock cells in Excel How to create drop down in excel How to Delete Row in Microsoft Excel How to Highlight Duplicates Words in the Microsoft Excel How to print titles in Excel How to make use of the Wildcard in Excel How to Make Use of the F-Test in Excel How to make use of the Excel Autofit in Excel How to generate random numbers in Excel How to apply Advanced Filter in Excel How to use Index and Match in Excel

Misc

Absolute Value in Excel Adding Column in Excel Converting Units in Excel Count Characters in Excel Custom Sort Order in Excel Decimals in Excel Division in Excel Locate Maximum Values in Excel Nearest Multiple in Excel Paste Options in Excel Quarter Dates in Excel Row Difference in Excel Separate Strings in Excel Reverse List in Excel Array Formula in Excel What if Analysis Data Table in Excel Excel Shortcut Keys What is a spreadsheet in Excel?

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

Converting the units in Excel

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

Converting the units in Excel

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.

Converting the units in Excel

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.

Converting the units in Excel

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.

Converting the units in Excel

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.

Converting the units in Excel

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.