Apple numbers User Manual

    Dictionary of Functions 

 

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.

  

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.

  

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.
  

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

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

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

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

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

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.