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

FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga

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