How to Calculate Column Volume in Excel (with Quick Steps)

Over the years, Excel makes several types of mathematical problems simpler, among them calculating column volume in geometry. While putting numbers into a calculator can calculate the volume of a column, Excel can provide to enter multiple dimensions for the geometry and can calculate each of the volumes at a glance. In this article, you will learn to calculate column volume in Excel in 3 quick steps.


Download Practice Workbook

You can download the following practice workbook that we have used to prepare this article


Steps to Calculate Column Volume in Excel

πŸ“Œ Step 1: Set Column Dimensions

Let’s first introduce our dataset. There are 3 columns that contain Radius, Height, and Volume in m, m, and m3 units respectively. 6 samples of columns of different dimensions are taken.

Setting Column Dimensions


πŸ“Œ Step 2: Apply Formula to Calculate Column Volume

Generic Formula for Column Volume

=π×r2Γ—h

Here,

  • The PI function returns the value of Ο€ (3.14159265358979), accurate to 15 digits,
  • r is the radius of the column,
  • h is the height of the column.
  • Now, we will apply this formula to our dataset. To do this, select cell D5, and type the following formula. Press ENTER.
=PI()*B5^2*C5

Applying Formula to Calculate Column Volume

  • Now, drag the Fill Handle to the remaining cells as shown in the following image.

Applying Formula to Calculate Column Volume

Finally, here are the calculated column volumes of all the column samples.

Applying Formula to Calculate Column Volume

Read More: How to Calculate Cut and Fill Volume in Excel (3 Easy Steps)


πŸ“Œ Step 3: Customize the Results in a Proper Format

At this stage, you can customize your result in a proper format. For this-

  • You need to select all the calculated volumes, then go to the Home tab >> Number group >> Format Cells icon. A Format Cells dialog box will appear.

Customizing the Result in a Proper Format

  • Now, under the Number the section, select Number from the Category list.
  • Then, in the Decimal places box, choose or type the number to which decimal places you want your column volumes to be. In this example, we choose 3 decimal places.

Customizing the Result in a Proper Format

Finally, here are the formatted computed column volumes.

Customizing the Result in a Proper Format


Conclusion

In this tutorial, I have discussed 3 quick steps to calculate column volume in Excel. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Hafiz Islam
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo