You are viewing the dynamic version of this page. Please use the static version of this page if the page does not load or you do not have JavaScript enabled. More about this documentation.
Loading function list...
About this documentation:
Google Spreadsheets provides support for cell formulas consistent with those used in traditional and popular desktop spreadsheet packages. A powerful part of these formulas are the functions which may be included to manipulate data and calculate results using strings and numbers which could be the content of other cells. The following is a list of all the supported functions within each major category.
This document contains modified content from Appendix B of the OpenOffice.org "Calc Guide", available at http://documentation.openoffice.org/manuals/oooauthors2/0314CG-DescriptionOfFunctions.pdf. This content is licensed under the Creative Commons Attribution License, version 2.0, available at http://creativecommons.org/licenses/by/2.0/legalcode.
The copyright notice found in the OpenOffice.org "Calc Guide" is included in its complete form below.
Copyright
This document is Copyright © 2005 by its contributors as listed in the section titled Authors. You can distribute it and/or modify it under the terms of either the GNU General Public License, version 2 or later (http://www.gnu.org/licenses/gpl.html) or the Creative Commons Attribution License, version 2.0 or later (http://creativecommons.org/licenses/by/2.0/).
All trademarks within this guide belong to their legitimate owners.
Authors
Magnus Adielsson
Richard Barnes
Peter Kupfer
Iain Roberts
Jean Hollis Weber
Notes on financial functions
Accounting systems vary in the number of days in a month or a year used in calculations. The following table gives the integers used for the basis parameter used in some of the financial analysis functions.
Table 1: Basis calculation types
| Basis | Calculation |
|---|---|
| 0 or missing | US method (NASD), 12 months of 30 days each. |
| 1 | Exact number of days in months, exact number of days in year. |
| 2 | Exact number of days in month, year has 360 days. |
| 3 | Exact number of days in month, year has 365 days. |
| 4 | European method, 12 months of 30 days each. |
Notes on date functions
Google Spreadsheets handles and computes date/time values as numbers. When you assign a numeric format (such as "1,000 Rounded") to a date or time value, it is displayed as a number. To get the date value, format the cell as the desired date format (such as "3/24/2006 Date").
Notes on function examples
Many of our function examples are provided by our user base. If you would like to contribute examples for functions, please visit the Google Docs help forum.