answersLogoWhite

0

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

Still curious? Ask our experts.

Chat with our AI personalities

TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga
RossRoss
Every question is just a happy little opportunity.
Chat with Ross
SteveSteve
Knowledge is a journey, you know? We'll get there.
Chat with Steve

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