Summary

To convert metric measurements for allowed carry-on baggage size to inches, or vice versa, you can use the CONVERT function. In the example shown, the formula in F5, copied down and across, is:

=CONVERT(C5,"in","cm")

Generic formula

=CONVERT(A1,"in","cm")

Explanation 

The CONVERT function requires three arguments: number, from_unit, and to_unit. As long as the units specified are in the same category (weight, distance, temperature, etc.) , CONVERT will automatically perform a conversion and return a numeric result in the specified "to unit".

In the example shown, the top table is set up to convert from inches to centimeters, and the bottom table is set up to convert from centimeters to inches. The formulas in F5 and F9, which are copied across and down, are as follows:

=CONVERT(C5,"in","cm") // F5
=CONVERT(C9,"cm","in") // F9

Related formulas

Excel formula: Convert pounds to kilograms

Convert pounds to kilograms

This formula relies on the CONVERT function , which can convert a number in one measurement system to another. To perform the conversion, CONVERT relies on "from" and "to" units entered as text. As long as the units specify valid options, CONVERT will automatically perform a conversion and return a...
Excel formula: Convert inches to feet and inches

Convert inches to feet and inches

In this example, the goal is to create a formula that converts a numeric value in inches to a format that displays inches and feet, as seen in the table below: Input Output 9 0' 9" 12 1' 0" 30 2' 6" 75 6' 3" The math for this problem is fairly simple, but the problem is more complex because we need...
Excel formula: Celsius to Fahrenheit conversion

Celsius to Fahrenheit conversion

In this example, the goal is to convert the Celsius temperatures shown in column B to Fahrenheit temperatures in column C. The solution shown in the worksheet above relies on the CONVERT function, which can convert a number in one measurement system to another. CONVERT is fully automatic and based...
Excel formula: Split dimensions into three parts

Split dimensions into three parts

In this example, the goal is to split the text strings in column B, which contain three dimensions in the form "L x W x H", into 3 separate dimensions. One problem with dimensions entered as text is that they can't be used for any kind of calculation. So, in addition, we want our final dimensions...
Excel formula: Split text string at specific character

Split text string at specific character

In this example, the goal is to split a text string at the underscore("_") character with a formula. Notice the location of the underscore is different in each row. This means the formula needs to locate the position of the underscore character first before any text is extracted. There are two...

Related functions

Excel CONVERT function

CONVERT Function

The Excel CONVERT function converts a number in one measurement system to another. For example, you can use CONVERT to convert feet into meters, pounds into kilograms, Fahrenheit to Celsius, gallons into liters, and for many other unit conversions.

Related videos

How to create a complex formula step by step

When you look at a complex formula in Excel you may be completely baffled at first glance, but all complex formulas are just small steps added together. Let me show you an example. Here we have a list of names. We want to pull out the first name from the full name. There's an Excel function called...
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Formulas

Functions

Videos