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:
Where r represents radius, and 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 cube a number in Excel, you can use the exponentiation operator (^):
Or, you can use the POWER function:
Rewriting the formula using Excel's math operators we get:
Or, with the POWER function:
The result is the same for both formulas. Following Excel's order of operations, exponentiation will occur before multiplication.