Flux rss

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


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 - Worksheets 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 column is called a cell. A... en.kioskea.net/tableur/tabfeuille.php3
Spreadsheets - Logic Functions 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,... en.kioskea.net/tableur/tablogic.php3
Spreadsheets - Arithmetic Functions 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,... en.kioskea.net/tableur/tabstat.php3
[VBA]Updating a procedure or function[VBA]Updating a procedure or function Managing a workbook,provided that only the standard functions of the spreadsheet are available,is a very difficult process. The logical step is to make use of Visual Basic Applications (VBA).... en.kioskea.net/faq/sujet-1176-vba-updating-a-procedure-or-function
Soople.com - All Google functionsoople.com - All Google function Soople is a website that offers all the functions of Google with a more simplified and attractive graphical interface(see below). It has been created for people who are not familiar with Google. This... en.kioskea.net/faq/sujet-380-soople-com-all-google-function
Activate mail ()function on websiteActivate mail function on website To be able to activate the mail function on your website, there is a special code that you can make use of and paste in your PHP document. Some webhosting services do not allow them however. You should... en.kioskea.net/faq/sujet-624-activate-mail-function-on-website
Macro Help neededHello, I have a question... I am very new to macro functions. I have 2 large spreadsheets of data and I need to compare them both. One contains data that needs to be completed, and the other contains the data that was completed. I need to match them... en.kioskea.net/forum/affich-22276-macro-help-needed
EXCEL Macro - Find and replace function -HelpHello, I work for a customer care ... I need to set a macro to delete customer information in the same file -- around 30,000 contact. I was thinking to use the find and replace function - but it does ONLY work for the original contact --- I can say... en.kioskea.net/forum/affich-24505-excel-macro-find-and-replace-function-help
Growth FunctionHello, I cant get the GROWTH function to predict the next in the series from Y = X^2. I have just started practising using forecasting functions and this seemed like a good test for me. Peter en.kioskea.net/forum/affich-30074-growth-function
Download Firefox Accessibility ExtensionUnder Windows there is already an option of accessibility for the persons with agility reduced or having problems of view. The navigator Firefox also wanted to ameliorate his functions to allow these persons to use at the farthest means on... en.kioskea.net/telecharger/telecharger-540-firefox-accessibility-extension
Download Drivers Realtek AC'97 AudioFor Windows 98, DirectX (R) is necessary to benefit from advanced functionality of Driver REALTEK AC ' Audio 97. Driver REALTEK AC ' 97 Audio Codec for Windows 98/98 / / 2000 / XP / 2003 (32/64 bits) is compatible with the following audio... en.kioskea.net/telecharger/telecharger-971-drivers-realtek-ac-97-audio
Download AVG Anti-Virus FreeAVG Antivirus free is an free antivirus : Easy to use, low system resource Automatic update functionality Real-time protection as files are opened and programs are run Full e-mail protection AVG’s Virus Vault for the safe handling of... en.kioskea.net/telecharger/telecharger-64-avg-anti-virus-free
Spreadsheets - Conditional expressions 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 offer operators that compare... en.kioskea.net/tableur/tabcond.php3
Spreadsheets - Mathematical 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 nearest odd integer MOD(value1;... en.kioskea.net/tableur/tabmath.php3
Spreadsheets - Cell 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. An entire line can be chosen by clicking directly on the line header: It is also possible to choose... en.kioskea.net/tableur/tabcellselect-1.php3