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

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

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

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

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

Split text string at specific character

The first formula uses the FIND function to locate the underscore(_) in the text, then we subtract 1 to move back to the "character before the special character". FIND ( "_" , B5 ) - 1 In this example , FIND returns 7, so we end up with 6...

Related functions

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

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

Exceljet

Quick, clean, and to the point

Carry-on baggage Inches to centimeters

Excel Formula Training

Download 200+ Excel Shortcuts

Excel video training