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.
Hit enter to get the desired result.
Hope this helped.