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:

Π

=PI()*(radius^2)