using the 'Convert' function

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

=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

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

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

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

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

=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

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