Function reference

Ability provides a range of over 200 built-in functions that you can use in formulas.

A built-in function is a fast way to perform often-used calculations (such as totaling a group of numbers) or complicated calculations (like figuring the net present value or the internal rate of return).

The functions in Ability are divided into the following main categories:

Date functions

Financial functions

Trigonometric functions

Mathematical functions

Statistical functions

Remote functions

Text functions

Document functions

Lookup functions

Logical functions

Information functions

 

See also:

Using built-in functions

Using the function dialog box to build formulas

Text arguments

Arrays

Arithmetical operators

Logical operators

Relational operators

Priority of evaluation of operators

Cell error indicators