Microsoft Office Tutorials and References
In Depth Information
Area, Surface, Circumference, and Volume Calculations
Area, Surface, Circumference, and Volume
Calculations
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:
Π