Apple Numbers '08 Manual do Utilizador descarregar pdf (Página 230)

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.

1 2 ... 225 226 227 228 229 230 231 232 233 234 235 ... 294 295

Sem comentários

Apple Numbers '08 Manual do Utilizador Página 230