CODEWITHSUNDEEP
excelexcel-formula
Dustaboy3
Dustaboy3

Reputation: 108

Computing with length units in Excel

I need to calculate the volume of a room and my measurements are given in meters.

ex.
3,15m
4,5m
17,6m

I need to multiply them and instead of a result, Excel returns an error. I have been searching on the internet and haven't found a solution.

Upvotes: 0

Views: 76

Answers (1)

BigBen
BigBen

Reputation: 50007

One option using SUBSTITUTE to replace the m, -- to convert the result to a number, and PRODUCT to multiply:

=PRODUCT(--SUBSTITUTE(C1:C3,"m",""))

enter image description here

This is an array formula, so depending on your version of Excel you may need to confirm the formula with Ctrl+Shift+Enter.

Though as already suggested, removing the m and giving your original cells a custom format of 0.00"m" is another option. Then straight multiplication will work.

Upvotes: 3

Related Questions