By Ken Burnside
Updated Aug 30, 2022

Digital Vision./Digital Vision/Getty Images

Excel 2013 simplifies a wide range of mathematical tasks, including calculating volumes for solid geometries. Instead of manually inputting dimensions into a calculator, you can enter multiple measurements into Excel, tweak them, and instantly see how the volume changes. By mastering Excel‑friendly formulas, you’ll compute accurate volumes for ellipsoids, cubes, cylinders, cones, and tori with ease.

Volume of an Ellipsoid

Step 1

Label cells A1, B1, and C1 as “Radius 1,” “Radius 2,” and “Radius 3,” respectively.

Step 2

Enter the following formula in cell D2:

\= (4/3)*PI()*A2*B2*C2

Step 3

Input the three radii of the ellipsoid you’re evaluating in cells A2, B2, and C2. Using the same value for all three cells yields the volume of a sphere.

Volume of a Rectangular Solid

Step 1

Label cells A4, B4, and C4 as “Height,” “Width,” and “Length,” respectively.

Step 2

Enter the following formula in cell D5:

\= A5*B5*C5

Step 3

Input the three side dimensions of the rectangular solid in cells A5, B5, and C5. If all dimensions are equal, the calculation returns the volume of a cube.

Volume of a Cylindrical Solid

Step 1

Label cells A7 and B7 as “Radius” and “Height,” respectively.

Step 2

Enter the following formula in cell D8:

\= PI()*A8^2*B8

Step 3

Enter the radius and height of the cylinder in cells A8 and B8.

Volume of a Cone

Step 1

Label cells A10 and B10 as “Radius” and “Height,” respectively.

Step 2

Enter the following formula in cell D11:

\= PI()*A11^2*B11*(1/3)

Step 3

Input the radius and height of the cone in cells A11 and B11.

Volume of a Torus

Step 1

Label cells A13 and B13 as “Outer Radius” and “Inner Radius,” respectively.

Step 2

Enter the following formula in cell D14:

\= PI()^2*(A14+B14)*(A14-B14)^2

Step 3

Input the inner and outer radii of the torus in cells A14 and B14.