Text Operators

Spreadsheet - Functions

Mathematical Functions
Foglio elettronico - Le funzioni Folha de cálculo - As funções Tabellenkalkulation - die Funktionen Tableur - Les fonctions

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.)


Last update on Thursday October 16, 2008 02:43:17 PM.This document entitled « Spreadsheet - Functions » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.
Best answers for « Spreadsheet Functions » in :
Function Definition Show The Definition/Define Features on Google Google enables you to quickly find the definition of a word for this, do this: (Note: you must put a space before and after the colon (:), otherwise it will not work.) definition: Keyword...
Can Excel functions Return Formatted Text to Show
Spreadsheets - Logic Functions Show 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...
[VBA]Updating a procedure or function Show[VBA]Updating a procedure or function Intro Solution Intro Managing a workbook,provided that only the standard functions of the spreadsheet are available,is a very difficult process. Solution The logical step is to make use of...
Javascript - trim() function Show[Javascript] The trim() function The trim () function is native PHP (and other languages) and is used to remove the spaces at the beginning and end of the string. There is no such function in Javascript, but you can use the...
VISTA ERROR: MS-DOS FUNCTION INVALID ShowVISTA ERROR: MS-DOS FUNCTION INVALID Solution When trying to delete a file, Microsoft Vista display the following error message: Copy the file - An unexpected error fails operation. Note that the error code, which can help you...
Download Business Functions Show
Download AM-Notebook Show
Download Spreadsheet Converter ShowIt is not always necessary to create a complex script in order to insert a form into a web page. The use of some line of Javascript of Spreadsheet Converter allows you to use online form. Spreadsheet Converter is a program to create a form for a...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Spreadsheets - Mathematical Functions ShowStandard Functions Function Description ABS() This function returns the absolute value of a number. It therefore returns the number, if it is positive, or the opposite (positive) if it is negative ODD(value) Rounds a number up to the...
They need your help