Formulas and Functions

EXP
The EXP function returns e (the base of natural logarithms) raised to the specied
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 dened, but Â
because of oating-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