In geometry, the area enclosed by a circle with radius (r) is defined by the following formula: πr2
The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is...
In geometry, the formula for calculating the volume of a cone 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...
In geometry, the standard formula for calculating the surface area of a cylinder is:
In essence, this formula first calculates the area of the side of the cylinder, based on the circumference of the circle times...
This example shows one way to calculate BMI (Body Mass Index) in Excel. The standard BMI formula is:
BMI = weight (kg) / height (m)2
The approach used here is to first convert height in inches and feet to meters, and...
In geometry, the formula for calculating the surface area of a right cone is:
The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula...
The SQRT function is fully automatic and will return the square root of any positive number. For example, to get the square root of 25:
=SQRT(25) // returns 5
If you give SQRT a negative number, it will return a #NUM...
By definition, the nth root of a number can be calculated by raising that number to the power of 1/n. Exponents are entered using the exponentiation operator (^), with a number on the left and power on the right. So, in...
In geometry, the formula for calculating the volume of a cylinder is:
The Greek letter π ("pi") represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula with...
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...
The cube root of a number can be calculated manually with the exponentiation operator (^) or with the POWER function.
Manually with ^
The cube root of a number can be calculated manually by raising a number to the (1/...
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 surface area of a sphere is:
The Greek...