Answers.com > Wiki Answers > Categories > Jobs & Education > Education > School Subjects > Math and Arithmetic > How to add cm and inches in excel?

How to add cm and inches in excel?

Answer:

You have to convert to a single unit - convert everything to cm., convert everything to inches, or convert to some other unit like meters.

One inch is equal to 2.54 cm.

Let's assume that in Excel, A1 contains a measurement in cm., A2 contains a measurement in inches, and you want to convert everything to cm.; the formula would be: =A1*2.54 + A2.

To convert cm. to inches, instead of multiplying by 2.54 you have to divide by 2.54.

First answer by Hilmarz. Last edit by Hilmarz. Contributor trust: 802 [recommend contributor ]. Question popularity: 6 [recommend question].

[report abuse]

Can you answer these Math and Arithmetic questions?

	How many cups in 1 pint of blueberries?	Answer it!
	How did an oblong number get it's name?	Answer it!
	How many cubic feet is equal to one brass?	Answer it!
	What household items can be measured in metric length?	Answer it!
	What is a derivative for appear?	Answer it!

Relevant answers:

How do you convert inches to cm and cm to inches?
cm x 0.39= in in x 2.54= cm Algebraic Steps / Dimensional Analysis ____ in*2.54 cm1 in=? cm____ cm*1 in 2.54 cm=? in
Inches to cm?
1 inch = 2.54 cm To convert from inches to cm, multiply the number of inches by 2.54.
Inch to cm?
1 inch -> 2.54 cm
Cm into inches?
2.54 cm per inch
How cm in an inch?
1 inch is 2.54 centimeters. 1 centimeter is 0.3937007874 inches.