Spreadsheet - Functions


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.)
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Latest update on October 16, 2008 at 09:43 AM by Jean-François Pillou.

This document, titled "Spreadsheet - Functions," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).