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

CoachCoach
Success isn't just about winning—it's about vision, patience, and playing the long game.
Chat with Coach
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga
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