next up previous contents
Next: Errors Up: Formulas Previous: Symbolic Operators

Functions

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order or structure.

Arguments can be numbers or cell references. A cell reference can be a single cell or a range of cells. A single cell can use relative addressing (A1) or absolute addressing ($B$5). A range of cells is specified by a pair of diagonal cells (A1:C5 or $A$1:$C:$5). Different functions have difference requirements on the number or type of parameters.

The structure of a function begins with the an equal sign (=), the function name, an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis.

=FUNCTION(ARGUMENT1,ARGUMENT2,...)

Sharp Tools Spreadsheet implements various symbolic formula operations:


next up previous contents
Next: Errors Up: Formulas Previous: Symbolic Operators
Daniel Medina
2000-12-10