Spreadsheet - Functions
May 2018
The Concept of a Function
Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows:
- Arithmetic functions that offer basic tools to process numerical data
- Statistical functions that have analysis tools, averaging tools
- Date functions that process and convert dates
- Logic functions that process logic data (AND, OR, etc.)
- Financial functions that process monetary data
Function Syntax
A function is characterised by its name (written in uppercase by convention), followed by parenthesis. It contains arguments (inside the parenthesis), which are a set of values, seperated by semi-colons, to which the function applies. Thus, a function called FUNCTION would be written as follows:
FUNCTION(argument1; argument2; etc.)
Related
- Functions of spreadsheet
- Basic functions of spreadsheet
- Functions of a spreadsheet
- Spreadsheets - Mathematical Functions » Articles
- Spreadsheet - Formulas » Articles
- Function key lock » How-To - Keyboard
- Function keys not working (Solved) » Forum - Hardware
- Mutator function c++ » How-To - C++ Language
Latest update on October 16, 2008 at 09:43 AM by Jeff.