Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using the 'Convert' function
Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on
what the formula should be..? TY |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
Convert function to value | Excel Discussion (Misc queries) | |||
Need a function to convert value in its name | Excel Worksheet Functions | |||
convert $ to £ or £ to $ function how? | Excel Worksheet Functions | |||
Convert function | Excel Worksheet Functions |