How to Calculate Volume in Excel (7 Different Ways)

Method 1 – Volume Calculation of a Sphere

Volume of a Sphere = 4/3 * pi * r^3

Steps:

• We only need to know the radius of the sphere.
• Select a cell for the volume calculation (i.e. C7).

• Input the following formula in cell C7:

Here, C5 represents the radius of the sphere in meters.

• Press Enter to have the volume of the sphere.

You can insert a custom value and check if the formula changes.

Method 2 – Volume Calculation of a Rectangular Solid

Volume of a Rectangular Solid= l * a * b

Steps:

• We need the length, width, and height of the solid in cells C5, C6, and C7.
• Choose a cell for the volume calculation (i.e. C9).

• Insert the following formula:

• Hit Enter.

Try yourself in the following section.

Method 3 – Volume Calculation of a Cube

Volume of a Cube= a^3

Steps:

• Insert the edge length of the cube in C5.
• Pick a cell for the calculation (i.e. C7).

• Insert the formula mentioned below:

• Hit Enter.

You can practice here by yourself.

Method 4 – Volume Calculation of a Cylinder

Volume of a Cylinder = pi * r^2 * H

r = Radius of the base
h = Height

Steps:

• Put the radius and height of a cylinder in cells C5 and C6.
• Pick a cell for the volume calculation (i.e. C8).

• Input the following formula:

• Hit Enter.

You can practice in the sample datasheet.

Method 5 – Volume Calculation of a Cone

Volume of a Cone = 1/3 * pi * r^2 * h

r = Radius of the base
h = Height of the cone

Steps:

• Put the radius and height of a cone in cells C5 and C6.
• Choose a cell for the volume calculation (i.e. C8).

• Input the formula mentioned below:

• Press Enter.

Try yourself in the practice section.

Method 6 – Volume Calculation of a Torus

Volume of a Torus = 2 * pi^2 * r^2 * R

r = inner radius of the cross-section
R = outer radius of the torus (distance from the center of the torus to the center of the cross-section)

Steps:

• Put the inner and outer radiuses of a torus in cells C5 and C6.
• Select a cell for the volume calculation (i.e. C8).

• Input the formula mentioned below:

• Hit Enter.

You can practice in the practice worksheet.

Method 7 – Volume Calculation of an Ellipsoid

Volume of an Ellipsoid = 4/3 * pi * a * b * c

a, b, and c are the lengths of the axes. A sphere will have equal axes.

Steps:

• Put the ellipsoid values a, b, and c, into cells C5, C6, and C7.
• Choose a cell for the volume calculation (i.e. C9).

• Insert the following formula:

• Press Enter.

Use the practice section for testing.

Download the Practice Workbook

<< Go Back to Area and Volume | Formula List | Learn Excel