using the 'Convert' function
 

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

using the 'Convert' function
 

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



"M-A H" wrote:

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

using the 'Convert' function
 

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

--
Biff
Microsoft Excel MVP


"M-A H" wrote in message
...
Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on
what the formula should be..?
TY

using the 'Convert' function
 

CONVERT function will not do this.

1 CBM = 35.31467 FT3

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

=cbm * 36.31457


Gord Dibben MS Excel MVP


On Tue, 24 Nov 2009 10:08:04 -0800, M-A H
wrote:

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

using the 'Convert' function
 

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


Gord

On Tue, 24 Nov 2009 10:14:07 -0800, Teethless mama
wrote:

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



"M-A H" wrote:

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

using the 'Convert' function
 

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

"M-A H" wrote in message
...
Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on
what the formula should be..?
TY

using the 'Convert' function
 

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

= = = = =
Dana DeLouis

On 11/24/09 1:08 PM, M-A H wrote:
Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on
what the formula should be..?
TY

=A1*CONVERT(1,"m","ft")^3= = = = =Dana DeLouisOn 11/24/09 1:08 PM,
 

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.

On Tuesday, November 24, 2009 1:08 PM M-A H wrote:

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:


On Tuesday, November 24, 2009 1:20 PM T. Valko wrote:

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

So, I guess you would 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

--
Biff
Microsoft Excel MVP


On Tuesday, November 24, 2009 1:21 PM Gord Dibben wrote:

CONVERT function will not do this.

1 CBM = 35.31467 FT3

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

=cbm * 36.31457


Gord Dibben MS Excel MVP


wrote:


On Tuesday, November 24, 2009 1:43 PM Gord Dibben wrote:

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


Gord


On Tuesday, November 24, 2009 1:47 PM David Biddulph wrote:

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


On Tuesday, November 24, 2009 2:46 PM Dana DeLouis wrote:

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

= = = = =
Dana DeLouis

On 11/24/09 1:08 PM, M-A H wrote:


Submitted via EggHeadCafe
SharePoint 2010 Using External List
http://www.eggheadcafe.com/tutorials...rnal-list.aspx