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: