# Carry-on baggage Inches to centimeters

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

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

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:

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