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")
Explanation 

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")

How this formula works

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

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.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables