Microsoft Office Tutorials and References

In Depth Information

**PI**

PI
The
PI
function returns the approximate number 3.14159265358979, the mathematical

constant pi, accurate to 15 digits.

=PI()

Where the radius of the circle is 6.75, the calculation to find the area from the radius is

=PI()*(D11^2)
and the result is 143.14 (as shown in Figure 10.18).

Figure 10.18

To find the area of a

circle with the known

radius, use the
PI

function.

POWER

The
POWER
function returns the result of a number raised to a power.

=POWER(number,power)

For example:
POWER(5,3)
equals 125.

The
NUMBER
argument is the base number, and it can be any real

number.

NUMBER

The
POWER
argument is the exponent to which the base number is

raised. The
POWER
function performs the inverse operation of the

LOG
function. An equivalent formula to the
POWER
function is
=x^y

versus
POWER(x,y)
.

POWER

PRODUCT

The
PRODUCT
function multiplies all the numbers given as arguments and returns the product.

=PRODUCT(number1,number2, ...)

For example:
PRODUCT(2,5,10)
equals 100. Acceptable arguments are numbers, logical

values, and numbers entered as text. Error values or text that cannot be translated into numbers

return errors. If an argument is an array or reference, only numbers in the array or reference