One of the common things people use Excel for is conversions. Inches to centimetres. Miles to kilometres. Litres to gallons. Fahrenheit to Celsius.

The list is endless

Of course, these days, the quickest way to do this is to use Google or AI, which is fine if you’re doing a one-off conversion. But what if the result of the conversion is to be used by other formulas in your worksheet?

Take this temperature conversion sheet for example where we need to record the temperature 4 times a day for the past 3 days, and calculate the average, which will be stored elsewhere in the worksheet.

One way to do a conversion is to use a formula but that requires us to know, or at least look up, the underlying mathematical calculation. At that point most people run away screaming.

By the way, to convert Fahrenheit to Celsius, subtract 32 from the Fahrenheit value and divide the result by 1.8. And yes I did have to look that up!

In this video I show you a few examples of how to use one of Excel’s hidden gems – the CONVERT function. I’ll show you how to convert Fahrenheit to Celsius, miles to kilometres, litres to gallons and inches to centimetres.


Fahrenheit to Celsius

Miles to Kilometres

Litres to Gallons

Inches to Centimetres