Convert Cubic Feet to Cubic Meters in Excel: 2 Easy Methods

Method 1 – Use CONVERT Function to Convert Cubic Feet to Cubic Meters in Excel

Steps:

  • Select a cell to apply the formula. We selected cell (D5).
  • Put the formula in the selected cell-
=CONVERT(C5,"ft^3","m^3")

Where,

  • The CONVERT function converts units from one measurement to another.

Convert Cubic Feet to Cubic Meters

  • Hit Enter on your keyboard.
  • Drag down the “fill handle” to get the result in all cells.

Convert Cubic Feet to Cubic Meters

  • Get all the values converted to cubic meter values in the result column.


2. Multiply with a Factor to Convert Cubic Feet to Cubic Meters in Excel

Sometimes using functions becomes difficult for beginners in Excel. We shared an easy technique for converting cubic feet to cubic meters in Excel. You just have to multiply your data by 0.0283168466 value to get the cubic meter result.

Steps:

  • Choose a cell (D5) to apply the multiply formula.
  • Apply the below formula-
=F$5*C5

Convert Cubic Feet to Cubic Meters

  • Press Enter to get the desired output.
  • Drag the “fill handle” down.

Convert Cubic Feet to Cubic Meters

  • Convert our cubic feet values to cubic meter values in Excel.


Things to Remember

  • Don’t forget to use the absolute reference in the formula cell. The single factor is multiplied by every cubic foot value.
  • While applying the formula you can add or subtract absolute reference($) with the F4 button from the keyboard.

Download Practice Workbook


Related Articles


<< Go Back to Excel CONVERT Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo