convert yd^3 to ft^3, also selecting the columns instead of ans one by one?

**cstpa** · 09-27-2014, 09:59 PM

Hi still very new to Excel,

How would I make a formula for converting these units when they have a ^3 attached?

CONVERT(number, from_unit, to_unit)

=CONVERT(C40, yd, ft)

but I don't know how input ^3

trying to convert
\1

the answer I should be getting..
\1

A simple way to answer all of these at once?
\1

**FDibbins** · 09-27-2014, 10:26 PM

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

**MrShorty** · 09-27-2014, 10:45 PM

The convert function may not be the easiest in this case. It might be easier to simply apply the equality 1 yd^3=9 ft^3 -- Simply multiply the number of yd^3 by 9 to get ft^3 or divide ft^3 by 9 to get yd^3.

If you want to use the CONVERT() function, you will need to take the cubic root, then convert, then cube the result.

**Crooza** · 09-27-2014, 10:56 PM

Mrshorty. I'm from a non imperial (metric) country so I might be off target here but I though there were 3 ft in a yard. Therefore cubic feet to cubic yards will be 3 cubed (3^3) which is 27 not 9. Am I missing something?