Formulas and Functions

PI
The PI function returns the approximate value of π (pi), the ratio of a circle’s
circumference to its diameter.
PI()
Usage Notes
The PI function does not have any arguments. However, you must include the Â
parentheses: =PI().
PI is accurate to 15 decimal places. Â
Examples
=PI() returns 3.14159265358979.
=SIN(PI()/2) returns 1, the sine of π/2 radians or 90 degrees.
Related Topics
For related functions and additional information, see:
“COS” on page 333
“SIN” on page 336
“TAN” on page 338
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
POWER
The POWER function returns a number raised to a power.
POWER(number, exponent)
 number: A number. number is a number value.
 exponent: The power to which to raise the given number. exponent is a number value.
Usage Notes
The POWER function produces the same result as the ^ operator: =POWER(x, y) Â
returns the same result as =x^y.
186 Chapter 8 Numeric Functions