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.
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.