answersLogoWhite

0


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

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How to add cm and inches in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is 5 foot and 9.5 inches in cm?

This is 176.53 cm. There are 2.54 cm in 1 inch, so multiply inches by 2.54 (cm/in). But first get the measurement in inches, so 5 feet x 12 (in/ft) = 60 inches, then add 9.5 inches to get 69.5 inches. Now you can multiply by 2.54, to get 176.53 cm


Convert 5 foot 10 to cm?

First convert everything to inches. Each foot has 12 inches, so you multiply feet by 12, then add the inches. Then convert everything to cm. (1 in. = 2.54 cm.).


How tall is 5'1 and a quarter in cm?

I got 155.575 cm. 5' (feet) = 60 inches, so 5'1 = 61 inches. Add the quarter = 61.25 inches. Multiply by 2.54 cm/inch = 155.575 cm156.21cm


6 foot 9 inches in cm?

Since 1 inch = 2.54 cm and 12 inches = 1 foot... We can do this in parts. 1- Calculate the feet in inches 2- Add the remaining inches (9) to your answer from part one 3- Convert the answer from part 2 into cms We can calculate how many inches is equal to 6 feet. 6 feet x 12 inches/1 foot = 72 inches Since we know 6 feet = 72 inches, we can add on the 9 inches that we haven't calculated yet. 72 inches + 9 inches= 81 inches So, the object is 81 inches tall. Now we convert 81 inches to cm. Since 1 inch = 2.54 cm, we can simply: 81 inches x 2.54 cm/inches = 205.74cm


How do you figure out how many centimeters are in 5 feet and 5 inches?

There are 2.54 cm in 1 inch. So to convert inches to cm, multiply by 2.54.There are 12 inches in a foot, so multiply the 5 feet by 12 to get 60 inches, then add the 5 inches to get 5 ft 5 in = 65 in.Then (65 in ) x (2.54 cm/in) = 165.1 cm


How many inches equals 83 cm?

83 cm = 32.68 inches. 83 cm = 32.68 inches. 83 cm = 32.68 inches. 83 cm = 32.68 inches.


How tall is Maeva Excel?

Maeva Excel is 165 cm.


How tall is Madonna in cm?

If she is 5' 4.5" then she would be 163.83 cm. To figure this out you convert the feet to inches and add to the extra inches. 5ft*12in/ft=60in 60in+4.5in=64.5in Then to convert from inches you centimeters, you multiply by 2.54. 64.5in*2.54in/cm=183.83cm.


How tall are you in inches if you know your height in cm?

You can find your height in inches by dividing the number of centimeters (cm) by 2.54 (cm per inch). Here are some examples: 120 cm = 47.2 inches 125 cm = 49.2 inches (4 feet, 1.2 inches) 130 cm = 51.2 inches 135 cm = 53.1 inches 140 cm = 55.1 inches 145 cm = 57.1 inches 150 cm = 59.0 inches 155 cm = 61.0 inches (5 feet, 1 inch) 160 cm = 63.0 inches 165 cm = 65.0 inches 170 cm = 66.9 inches 175 cm = 68.9 inches


Convert 213 cm to inches?

One cm is about 0.3937 inches. The formula for converting cm to inches is cm x 0.3937 = inches:180.3 cm x 0.3937 = about 70.984 inches.


How much is 87 inches in centimetres?

87 inches = 220.98 cm.87 inches = 220.98 cm.87 inches = 220.98 cm.87 inches = 220.98 cm.


1.13 inches equals how many centimeters?

1.13 inches = 2.8702 cm.1.13 inches = 2.8702 cm.1.13 inches = 2.8702 cm.1.13 inches = 2.8702 cm.