Flux rss
They need your help
Text Operators

Spreadsheet - Functions

Mathematical Functions
Bookmark Bookmark & Share
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.
Spreadsheets - Logic 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... en.kioskea.net/contents/tableur/tablogic.php3
Spreadsheets - Mathematical Functions Standard 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... en.kioskea.net/contents/tableur/tabmath.php3
Spreadsheets - Conditional expressions What 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... en.kioskea.net/contents/tableur/tabcond.php3
[VBA]Updating a procedure or function[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... en.kioskea.net/faq/sujet-1176-vba-updating-a-procedure-or-function
VISTA ERROR: MS-DOS FUNCTION INVALIDVISTA 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... en.kioskea.net/faq/sujet-1186-vista-error-ms-dos-function-invalid
[PHP] mail function()[PHP] mail function() The mail function() is blocked by most free hosts for security reasons (avoid spamming), the IP address of the machine which requested the script will be indicated in the header 'X-MM - Mail-From-IP. The syntax is:... en.kioskea.net/faq/sujet-1249-php-mail-function
Results for Spreadsheet Functions
Excel Functions (VBA) for Compound ReturnsTwo questions: 1) Rolling Return: Can anyone help me write a VBA function in excel (as I think it does not exist in excel’s built in formulas) to measure compound returns for a specified period within a data range (I can send the spreadsheet as an... en.kioskea.net/forum/affich-111558-excel-functions-vba-for-compound-returns
Import webpage data into Excel spreadsheetHello, I am attempting to import the web page data from "http://bet1.hkjc.com/..." through EXCEL - new web query function but unsuccessful, the 'odds' data cannot be captured. Any idea? Thanks. en.kioskea.net/forum/affich-31834-import-webpage-data-into-excel-spreadsheet
Excel Custom FunctionHello, i have created a custom excel function which works fine. the only problem being, you need to press F2 on the custom formula cell and give enter to refresh the formula. is there any way to refresh the formula every time the workbook is opened or... en.kioskea.net/forum/affich-24381-excel-custom-function
Results for Spreadsheet Functions
Download Business FunctionsBusiness Functions is a software which helps you to elaborate your budget and your business plan. It offers a spreadsheet including of many functions of MS Excel. It allows you to have a short and transparent formula to be used in your operation. Each... en.kioskea.net/telecharger/telecharger-4607-business-functions
Download AM-NotebookAm-Notebook helps you to store your notes. It allows you to record an unlimited number of notes and have access to them easily. It has a spreadsheet including many functions and formulas. It also includes many tools in its interface such as address... en.kioskea.net/telecharger/telecharger-4640-am-notebook
Results for Spreadsheet Functions
CDN Dual Function Digital Timer (17-51017)CDN Dual Function Digital Timer, 20-hour, magneticInstrument Range: 20 hours by hr/min; 100 min by min/secDual functionCounts up/downBig digitLong alarm (> 1 min)Alarm sounds, lights & vibratesStop & restartLast count recallFood-safe ABSSliding mode... en.kioskea.net/guide/641745854-cdn-dual-function-digital-timer-17-51017
Ability SpreadsheetNumerical analysis software compatible with MS Excel. Includes multi-sheet workbooks templates & styles AutoSpell (red underlining) AutoCorrect and AutoText grammar checker print to fit 240+ functions 3D cell referencing... en.kioskea.net/guide/630410159-ability-spreadsheet
Results for Spreadsheet Functions
New software makes iPhones spreadsheet-friendlyUS software developer MeLLmo has released a free application that turns iPhones into powerful tools for analyzing spreadsheets and reports, enhancing the appeal of Apple mobile devices to businesses. The application, named RoamBi, intuitively... en.kioskea.net/actualites/new-software-makes-iphones-spreadsheet-friendly-12823-actualite.php3
Results for Spreadsheet Functions
Spreadsheet - FormulasIntroduction 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... en.kioskea.net/contents/tableur/tabformules.php3
Spreadsheets - Cell SelectionCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line... en.kioskea.net/contents/tableur/tabcellselect-1.php3
Spreadsheets - WorksheetsThe Concept of a Worksheet Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered with numbers) and of columns (numbered with letters). The intersection of a line and a... en.kioskea.net/contents/tableur/tabfeuille.php3
Results for Spreadsheet Functions