Explanation

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

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

In the example shown, the formula in E5 is:

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).

Area of a circle

Area of a triangle

Circumference of a circle

Volume of a sphere

Excel formula: Area of a circle

Excel formula: Area of a triangle

Excel formula: Circumference of a circle

Excel formula: Volume of a sphere