Tweet

# Excel Tips Tutorial: How to Convert Values From One Measurement System to Another

Most of us face a situation where data is given in one measurement unit but we need to see that in a different one. For example, the distance from your home to school is given in miles in map, but you feel comfortable measuring distances in Kilometer. What to do, you need a converter from Mile to Kilometer. Or, your laptop’s weight is given in Kilogram in product sheet but you understand Pound better. The good news for you, a straight converter function is there in Excel. Let’s try out.

Step 1:
Say, you need to convert 2 Kg mass to Pound.
Just open an Excel sheet, select a cell, write the convert() function like in below example. Convert() function needs three input values. 1) 2 (2 Kg mass) 2) “kg” (your current measurement unit) 3) “lbm” (your desired measurement unit). Units are to be put within parentheses. Now press enter. You see 4.409 pounds are calculated by the equation immediately.

What further:
Using the same function, you can convert any value from one unit to another in the category of Mass & weight, Distance, Time, Pressure, Force and Temperature etc.