beautypg.com

Fact, 174 exp 174 fact – Apple iWork '09 User Manual

Page 174

background image

EXP

The EXP function returns e (the base of natural logarithms) raised to the specified
power.

EXP(exponent)

Â

exponent: The power to which you want to raise e. exponent is a number value.

Usage Notes

EXP and LN are mathematically inverses over the domain where LN is defined, but

Â

because of floating-point rounding, EXP(LN(x)) may not give exactly x.

Example

=EXP(1) returns 2.71828182845905, an approximation of e.

Related Topics
For related functions and additional information, see:

“LN” on page 179

“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

FACT

The FACT function returns the factorial of a number.

FACT(fact-num)

Â

fact-num: A number. fact-num is a number value and must be greater than or equal
to 0. Any decimal (fractional) part of fact-num is ignored.

Examples

=FACT(5) returns 120, or 1 * 2 * 3 * 4 * 5.
=FACT(0) returns 1.
=FACT(4.5) returns 24. The fraction is dropped and 4 factorial is computed.
=FACT(-1) returns an error; the number must be nonnegative.

174

Chapter 8

Numeric Functions