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
Search JabSto ::




Custom Search