# EXCEL FUNCTIONS-CONVERT

## INTRODUCTION

In any of the application or reports, we are preparing, a situation might arise when we need to change UNIT IN ONE MEASUREMENT SYSTEM TO ANOTHER MEASUREMENT SYSTEM. e.g. gram into ounce, centimeter into feet etc.

So we got a function to do all this for us known as CONVERT FUNCTION.

CONVERT FUNCTION is found under the ENGINEERING FORMULAS section under FORMULAS TAB.

This function gives us a wide variety of options.

In this article we’ll see the different styles of usage of CONVERT FUNCTION and find out the different options available with this function.

After that we’ll look at a fully described example to grasp the functionality of this function properly.

## PURPOSE OF CONVERT FUNCTION IN EXCEL

CONVERT FUNCTION converts the values in one measurement system to other.

For example, we have different kinds of measurement system such as MKS , fps etc. MKS is meter, kilogram , second whereas fps is foot, pound , second.

So many times we come across a situation when we need to convert these values from one system to another.

The main reason for this is the presence of different popular usages of these measurement among different societies.

e.g. In many countries, if you ask somebody’s weight, he or she’ll answer in pounds, whereas in some countries, they’ll answer in KG.

We can do these conversion manually too, but we don’t need to do it when we have such a good function with us to make our task easier.

## PREREQUISITES TO LEARN CONVERT FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

•  Basic understanding of how to use a formula or function.
•  Basic understanding of rows and columns in Excel.
• A bit understanding of the measurement systems will help in this, because at least we need to know about the conversion, from this to that. But even if you don’t know, you can always refer here.
•  Of course, Excel software.

What Excel does? How to use formula in Excel?

## SYNTAX: CONVERT FUNCTION

The Syntax or the way a function is phrased for the CONVERT FUNCTION is

=CONVERT(NUMBER, OLD_UNIT, NEW_UNIT)

NUMBER is the number which needs the unit conversion

OLD_UNIT the present unit which is to be converted [ SYMBOLS ARE TABULATED BELOW ]

NEW_UNIT the new unit which appears after conversion [SYMBOLS ARE TABULATED BELOW ]

## CONVERT FUNCTION-REFERENCE TABLE

FOLLOWING TABLE SHOWS THE LIST OF OLD UNITS AND NEW UNIT CONVERSION AND THEIR SYMBOLS TO BE USED.

Weight and Mass

Distance

Time

Pressure

Force

Energy

Power

Magnetism

Temperature

Volume

Area

Information

Speed

The following abbreviated unit prefixes can be prepended to any metric from_unit or to_unit.

NOTE: The table referred taken with thanks from support.office.com

## EXAMPLE:CONVERT FUNCTION IN EXCEL

### DATA SAMPLE

Let us take a few examples to try our newly learnt function.Here is the data which will be converted to the new unit system using the CONVERT FUNCTION.We’ll try a few main conversions although the system is same for all . The comprehensive list is given above in the table.