beautypg.com

Exact, Fact – Apple Numbers '08 User Manual

Page 230

background image

230

Chapter 12

Dictionary of Functions

EXACT

The EXACT function returns TRUE if the argument strings are identical in case and
characters.

EXACT(string1, string2)

 string1: A text expression. To include the string as the argument, place quotation

marks around it.

 string2: The second text expression.

EXP

The EXP function calculates e to the power of a number.

EXP(number)

 number: The power to which you want to raise e. It can be a number, a numeric

expression, or a reference to a cell containing a numeric expression.

FACT

The FACT function calculates the factorial of a nonnegative number.

FACT(number)

 number: A nonnegative number.

Notes
Any fractional part of number is truncated before the calculation.

Examples

EXACT("toledo", "toledo") returns TRUE.

EXACT("Toledo", "toledo") returns FALSE.

EXACT(toledo", "tol" & "edo") returns TRUE.

Examples

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

EXP(LN(5)) returns 5. EXP is the inverse of the LN function.

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! computed.

FACT(-1) returns an error; the number must be nonnegative.