Microsoft Office Tutorials and References
In Depth Information
This section contains formulas for calculating the area, surface, circumference, and volume for common two-
and three-dimensional shapes.
Calculating the area and perimeter of a square
To calculate the area of a square, square the length of one side. The following formula calculates the area of a
square for a cell named side:
=side^2
To calculate the perimeter of a square, multiply one side by 4. The following formula uses a cell named side to
calculate the perimeter of a square:
=side*4
Calculating the area and perimeter of a rectangle
To calculate the area of a rectangle, multiply its height by its base. The following formula returns the area of a
rectangle, using cells named height and base:
=height*base
To calculate the perimeter of a rectangle, multiply the height by 2 and then add it to the width multiplied by 2.
The following formula returns the perimeter of a rectangle, using cells named height and width:
=(height*2)+(width*2)
Calculating the area and perimeter of a circle
To calculate the area of a circle, multiply the square of the radius by Π. The following formula returns the area
of a circle. It assumes that a cell named radius contains the circle's radius:
=PI()*(radius^2)
The radius of a circle is equal to one-half of the diameter.
To calculate the circumference of a circle, multiply the diameter of the circle by Π. The following formula cal-
culates the circumference of a circle using a cell named diameter:
=diameter*PI()
The diameter of a circle is the radius times 2.
Calculating the area of a trapezoid
To calculate the area of a trapezoid, add the two parallel sides, multiply by the height, and then divide by 2. The
following formula calculates the area of a trapezoid, using cells named parallel side 1, parallel side 2, and
height:
Search JabSto ::




Custom Search