Convert English to Metric and more with the versatile CONVERT function.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel In Depth chapter 15 - The Convert Function!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, this is one of those functions that used to be in the Analysis tool pack.
So back in Excel 2003, some people didn't even have this function, now in Excel 2010 and Excel 2007, it’s part of the core functionality.
A pretty good function if you need to convert from Metric to British units.
So, if we need to convert from inches to centimeters, =CONVERT, that's asking for three things.
It’s asking for the number that we want to convert, and then the from_unit, and the to_unit.
And so 123 In is 312 cm.
The other examples here, if we need to convert from pounds mass lbm, the kilograms, from Fahrenheit to Celsius, from tablespoons to teaspoons.
Now, you'll see that, as you enter this function, when you get out here, they have a list of all the different possible abbreviations.
I actually prefer to go to Excel help to check this out.
So usually, what I do is, I do =CONVERT, and then hit the FX button here, “Help on this function”, which will get me to the Excel help topic, which shows me all of the different things.
So distance, meters to miles, nautical miles to statute miles, Angstroms to Picas, time.
I can go from year to seconds, from Pascals to Atmospheres, Newtons to Dynes, Joules to Ergs, Horsepowers to Watts, Tesla to Gauss, centigrade to Fahrenheit, teaspoons to tablespoons, US pints to UK pints, and then of course, all the metric abbreviations work as well.
So the important thing here, you need to get the abbreviation correct including case, it is case sensitive, so be careful when you're doing that, but the CONVERT function, very cool function, it will do a lot of different conversions for you.
One question I get all the time is “Hey, can it do currency conversions?” No, it doesn't do that, but as far as measures… (unclear) Want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
Excel In Depth chapter 15 - The Convert Function!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, this is one of those functions that used to be in the Analysis tool pack.
So back in Excel 2003, some people didn't even have this function, now in Excel 2010 and Excel 2007, it’s part of the core functionality.
A pretty good function if you need to convert from Metric to British units.
So, if we need to convert from inches to centimeters, =CONVERT, that's asking for three things.
It’s asking for the number that we want to convert, and then the from_unit, and the to_unit.
And so 123 In is 312 cm.
The other examples here, if we need to convert from pounds mass lbm, the kilograms, from Fahrenheit to Celsius, from tablespoons to teaspoons.
Now, you'll see that, as you enter this function, when you get out here, they have a list of all the different possible abbreviations.
I actually prefer to go to Excel help to check this out.
So usually, what I do is, I do =CONVERT, and then hit the FX button here, “Help on this function”, which will get me to the Excel help topic, which shows me all of the different things.
So distance, meters to miles, nautical miles to statute miles, Angstroms to Picas, time.
I can go from year to seconds, from Pascals to Atmospheres, Newtons to Dynes, Joules to Ergs, Horsepowers to Watts, Tesla to Gauss, centigrade to Fahrenheit, teaspoons to tablespoons, US pints to UK pints, and then of course, all the metric abbreviations work as well.
So the important thing here, you need to get the abbreviation correct including case, it is case sensitive, so be careful when you're doing that, but the CONVERT function, very cool function, it will do a lot of different conversions for you.
One question I get all the time is “Hey, can it do currency conversions?” No, it doesn't do that, but as far as measures… (unclear) Want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
