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

15y 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 42 inches plus 14 cm dashes?

To add 42 inches and 14 cm, first convert 14 cm to inches by dividing by 2.54 (since 1 inch is approximately 2.54 cm). This gives you approximately 5.51 inches. Add this to 42 inches to get a total of approximately 47.51 inches.


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 6 inches to cm?

First get the total number of inches. Five feet is equal to 60 inches and add the 6 for a total of 66 inches. Multiple 66 by 2.54 (the number of centimeters in an inch) and you get the number, 167.64 centimeters.


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


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


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 tall is Maeva Excel?

Maeva Excel is 165 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 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 do you convert 5 feet 9 inches to centimeters?

To convert 5 feet 9 inches to centimeters, first convert 5 feet to inches (5 ft = 60 inches), then add the 9 inches to get a total of 69 inches. Finally, multiply 69 inches by 2.54 to get the equivalent in centimeters, which is approximately 175.26 cm.


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.