Unit Conversion In Excel

Let’s see how to do unit conversion in excel.

We will see how we could leverage a simple convert function in excel to do unit conversion.

Convert function is very useful in eliminating any extra multiplication and division operation associated with unit conversion in excel.

Convert(number,from_unit,to_unit)

Suppose we want to convert the number in A2 from meters to feet.

You will observe a drop down when you enter the “from unit” and “to unit” argument in the formula.




Capture

Capture

Capture




Hit enter to get the desired result.

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply