using the 'Convert' function

[M-A H]

Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on
what the formula should be..?
TY

 

[Teethless mama]

=CONVERT(CONVERT(CONVERT(1,"m","ft"),"m","ft"),"m","ft")

 

[T. Valko]

According to Google, 1 cubic meter = 35.3146667 cubic feet.

So, I guess you'd simply multiply the cm by 35.3146667 and use some
rounding. To 2 decimal places?

A1 = cm = 10
B1 = 35.3146667

=A1*B1 = 353.146667

=ROUND(A1*B1,2) = 353.15

 

[Gord Dibben]

CONVERT function will not do this.

1 CBM = 35.31467 FT3

Formula................

=cbm * 36.31457


Gord Dibben MS Excel MVP

 

[Gord Dibben]

I definitely spoke too soon and without knowledge when I stated "convert
function cannot do this"


Gord

=CONVERT(CONVERT(CONVERT(1,"m","ft"),"m","ft"),"m","ft")

Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on
what the formula should be..?
TY

 

[David Biddulph]

1 foot = 0.3048 m, so the formula you need is =A1/(0.3048^3)

 

[Dana DeLouis]

=A1*CONVERT(1,"m","ft")^3

= = = = =
Dana DeLouis

 

[Bijender Singh]

Please Advise me about total CBM of below dimensions of Cargo

14? wide x 14? high x 25? ? 2 boxes ( Box Size)
25? long x 2 ?? wide x 2 ?? high ? 4 nos. ( Tube Size)

15? wide x 14? high x 41? ? 6 boxes ( Box Size)
41? long x 2 ?? wide x 2 ?? high ? 6 nos. ( Tube Size)

11? wide x 10? high x 49? long ? 8 boxes ( Box Size)
49? long x 2 ?? wide x 2 ?? high ? 10 nos. ( Tube Size)

Total wooden boxes weight = 7812 kgs.
Total tubes weight 33.9 tons
Total weight = 42 tons.

Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on
what the formula should be..?
TY

On Tuesday, November 24, 2009 1:14 PM Teethless mama wrote:
=CONVERT(CONVERT(CONVERT(1,"m","ft"),"m","ft"),"m","ft")



"M-A H" wrote: