Exceljet

Quick, clean, and to the point

Volume of a rectangular prism

Excel formula: Volume of a rectangular prism
Generic formula 
=l*w*h
Summary 

To calculate the volume of a rectangular prism, you can use Excel's multiplication operator (*) with measurements for length, width, and height. In the example shown, the formula in E5, copied down, is:

=B5*C5*D5

which calculates the volume of a rectangular prism, given the length in column B (l), the width in column C (w) and the height in column D (h). Units are indicated generically with "u", and the resulting volume is in units cubed (u3).

Explanation 

In geometry, the formula for calculating the volume of a rectangular prism is: 

=lwh

This formula can be represented in Excel with the multiplication operator (*) like this

=l*w*h

In the example shown, the formula in E5 is:

=B5*C5*D5 // returns 0.13

As the formula is copied down the column, it calculates a new volume in each row, using the length in column B (l), the width in column C (w) and the height in column D (h).

Author 
Dave Bruns
Related formulas 
Excel formula: Area of a circle
Area of a circle
In geometry, the area enclosed by a circle with radius (r) is defined by the following formula: πr 2 The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula with the PI...
Excel formula: Area of a triangle
Area of a triangle
In geometry, the area enclosed by a triangle is defined by this formula: where b represents the base of the triangle, and h represents the height, measured at right angles to the base. In Excel, the same formula can be represented like this: A = b...
Excel formula: Circumference of a circle
Circumference of a circle
In geometry, the circumference of a circle with radius (r) is defined by the following formula: =2πr The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula with the PI...
Excel formula: Volume of a sphere
Volume of a sphere
In geometry, a sphere is defined as the set of points that are all the same distance (r) from a given point in a three-dimensional space. The formula for calculating the volume of a sphere is: The Greek letter π ("pi") represents the ratio of the...

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formulas | 101 Functions

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.