Volume of a cone

=1/3*PI()*r^2*h
To calculate the volume of a cone, you can use the PI function together with the exponent operator (^). In the example shown, the formula in D5, copied down, is:
=1/3*PI()*B5^2*C5
The formula returns the volume of a cone with the radius given in column B and the height given in column C. Units are indicated generically with "u", and the resulting volume is units cubed (u3).
In geometry, the formula for calculating the volume of a cylinder is:
The formula for calculating the volume of a cone is based on the formula for calculating the volume of a pyramid. Since the base of a cone is a circular, the formula for area of a circle is included.
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 function, which returns the number 3.14159265358979, accurate to 15 digits:
=PI() // returns 3.14159265358979
To square a number in Excel, you can use the exponentiation operator (^):
=A1^2
Or, you can use the POWER function:
=POWER(A1,2)
Rewriting the formula for volume of a cylinder with Excel's math operators, we get:
=1/3*PI()*B5^2*C5
Or, with the POWER function:
The result is the same for both formulas. Following Excel's order of operations, exponentiation will occur before multiplication.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.