Exceljet

Quick, clean, and to the point

Carry-on baggage Inches to centimeters

Excel formula: Carry-on baggage Inches to centimeters
Generic formula 
=CONVERT(A1,"in","cm")
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")
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
Author 
Dave Bruns
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...
Excel formula: Convert inches to feet and inches
Convert inches to feet and inches
This formula converts a numeric value in inches to text representing the same measurement in inches and feet. To get the value for feet, the INT function is used like this: = INT ( B5 / 12 ) & "' " Inside INT, the value in B5 is...
Excel formula: Celsius to Fahrenheit conversion
Celsius to Fahrenheit conversion
This formula relies on the CONVERT function , which can convert a number in one measurement system to another. CONVERT is fully automatic and based on "from" and "to" unit strings. As long as the units valid options in the same category (weight,...
Excel formula: Split dimensions into three parts
Split dimensions into three parts
The 1st dimension To get the first dimension, we are using this formula in C4: = LEFT ( B4 , FIND ( "x" , B4 ) - 1 ) This works by extracting text starting at the LEFT. The number of characters is calculated by locating the first "x" in...
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...
Related functions 
Excel CONVERT function
Excel 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...

Related videos 
How to create a complex formula step by step
Some Excel formulas are complex, but all complex formulas are built from simple steps. In this video we build a more complex formula step-by-step.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formulas | 101 Functions

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.