./gnumeric_DOC-1.10.17-i486-spup/0000755000000000000000000000000011634355617014502 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/0000755000000000000000000000000011634354305015304 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/share/0000755000000000000000000000000011634354353016411 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/share/man/0000755000000000000000000000000011634354353017164 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/share/man/man1/0000755000000000000000000000000011634354353020020 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/share/man/man1/gnumeric.10000644000000000000000000001422011634354177021716 0ustar rootroot.de URL
\\$2 \(laURL: \\$1 \(ra\\$3
..
.if \n[.g] .mso www.tmac
.TH GNUMERIC 1 "2009-02-08" gnumeric "GNOME"
.SH NAME
gnumeric \- a GNOME spreadsheet application.
.SH SYNOPSIS
\fBgnumeric\fR [\fIOPTIONS\fR] [\fIfiles\fR \fI...\fR ]
.SH DESCRIPTION
\fBGnumeric\fR is a powerful spreadsheet program created by the GNOME
project. \fBGnumeric\fR intends to compete with commercial
spreadsheets by becoming fully compatible with Microsoft Excel(TM) and
through the support of most popular spreadsheet file formats such as
Excel(TM), Lotus 1-2-3(TM), Applix(TM), Sylk(TM), XBase(TM),
Oleo(TM) and OpenOffice.org formats.
\fBGnumeric\fR supports advanced calculations using statistical,
financial and database access functions. Plotting data is supported
through an incomplete but powerful plotting system. A plugin system
extends \fBgnumeric\fR , for instance enabling the export of data to
the LaTeX \\longtable format. Plugins can be used to define custom
functionality. A rudimentary scripting API for the Python language
exists and will be extended in the near future. Since \fBgnumeric\fR
is \fBfree\fR software, \fBgnumeric\fR can also be extended directly
at the source code level by any competent programmer.
The program can be started from the command line as \fBgnumeric\fR or
from one of the menus provided by the underlying platform. When started
on the command line, \fBgnumeric\fR may be followed by the options listed
below and possibly the names of files in various spreadsheet formats
which will then be opened immediately. For instance, the command:
gnumeric myfile.gnumeric
will launch \fBgnumeric\fR and open the file called
"myfile.gnumeric". The default \fBgnumeric\fR file format is in
extensible markup language (XML) which subsequently has been
compressed with \fBgzip\fR.
.SH USER OPTIONS
This program follows the usual GNU command line syntax, with single
letter options starting with a single dash (`-') and longer options
starting with two dashes (`--').
.SS "Help options"
.B \-?, \-\-help
Show help message.
.TP
.B \-\-usage
Displays a brief usage message.
.SS "Gnumeric options"
.TP
.B \-v, \-\-version
Displays the version number of the installed instance of
\fBgnumeric\fR.
.TP
.B \-\-no-splash
Start \fBgnumeric\fR without showing the splash screen. The splash
screen is normally shown if loading files takes too long.
.TP
\fB\-L, \-\-lib-dir=\fR\fISTRING\fR
Set the root library directory to STRING which should be a pathname.
.TP
\fB\-D, \-\-data-dir=\fR\fISTRING\fR
Adjust the root data directory to STRING which should be a pathname.
.SS "Options for window placement"
.TP
\fB\-g, \-\-geometry=WIDTHxHEIGHT+XOFF+YOFF
Set the size and position of the first window. All units are in
pixels. The X offset is from the left hand side of the screen, the Y
offset is from the top of the screen. For example, \-g=800x600+20+30
will open a gnumeric window 800 pixels wide by 600 pixels high, with
the left edge of gnumeric 20 pixels from the left of the screen and
the top edge of gnumeric 30 pixels from the top of the screen.
.TP
.B \fB\-\-display=\fR\fIDISPLAY\fR
X display to use, where DISPLAY has the form
machinename:Xdisplay.Screen. Note that the machine displaying gnumeric
must have granted the machine running gnumeric the right to display
(see xhost).
.TP
.B \fB\-\-screen=\fR\fISCREEN\fR
X screen to use, a more compact form of the functionality described
above.
.SH ADVANCED OPTIONS
.SS "GNOME options"
.TP
.B \-\-disable-sound
Disable sound server usage.
.TP
.B \-\-enable-sound
Enable sound server usage.
.TP
\fB\-\-espeaker=\fR\fIHOSTNAME:PORT\fR
Host:port on which the sound server to use is running.
.TP
.B \-\-disable-crash-dialog
Disable the bug submission dialog which appears if Gnumeric crashes.
.SS "GTK options"
.TP
\fB\-\-gdk-debug=\fR\fIFLAGS\fR
Gdk debugging flags to set.
.TP
\fB\-\-gdk-no-debug=\fR\fIFLAGS\fR
Gdk debugging flags to unset.
.TP
.B \-\-sync
Make X calls synchronous.
.TP
\fB\-\-name=\fR\fINAME\fR
Program name as used by the window manager.
.TP
\fB\-\-class=\fR\fICLASS\fR
Program class as used by the window manager.
.TP
\fB\-\-gxid_host=\fR\fIHOST\fR
The host on which to contact the gxid daemon. This overrides the GXID_HOST environment variable. This option is only available if GTK+ has been configured with \-\-gdk-target=x11.
.TP
\fB\-\-gxid_port=\fR\fIPORT\fR
The port for the connection to gxid. This overrides the GXID_PORT environment variable. This option is only available if GTK+ has been configured with --gdk-target=x11.
.TP
\fB\-\-gtk-debug=\fR\fIFLAGS\fR
Gtk+ debugging flags to set.
.TP
\fB\-\-gtk-no-debug=\fR\fIFLAGS\fR
Gtk+ debugging flags to unset.
.TP
\fB\-\-g-fatal-warnings\fR
Make all warnings fatal.
.TP
\fB\-\-gtk-module=\fR\fIMODULE\fR
Load an additional Gtk module.
.SS "Session management options"
.TP
\fB\-\-sm-client-id=\fR\fIID\fR
Specify session management ID.
.TP
\fB\-\-sm-config-prefix=\fR\fIPREFIX\fR
Specify prefix of saved configuration.
.TP
.B \-\-sm-disable
Disable connection to session manager.
.SH VERSION
This manual page describes \fBgnumeric\fR version 1.8.
.SH BUGS
For the list of known \fBgnumeric\fR bugs, or to report new ones
please visit \fIhttp://bugzilla.gnome.org\fR.
.SH "SEE ALSO"
\fBssconvert\fR(1),
\fBssindex\fR(1),
\fBssgrep\fR(1)
.TP
.B The Gnumeric Manual
Available through the \fBHelp\fR menu or
.URL "http://www.gnome.org/projects/gnumeric/doc/gnumeric.shtml" online .
.TP
.URL "http://www.gnome.org/projects/gnumeric/" "The Gnumeric Homepage" .
.TP
.URL "http://www.gnome.org/" "The GNOME project page" .
.SH LICENSE
\fBGnumeric\fR is licensed under the terms of the General Public
License (GPL), version 2. For information on this license look at the
source code that came with the software or see the
.URL "http://www.gnu.org/" "GNU project page" .
.SH COPYRIGHT
The copyright on the \fBgnumeric\fR software and source code is held
by the individual authors as is documented in the source code.
.SH AUTHORS
.SS "Gnumeric"
Jody Goldberg
.br
Miguel de Icaza
.br
Morten Welinder
.br
-- and many others. For a more complete list, see the About dialog.
.SS "This manual page"
Jan Schaumann
.br
Adrian Custer
./gnumeric_DOC-1.10.17-i486-spup/usr/share/man/man1/ssgrep.10000644000000000000000000000620411634354177021413 0ustar rootroot.de URL
\\$2 \(laURL: \\$1 \(ra\\$3
..
.if \n[.g] .mso www.tmac
.TH SSGREP 1 "2009-02-08" gnumeric "GNOME"
.SH NAME
ssgrep \- search spreadsheets for strings
.SH SYNOPSIS
\fBssgrep \fR [\fIOPTIONS\fR] [\fIFILES\fR]
.SH DESCRIPTION
This manual page briefly documents the \fBssgrep\fR command.
\fBssgrep\fR is a command line utility to search for strings in spreadsheets of
any format supported by gnumeric.
.\".SH "RETURN VALUE"
.\".SH "EXIT STATUS"
.\".SH ERRORS
.SH OPTIONS
This program follows the usual GNU command line syntax, with single
letter options starting with a single dash (`-') and longer options
starting with two dashes (`--').
.SS "Options controlling input file handling"
.TP
.B \-\-recalc
Recalculate all cells
.SS "Options controlling patterns and pattern matching"
.TP
.B \-f, \-\-keyword\-file=\fIFILE\fR
The path to a text file containing one key per line
.TP
.B \-i, \-\-ignore\-case
Ignore differences in letter case
.TP
.B \-w, \-\-word\-regexp
Match only whole words
.TP
.B \-F, \-\-fixed\-strings
Pattern is a set of fixed strings
.TP
.B \-R, \-\-search\-results
Search results of expressions too
.TP
.B \-v, \-\-invert-match
Search for cells that do not match
.SS "Options controlling output in general"
.TP
.B \-c, \-\-count
Only print a count of matches per file
.TP
.B \-L, \-\-files\-without\-matches
Print filenames without matches
.TP
.B \-l, \-\-files\-with\-matches
Print filenames with matches
.TP
.B \-q, \-\-quiet
Suppress all normal output
.TP
.B \-H, \-\-with\-filename
Print the filename for each match
.TP
.B \-h, \-\-without\-filename
Do not print the filename for each match
.TP
.B \-n, \-\-print\-locus
Print the location of each match
.TP
.B \-T, \-\-print\-type
Print the location type of each match
.SS "Help options"
.TP
.B \-V, \-\-version
Display ssgrep's version
.TP
.B \-?, \-\-help
Display the supported options
.TP
.B \-\-usage
Display a brief usage message
.\".SH USAGE
.SH EXAMPLE
To search for the string "SUM" in the file \fIfoo.gnumeric\fR :
.PP
\fBssgrep\fR \fISUM\fR \fIfoo.gnumeric\fR
.PP
To search for the strings from the file \fIkeywords\fR in the spreadsheet \fIfoo.xls\fR :
.PP
\fBssgrep\fR \fB\-\-keyword\-file=\fIkeywords\fR \fIfoo.xls\fR
.PP
.\".SH FILES
.\".SH ENVIRONMENT
.\".SH DIAGNOSTICS
.\".SH SECURITY
.\".SH CONFORMING TO
.\".SH NOTES
.\".SH BUGS
.SH LICENSE
\fBssgrep\fR is licensed under the terms of the General Public
License (GPL), version 2. For information on this license look at the
source code that came with the software or see the
.URL "http://www.gnu.org" "GNU project page" .
.SH COPYRIGHT
The copyright on \fBssgrep\fR and the \fBgnumeric\fR software and source
code is held by the individual authors as is documented in the source code.
.SH AUTHOR
\fBssgrep\fR's primary author is Jody Goldberg ;
\fBssgrep\fR builds on the \fBgnumeric\fR codebase.
The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen
(Ray) .
.SH SEE ALSO
\fBbeagled\fR(1),
\fBgnumeric\fR(1),
\fBssconvert\fR(1),
\fBssindex\fR(1)
.URL "http://www.gnome.org/projects/gnumeric/" "The Gnumeric Homepage" .
.URL "http://www.gnome.org/" "The GNOME project page" .
./gnumeric_DOC-1.10.17-i486-spup/usr/share/man/man1/ssconvert.10000644000000000000000000002431611634354177022142 0ustar rootroot.de URL
\\$2 \(laURL: \\$1 \(ra\\$3
..
.if \n[.g] .mso www.tmac
.TH SSCONVERT 1 "2010-09-14" "gnumeric" "GNOME"
.SH NAME
ssconvert \- a command line spreadsheet format converter
.SH SYNOPSIS
\fBssconvert\fR [\fIOPTIONS\fR] \fIinfile\fR \fIoutfile\fR
.P
\fBssconvert\fR [\fIOPTIONS\fR] \fB\-\-merge\-to\fR \fIoutfile\fR \fIinfile1\fR \fIinfile2\fR \fB...\fR
.SH DESCRIPTION
\fBssconvert\fR is a command line utility to convert spreadsheet files
between various spreadsheet file formats. It is a companion utility to
\fBGnumeric\fR, the powerful spreadsheet program created by the GNOME
project.
\fBssconvert\fR accepts either file names or URIs as \fIinfile\fR
\fIoutfile\fR. The special URIs \fIfd://0\fR and \fIfd://1\fR can be
used for standard input and standard output respectively.
.SH OPTIONS
This program follows the usual GNU command line syntax, with single
letter options starting with a single dash (`-') and longer options
starting with two dashes (`--').
.SS "Main options"
.TP
.B \-\-recalc
Recalculate all cells before writing the result.
.TP
.B \-\-list\-exporters
List the available exporters (file formats that can be written).
.TP
.B \-T, \-\-export\-type=\fIID\fR
Specify which exporter to use; see below for a list. This is only
necessary when the right format does not follow from the output file
name.
.TP
.B \-O, \-\-export\-options=\fIoptionsstring\fR
Specify parameters for the chosen exporter.
\fIoptionsstring\fR is a list of \fIparameter\fR=\fIvalue\fR pairs, separated
by spaces.
The parameter names and values allowed are specific to the exporter and are
documented below. Multiple parameters can be specified
.TP
.B \-\-list\-importers
List the available importers (file formats that can be read).
.B \-I, \-\-import\-type=\fIID\fR
Specify which importer to use; see below for a list. This is only
necessary when the right format does not follow from the input file
name.
.TP
.B \-E, \-\-import\-encoding=\fISTRING\fR
Specify an encoding for imported content.
.TP
.B \-M, \-\-merge\-to=\fIFILENAME\fR
Merge a collection of workbooks into one. Sheet size will expand
to the largest in all the workbooks. Names in the scope of
individual workbooks will end up in the scope of the merged
workbook. The merge will be aborted if there are name conflicts.
.TP
.B \-S, \-\-export\-file\-per\-sheet
Export a file for each sheet if the exporter only supports one sheet at a
time. The output filename is treated as a template in which sheet number
is substituted for %n and/or sheet name is substituted for %s. If there
are not substitutions, a default of ".%s" is added.
.SS "Help options"
.TP
.B \-v, \-\-version
Display ssconvert's version.
.TP
.B \-h, \-\-help, \-\-usage
Display a brief usage message.
.TP
.B \-\-help\-all
Show all help options.
.TP
.B \-\-help\-libspreadsheet
Show Gnumeric options.
.SS "Path options"
.TP
.B \-L, \-\-lib\-dir=STRING
Set the root library directory.
.TP
.B \-D, \-\-data\-dir=STRING
Adjust the root data directory.
.SH LIST OF IMPORTER/EXPORTER IDS
The following IDs can be can be used both for import (reading) and export
(writing).
.TP
.B Gnumeric_XmlIO:sax
Gnumeric's XML file format (*.gnumeric)
.TP
.B Gnumeric_OpenCalc:openoffice
.URL "http://en.wikipedia.org/wiki/OpenDocument" "OpenDocument"
or
.URL "http://en.wikipedia.org/wiki/OpenOffice.org_Calc" "OpenOffice Calc"
(*.sxc, *.ods) format.
As an exporter, this is ODF/OpenOffice without foreign elements (*.ods).
.TP
.B Gnumeric_dif:dif
.URL "http://en.wikipedia.org/wiki/Data_Interchange_Format" "Data Interchange Format"
(*.dif)
.TP
.B Gnumeric_paradox:paradox
.URL "http://en.wikipedia.org/wiki/Paradox_%28database%29" "Paradox database"
or primary index file (*.db, *.px)
.TP
.B Gnumeric_stf:stf_assistant
Text (configurable)
.TP
.B Gnumeric_sylk:sylk
.URL "http://en.wikipedia.org/wiki/Multiplan" "MultiPlan"
.URL "http://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29" "Symbolic Link (SYLK)"
(*.slk)
.TP
.B Gnumeric_Excel:xlsx
Microsoft Excel (tm) 2007 ("Office Open XML",
.URL "http://en.wikipedia.org/wiki/XLSX" "OOXML"
) format
.SH LIST OF IMPORTANT IMPORTER IDS
.TP
.B Gnumeric_stf:stf_csvtab
Comma or tab separated values (CSV/TSV) (*.csv)
.TP
.B Gnumeric_html:html
HTML (*.html, *.htm)
.TP
.B Gnumeric_Excel:excel
Microsoft Excel (tm) (*.xls)
.TP
.B Gnumeric_Excel:excel_xml
Microsoft Excel (tm) 2003 SpreadsheetML
.SH LIST OF OTHER IMPORTER IDS
.TP
.B Gnumeric_QPro:qpro
.URL "http://en.wikipedia.org/wiki/Quattro_Pro" "Quattro Pro"
(*.wb1, *.wb2, *.wb3)
.TP
.B Gnumeric_applix:applix
Applix (*.as)
.TP
.B Gnumeric_lotus:lotus
.URL "http://en.wikipedia.org/wiki/Lotus_1-2-3" "Lotus 1-2-3"
(*.wk1, *.wks, *.123)
.TP
.B Gnumeric_mps:mps
.URL "http://en.wikipedia.org/wiki/MPS_%28format%29" "MPS (Mathematical Programming System) format"
Linear programming and mixed integer programming file format (*.mps)
.TP
.B Gnumeric_oleo:oleo
.URL "http://en.wikipedia.org/wiki/GNU_Oleo" "GNU Oleo"
(*.oleo)
.TP
.B Gnumeric_plan_perfect:pln
PlanPerfect Format (PLN)
.TP
.B Gnumeric_psiconv:psiconv
Psion (*.psisheet)
.TP
.B Gnumeric_sc:sc
SC/xspread
.TP
.B Gnumeric_xbase:xbase
.URL "http://en.wikipedia.org/wiki/XBase" "xBase"
(*.dbf) file format
.SH LIST OF IMPORTANT EXPORTER IDS
.TP
.B Gnumeric_OpenCalc:odf
ODF/OpenOffice with foreign elements (*.ods)
.TP
.B Gnumeric_glpk:glpk
GLPK Linear Program Solver
.TP
.B Gnumeric_html:html40
HTML 4.0 (*.html)
.TP
.B Gnumeric_html:html40frag
HTML (*.html) fragment
.TP
.B Gnumeric_html:xhtml
XHTML (*.html)
.TP
.B Gnumeric_html:xhtml_range
XHTML range - for export to clipboard
.TP
.B Gnumeric_pdf:pdf_assistant
Portable Document Format (*.PDF)
.TP
.B Gnumeric_stf:stf_csv
Comma separated values (CSV)
.TP
.B Gnumeric_Excel:excel_dsf
Microsoft Excel (tm) 97/2000/XP & 5.0/95
.SH LIST OF OTHER EXPORTER IDS
.TP
.B Gnumeric_Excel:excel_biff7
Microsoft Excel (tm) 5.0/95
.TP
.B Gnumeric_Excel:excel_biff8
Microsoft S Excel (tm) 97/2000/XP
.TP
.B Gnumeric_GnomeGlossary:po
Gnome Glossary PO file format
.TP
.B Gnumeric_html:html32
HTML 3.2 (*.html)
.TP
.B Gnumeric_html:latex
LaTeX 2e (*.tex)
.TP
.B Gnumeric_html:latex_table
LaTeX 2e (*.tex) table fragment
.TP
.B Gnumeric_html:roff
.URL "http://en.wikipedia.org/wiki/Troff" "TROFF"
(*.me) format.
.TP
.B Gnumeric_lpsolve:lpsolve
.URL "http://sourceforge.net/projects/lpsolve/" "LPSolve"
Mixed Integer Linear Programming (MILP) solver
.SH OPTIONS FOR THE PORTABLE DOCUMENT FORMAT (*.pdf) EXPORTER
.TP
.B sheet
Name of the workbook sheet to operate on.
.TP
.B paper
Paper size. Valid values include "\fBA4\fR" for ISO A4 and
"\fBna_letter_8.5x11in\fR" for US Letter.
.\" FIXME Is there a convenient way to list all valid paper sizes?
.\" It looks like at least the values from plugins/excel/ms-excel-read.c's
.\" paper_size_table[] are supported.
.SH OPTIONS FOR THE CONFIGURABLE TEXT (*.txt) EXPORTER
.\" Cf. "g_object_class_install_property" calls in src/stf-export.c
.TP
.B sheet
Name of the workbook sheet to operate on.
.TP
.B eol
End Of Line convention; how lines are terminated.
"\fBunix\fR" for linefeed,
"\fBmac\fR" for carriage return;
"\fBwindows\fR" for carriage return plus linefeed.
.TP
.B charset
The character encoding of the output. Defaults to UTF-8.
.TP
.B locale
The locale to use for number and date formatting.
Defaults to the current locale as reported by \fBlocale\fR(1).
Consult \fBlocale -a\fR output for acceptable values.
.TP
.B quote
The character or string used for quoting fields. Defaults to "\fB\\"\fR"
(quotation mark / double quote).
.TP
.B separator
The string used to separate fields. Defaults to space.
.TP
.B format
How cells should be formatted.
Acceptable values:
"\fBautomatic\fR" (apply automatic formatting; default),
"\fBraw\fR" (output data raw, unformatted), or
"\fBpreserve\fR" (preserve the formatting from the source document).
This deals with the difference between a cell's contents and the way those
contents are formatted.
Consider a cell in a Gnumeric input document that was
input as "4/19/73" in a US locale, with a format set to "d-mmm-yyyy" and
thus formatted as "19-Apr-1973".
With the default \fBformat\fR setting of "\fBautomatic\fR" it will be output
as "1973/04/19". With "\fBpreserve\fR", the formatting will be preserved and
it will be output as "19-Apr-1973". With "\fBraw\fR" it will be output as
"26773" (Gnumeric's internal representation: days since an epoch).
.TP
.B transliterate-mode
How to handle unrepresentable characters (characters that cannot be
represented in the chosen output character set).
Acceptable values:
"\fBtransliterate\fR", or
"\fBescape\fR".
.TP
.B quoting-mode
When does data need to be quoted?
"\fBnever\fR",
"\fBauto\fR" (puts quotes where needed), or
"\fBalways\fR". Defaults to "\fBnever\fR".
.TP
.B quoting-on-whitespace
Controls whether initial or terminal whitespace forces quoting. Defaults to
\fBTRUE\fR.
.\".SH EXIT STATUS
.\".SH RETURN VALUE
.\".SH ERRORS
.\".SH ENVIRONMENT
.\".SH FILES
.\".SH VERSIONS
.\".SH CONFORMING TO
.\".SH NOTES
.\".SH BUGS
.\".SH USAGE
.SH EXAMPLE
To convert the Gnumeric file \fIfoo.gnumeric\fR to a Microsoft Excel(TM)
format file
\fIfoo.xls\fR:
.PP
\fBssconvert\fR \fIfoo.gnumeric\fR \fIfoo.xls\fR
.PP
The export format can be specified explicitly, to override the default
(which is based on the file extension):
.PP
\fBssconvert\fR \fB\-\-export\-type=\fRGnumeric_stf:stf_csv\fR \fIfoo.xls\fR
\fIfoo.txt\fR
.PP
To convert an Excel format file \fIstatfuns.xls\fR to a text file,
specifying the semicolon as the separator character:
.PP
\fBssconvert\fR \fB-O 'separator=; format=raw'\fR \fIsamples/excel/statfuns.xls\fR \fIstatfuns.txt\fR
.PP
.SH LICENSE
\fBssconvert\fR is licensed under the terms of the General Public
License (GPL), version 2. For information on this license look at the
source code that came with the software or see the
.URL "http://www.gnu.org" "GNU project page" .
.SH COPYRIGHT
The copyright on the \fBGnumeric\fR software and source code is held
by the individual authors as is documented in the source code.
.SH AUTHOR
\fBssconvert\fR's primary author is Jody Goldberg ;
\fBssconvert\fR builds on the \fBGnumeric\fR codebase.
The initial version of this manpage was written by J.H.M. Dassen (Ray)
.
.SH SEE ALSO
.BR gnumeric(1),
.BR ssgrep(1),
.BR ssindex(1)
.URL "http://www.gnome.org/projects/gnumeric/" "The Gnumeric Homepage" .
.URL "http://www.gnome.org/" "The GNOME project page" .
./gnumeric_DOC-1.10.17-i486-spup/usr/share/man/man1/ssindex.10000644000000000000000000000437211634354177021571 0ustar rootroot.de URL
\\$2 \(laURL: \\$1 \(ra\\$3
..
.if \n[.g] .mso www.tmac
.TH SSINDEX 1 "2009-02-08" gnumeric "GNOME"
.SH NAME
ssindex \- generate index data for spreadsheet files
.SH SYNOPSIS
\fBssindex \fR [\fIOPTIONS\fR] [\fIFILES\fR]
.SH DESCRIPTION
This manual page briefly documents the \fBssindex\fR command.
\fBssindex\fR is a command line utility to generate index data for
various spreadsheet file formats. It is primarily used by the \fBBeagle\fR
indexing sub-system and search aggregator.
.\".SH "RETURN VALUE"
.\".SH "EXIT STATUS"
.\".SH ERRORS
.SH OPTIONS
This program follows the usual GNU command line syntax, with single
letter options starting with a single dash (`-') and longer options
starting with two dashes (`--').
.SS "Main options"
.TP
.B \-E, \-\-import\-encoding=\fIENCODING\fR
Specify an encoding for imported content
.TP
.B \-i, \-\-index
Index the given files
.TP
.B \-m, \-\-list\-mime\-types
List the MIME types which ssindex is able to read
.SS "Help options"
.TP
.B \-v, \-\-version
Display ssindex's version
.TP
.B \-?, \-\-help
Display the supported options
.TP
.B \-\-usage
Display a brief usage message
.SS "Path options"
.TP
.B \-L, \-\-lib\-dir=\fISTRING\fR
Set the root library directory
.TP
.B \-D, \-\-data\-dir=\fISTRING\fR
Adjust the root data directory
.\".SH USAGE
.\".SH EXAMPLES
.\".SH FILES
.\".SH ENVIRONMENT
.\".SH DIAGNOSTICS
.\".SH SECURITY
.\".SH CONFORMING TO
.\".SH NOTES
.\".SH BUGS
.SH LICENSE
\fBssindex\fR is licensed under the terms of the General Public
License (GPL), version 2. For information on this license look at the
source code that came with the software or see the
.URL "http://www.gnu.org" "GNU project page" .
.SH COPYRIGHT
The copyright on \fBssindex\fR and the \fBgnumeric\fR software and source
code is held by the individual authors as is documented in the source code.
.SH AUTHOR
\fBssindex\fR's primary author is Jody Goldberg ;
\fBssindex\fR builds on the \fBgnumeric\fR codebase.
The initial version of this manpage was written by J.H.M. Dassen (Ray)
.
.SH SEE ALSO
\fBbeagled\fR(1),
\fBgnumeric\fR(1),
\fBssconvert\fR(1),
\fBssgrep\fR(1)
.URL "http://www.gnome.org/projects/gnumeric/" "The Gnumeric Homepage" .
.URL "http://www.gnome.org/" "The GNOME project page" .
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/0000755000000000000000000000000011634354305017513 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/0000755000000000000000000000000011634354305020443 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/0000755000000000000000000000000011634354305022254 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/0000755000000000000000000000000011634354312022434 5ustar rootroot./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/configuration-plugins.xml0000644000000000000000000000326611634354176027523 0ustar rootrootPlugins
&gnum; allows users to configure the plugins which are currently
in use. The Plugin Manager provides all the
configuration options in one location.
The Plugin Manager can be started by clicking
on the Tools menu and selecting the
Plugins... menu item.
The Plugin Manager is a tabbed dialog with
three tabs. The first tab, labeled Plugin
List, provides a list of all the currently
visible plugins, the second tab, labeled Plugin
Details provides details on the plugin selected in the
first tab. The third tab, labeled Directories
lists the directories which are currently searched to discover new
plugins.
The first tab provides a list of plugins, an explanation of each
and a method to activate or de-activate the plugin. The list
includes all of the plugins which have been found by &gnum; in the
directories listed in the third tab. An explanation can be
obtained for each plugin by selecting the plugin from the list by
placing the mouse pointer over the plugin name and clicking with
the primary mouse button. The explanation will then appear in the
bottom text area. The active column provides check boxes in front
of each listed plugin. If the box contains a check mark, the
plugin has been activated and its functionality should be
available.
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/analysis-goalseek.xml0000644000000000000000000000464311634354176026610 0ustar rootrootGoal Seek ToolUse Goal Seek Tool to search for a value of a single model
variable that yields a given desired value of another single
variable. For example, you can use the Goal Seek to find the
break-even value for sales (the break-even is the amount of sales
whose marginal revenue just covers the fixed costs and the profit is
thus zero).Using the ToolFirst, select the ``Goal Seek...'' tool item from ``Tools''
menu. Specify the output variable cell (``Set Cell'') by typing
the cell reference into the entry or by clicking the worksheet
cell. If you are searching for the break-even point, for example,
you should specify the cell reference of the profit calculation
here.Specify the desired result for the output variable cell into
the ``To Value'' cell. In the search for the break-even, specify
this to be zero.Specify the input variable cell (``By changing cell'') by
typing the cell reference into the entry or by clicking the
worksheet cell. In the search for the break-even, specify the
cell reference of the sales here. When you have done this, you
may want to press the ``Apply'' button to start the tool.ResultsGnumeric will systematically iterate the model by changing
the input value to achieve the desired result, if possible. If
goal seek was successful the tool displays the message ``Goal
Seeking with cell __ found a solution''.It is possible that Gnumeric does not find a solution that
generates the desired result. There may not be such a solution
for the model, or, it may be too difficult to find. For example,
the mathematical function behind the calculation may have many
non-continuous points.Desired Value in a Given RangeIf Gnumeric did not find a solution that generates the
desired result, you may want to try to specify a range (minimum
and maximum) in which the value of the output variable should be.
To do this, specify the ``Minimum'' and ``Maximum''
entries../gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/gnumeric.xml0000644000000000000000000007110411634354176025002 0ustar rootroot
Gnumeric">
%isopub;
%isonum;
%isogrk1;
]>
The Gnumeric Manual, version &manrevision;20102009Andreas J. Guelzow.
2007200620052004Adrian Custer, Ray Dassen, Jody Goldberg,
Andreas J. Guelzow, Louis Luangkesorn.
2003Kevin Breit, Adrian Custer, Ray Dassen,
Jody Goldberg, Andreas J. Guelzow, Jon K. Hellan,
Jukka-Pekka Iivonen, Alexander Kirillov,
Charles Twardy, Sebastian Klost, Thomas Miesbauer.
2002Jody Goldberg, Andreas J. Guelzow, Wayne Schuller,
Adrian Custer, Kevin Breit, Aaron Weber,
Alexander Kirillov, Eric Baudais, Gregory Leblanc.
1998199920002001Miguel de Icaza, Thomas Canty, Jukka-Pekka Iivonen,
Almer S. Tigelaar, Morten Welinder.
GNOME Documentation Project
&legal;
EricBaudaisKevinBreitThomasCantyAdrianCusterRayDassenJodyGoldbergAndreas J.GuelzowJon K.HellanMiguelde IcazaJukka-PekkaIivonenAlexanderKirillovSebastianKlostGregoryLeblancLouisLuangkesornThomasMiesbauerWayneSchullerAlmer S.TigelaarCharlesTwardyAaronWeberMortenWelinderGnumeric Manual: Version &manrevision;&date;The Gnumeric TeamGNOME Documentation ProjectGnumeric Manual: Version 1.8November 2007The Gnumeric TeamGNOME Documentation ProjectGnumeric Manual: Version 1.4November 2004The Gnumeric TeamGNOME Documentation ProjectGnumeric Manual: Version 1.2September 2002The Gnumeric TeamGNOME Documentation ProjectGnumeric Manual: Version 1.0January 2002The Gnumeric TeamGNOME Documentation ProjectGnumeric Manual: Earlier Versions1998-2001The Gnumeric TeamGNOME Documentation ProjectThis manual describes version &appversion; of Gnumeric
Feedback
To report a bug or make a suggestion regarding the &gnum;
application or this manual, follow the directions in
.
Welcome!
&welcome;
How to Use this Manual
&manual-usage;
A Quick Introduction
The best way to learn how to use
&gnum; is to begin exploring the
program yourself. This chapter will help you get started trying
new things and seeing what happens. The chapter explains the
fundamentals of spreadsheets in general and of
&gnum; in particular. The chapter
attempts to help new users get started with
&gnum; and provides background for
the more detailed explanations given in the rest of the manual.
Getting started with computers
Unfortunately, this manual cannot teach you the very basics of
interacting with a modern computer. If you have never used
computers, don't know the names of the hardware components
(the pieces you can touch) or don't know the names of the
elements you see on the screen (like windows or the mouse
pointer), you will probably want to get some basic advice from
someone you know or read the manuals which came with your
machine or your operating system. It's all pretty easy but, in
order to understand this manual, you will need to know some
basic terminology and have some basic computing skills.
If you are using the GNOME desktop environment, you can read
the the GNOME
Desktop User Guide for help in getting started with
computers.
If you are using the another desktop environment such as
KDE or another
operating system, please see the instructions from the web
site linked with either your desktop environment, your
operating system, your software distribution source or the
people who provided you with your computer. There are also
many books providing good introduction to computers.
&quick-start;
Gnumeric Elements
This chapter describes all of the pieces of
&gnum; which a user can
manipulate. The chapter provides explanations for each of the
menus, menu entries, toolbar buttons and other elements of the
graphical user interface.
&gui-overview;
&gui-menus;
&gui-toolbars;
&gui-other-elements;
&gui-mouse;
Working with Data
This chapter explains the core functionality of
&gnum; including the basic types of
data manipulated by &gnum;, the
methods of entering, manipulating and formatting data, and the
basic tools for analysis of these data. More advanced analysis is
described in .
&data-overview;
&data-types;
&data-entry;
&data-entry-adv;
&data-entry-extern;
&data-selections;
&data-move-copy;
&data-delete;
&data-insert;
&data-format;
&data-filter;
&data-modify;
&data-generate;
&data-commentNlink;
Advanced Analysis
This chapter explains many of the advanced analytic tools
available in &gnum; including linear algebra calculations and simulation
analysis.
&analysis-overview;
&analysis-complexNum;
&analysis-goalseek;
&analysis-simulation;
&analysis-scenarios;
The Solver
This chapter explains the linear programming solver available
from within &gnum;.
&analysis-solver;
Statistical Analysis
This chapter explains the various statistical analysis tools
available within &gnum;.
&gnum; includes various tools for statistical
data analysis and data sampling. To use
these tools select them from the Statistics menu
and its submenus. The tools are described below. In this description as
well as in the Statistics menu these tools are
classified into six categories.
&analysis-statistical;
Graphics: Images, Widgets, and Drawings
This chapter explains how to add graphical elements to a
&gnum; worksheet, including
images from external
files, graphical user interface widgets which interact with
worksheet data, and simple drawing elements.
&graphics-overview;
&graphics-images;
&graphics-widgets;
&graphics-drawings;
Graphs
&gnum; includes a powerful mechanism
to create graphical charts which present visually the data contained
in a worksheet.
The first section of this chapter starts with an overview of
graph creation, discusses terminology, and presents graph
components and their organization. The next section explains
the "Chart Guru" which is the tool used to
configure graphs. The subsequent section presents the different
types of plots which can be included in a graph and the final
section explains how data can be pre-selected to speed up the
process of graph creation.
Charts are exceedingly effective communication
devices. Unfortunately, this means that one cannot determine,
simply based on the data to be plotted, what type of plot will be
the most effective. Instead users must familiarize themselves with
the various types of plots which are available and decide for
themselves which plot type is the most effective to communicate
an idea. contains a
detailed explanation of the plot types available in
&gnum;.
This chapter explains how to add graphs to plot worksheet data.
&graphics-plots;
Using Worksheets
This chapter explains the use and manipulation of worksheets in
&gnum;. The chapter explains how to move around a worksheet, how
to alter the appearance and display organization of the
worksheet contents, how to manipulate entire worksheets and how
to protect worksheet contents.
&f-worksheets;
Workbook Settings
This chapter explains the contents of a
&gnum; workbook which are not part
of the worksheets. This includes several settings which apply to
the workbook and are saved in the
&gnum; file. Settings which apply
to the &gnum; program itself are
called `preferences' and are explained in .
&f-workbooks;
Configuring Gnumeric
This chapter explains how to change the default behaviour of
&gnum; including the startup
behaviour and default locale (language and number display).
&config-overview;
&config-preferences;
&config-toolbars;
&config-plugins;
&config-localization;
Working with Files
This chapter explains how to use files in &gnum;. The chapter
provides an extensive description of the file formats used by
&gnum;. The chapter also explains how to open files, import data
from text files, save files, export data to text files, send
data to others via electronic mail, and convert files from one
format to another.
&files-overview;
&files-formats;
&files-opening;
&files-textopen;
&files-saving;
&files-textsave;
&files-email;
&files-ssconvert;
Printing
This chapter explains how to print spreadsheets, tables and
plots from &gnum; to a printer
directly or into Postscript or PDF (both are page description
languages).
&printing;
Getting More Help
This chapter describes other sources of help which are available
to users including the &gnum; web
site, the mailing list, and the internet relay chat (IRC)
discussion channel.
&morehelp;
Reporting a Problem
This chapter explains how to report a problem with
&gnum; so that the problem can be
fixed. The same procedure can be used to file a report
requesting an enhancement or a new feature.
&bugs;
Extending Gnumeric
This chapter explains how to go about extending
&gnum; to provide extra
functionality. Because &gnum; is
Free Software this is quite easy to do.
&extending-overview;
&extending-functions;
&extending-python;
&extending-plugins;
&function-ref;
&appendix-keybindings;
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/data-insert.xml0000644000000000000000000000056411634354176025406 0ustar rootroot
Inserting New Data Cells
This section has not yet been written...
Para...
Para...
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/files-overview.xml0000644000000000000000000000554011634354176026140 0ustar rootrootFiles in Gnumeric
&gnum; stores its information by creating files and re-opening
these files during a future session. Saving information to files
also allows a user to send the information to others.
The default file format for &gnum; is based on the eXtensible
Markup Language (XML). By default, files are saved as text files,
consisting of XML, which are then compressed using the library of
the gzip program. The extension for
&gnum; files is .gnumeric on platforms which
support file extensions of any size, .gnum for
systems which restrict extensions to four letters, or
.gnm for systems which restrict extensions to
three letters.
&gnum; can also open or save files in a number of other file
formats. The project prides itself for the work reverse
engineering and supporting the file formats used by Microsoft
Excel. &gnum; can use the Excel file format as if it were the
native file format, meaning that &gnum; can store and retrieve
essentially every aspect of a worksheet using the Excel
format. Similarly, &gnum; supports the OASIS standard Open Office
XML file format as if it were the native format.
&gnum; cannot delete files from the file system. &gnum; can open
existing files and create new files but cannot delete files once
they are created. Files can be deleted using a file browser such
as Nautilus on the GNOME desktop or
using the command-line program rm.
This chapter discusses working with actual files. It is also
possible to import data into &gnum; using the clipboard by
copying either text or html table information in another program
and then pasting the resulting data into a worksheet. See for details.
Text files are often used to store data, using many different
systems to structure the data such as using commas, tabs or spaces
to separate values. &gnum; features a flexible system that enables
users to define exactly the structure of the text file to be
opened or saved.
&gnum; can be integrated with an email client to allow files to be
sent directly as attachments to an electronic mail message.
&gnum; also features a command-line tool called
ssconvert to convert files between any
of the file formats which it supports.
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/functions.xml0000644000000000000000000330247611634354176025215 0ustar rootroot
Function Reference
This appendix provides a list of all the functions which are
currently defined in Gnumeric.
Bitwise OperationsBITANDBITAND
bitwise and
BITAND(a,b)Argumentsa: non-negative integerb: non-negative integerDescriptionBITAND returns the bitwise and of the binary representations of its arguments.See alsoBITOR,
BITXOR.
BITLSHIFTBITLSHIFT
bit-shift to the left
BITLSHIFT(a,n)Argumentsa: non-negative integern: integerDescriptionBITLSHIFT returns the binary representations of a shifted n positions to the left.NoteIf n is negative, BITLSHIFT shifts the bits to the right by ABS(n) positions.See alsoBITRSHIFT.
BITORBITOR
bitwise or
BITOR(a,b)Argumentsa: non-negative integerb: non-negative integerDescriptionBITOR returns the bitwise or of the binary representations of its arguments.See alsoBITXOR,
BITAND.
BITRSHIFTBITRSHIFT
bit-shift to the right
BITRSHIFT(a,n)Argumentsa: non-negative integern: integerDescriptionBITRSHIFT returns the binary representations of a shifted n positions to the right.NoteIf n is negative, BITRSHIFT shifts the bits to the left by ABS(n) positions.See alsoBITLSHIFT.
BITXORBITXOR
bitwise exclusive or
BITXOR(a,b)Argumentsa: non-negative integerb: non-negative integerDescriptionBITXOR returns the bitwise exclusive or of the binary representations of its arguments.See alsoBITOR,
BITAND.
ComplexCOMPLEXCOMPLEX
a complex number of the form x + yiCOMPLEX(x,y,i)Argumentsx: real party: imaginary parti: the suffix for the complex number, either "i" or "j"; defaults to "i"NoteIf i is neither "i" nor "j", COMPLEX returns #VALUE!Microsoft Excel CompatibilityThis function is Excel compatible.IMABSIMABS
the absolute value of the complex number zIMABS(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMAGINARY,
IMREAL.
IMAGINARYIMAGINARY
the imaginary part of the complex number zIMAGINARY(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMREAL.
IMARCCOSIMARCCOS
the complex arccosine of the complex number
IMARCCOS(z)Argumentsz: a complex numberDescriptionIMARCCOS returns the complex arccosine of the complex number z. The branch cuts are on the real axis, less than -1 and greater than 1.NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCSIN,
IMARCTAN.
IMARCCOSHIMARCCOSH
the complex hyperbolic arccosine of the complex number zIMARCCOSH(z)Argumentsz: a complex numberDescriptionIMARCCOSH returns the complex hyperbolic arccosine of the complex number z. The branch cut is on the real axis, less than 1.NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCSINH,
IMARCTANH.
IMARCCOTIMARCCOT
the complex arccotangent of the complex number zIMARCCOT(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCSEC,
IMARCCSC.
IMARCCOTHIMARCCOTH
the complex hyperbolic arccotangent of the complex number zIMARCCOTH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCSECH,
IMARCCSCH.
IMARCCSCIMARCCSC
the complex arccosecant of the complex number zIMARCCSC(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCSEC,
IMARCCOT.
IMARCCSCHIMARCCSCH
the complex hyperbolic arccosecant of the complex number zIMARCCSCH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCSECH,
IMARCCOTH.
IMARCSECIMARCSEC
the complex arcsecant of the complex number zIMARCSEC(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCCSC,
IMARCCOT.
IMARCSECHIMARCSECH
the complex hyperbolic arcsecant of the complex number zIMARCSECH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCCSCH,
IMARCCOTH.
IMARCSINIMARCSIN
the complex arcsine of the complex number zIMARCSIN(z)Argumentsz: a complex numberDescriptionIMARCSIN returns the complex arcsine of the complex number z. The branch cuts are on the real axis, less than -1 and greater than 1.NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCCOS,
IMARCTAN.
IMARCSINHIMARCSINH
the complex hyperbolic arcsine of the complex number zIMARCSINH(z)Argumentsz: a complex numberDescriptionIMARCSINH returns the complex hyperbolic arcsine of the complex number z. The branch cuts are on the imaginary axis, below -i and above i.NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCCOSH,
IMARCTANH.
IMARCTANIMARCTAN
the complex arctangent of the complex number
IMARCTAN(z)Argumentsz: a complex numberDescriptionIMARCTAN returns the complex arctangent of the complex number z. The branch cuts are on the imaginary axis, below -i and above i.NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCSIN,
IMARCCOS.
IMARCTANHIMARCTANH
the complex hyperbolic arctangent of the complex number zIMARCTANH(z)Argumentsz: a complex numberDescriptionIMARCTANH returns the complex hyperbolic arctangent of the complex number z. The branch cuts are on the real axis, less than -1 and greater than 1.NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMARCSINH,
IMARCCOSH.
IMARGUMENTIMARGUMENT
the argument theta of the complex number zIMARGUMENT(z)Argumentsz: a complex numberDescriptionThe argument theta of a complex number is its angle in radians from the real axis.NoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.IMCONJUGATEIMCONJUGATE
the complex conjugate of the complex number zIMCONJUGATE(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMAGINARY,
IMREAL.
IMCOSIMCOS
the cosine of the complex number zIMCOS(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMSIN,
IMTAN.
IMCOSHIMCOSH
the hyperbolic cosine of the complex number zIMCOSH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMSINH,
IMTANH.
IMCOTIMCOT
the cotangent of the complex number zIMCOT(z)Argumentsz: a complex numberDescriptionIMCOT(z) = IMCOS(z)/IMSIN(z).NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMSEC,
IMCSC.
IMCOTHIMCOTH
the hyperbolic cotangent of the complex number zIMCOTH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMSECH,
IMCSCH.
IMCSCIMCSC
the cosecant of the complex number zIMCSC(z)Argumentsz: a complex numberDescriptionIMCSC(z) = 1/IMSIN(z).NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMSEC,
IMCOT.
IMCSCHIMCSCH
the hyperbolic cosecant of the complex number zIMCSCH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMSECH,
IMCOTH.
IMDIVIMDIV
the quotient of two complex numbers z1/z2IMDIV(z1,z2)Argumentsz1: a complex numberz2: a complex numberNoteIf z1 or z2 is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMPRODUCT.
IMEXPIMEXP
the exponential of the complex number zIMEXP(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMLN.
IMINVIMINV
the reciprocal, or inverse, of the complex number zIMINV(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.IMLNIMLN
the natural logarithm of the complex number zIMLN(z)Argumentsz: a complex numberDescriptionThe result will have an imaginary part between -π and +π.The natural logarithm is not uniquely defined on complex numbers. You may need to add or subtract an even multiple of π to the imaginary part.NoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMEXP,
IMLOG2,
IMLOG10.
IMLOG10IMLOG10
the base-10 logarithm of the complex number zIMLOG10(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMLN,
IMLOG2.
IMLOG2IMLOG2
the base-2 logarithm of the complex number zIMLOG2(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMLN,
IMLOG10.
IMNEGIMNEG
the negative of the complex number zIMNEG(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.IMPOWERIMPOWER
the complex number z1 raised to the z2th power
IMPOWER(z1,z2)Argumentsz1: a complex numberz2: a complex numberNoteIf z1 or z2 is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMSQRT.
IMPRODUCTIMPRODUCT
the product of the given complex numbers
IMPRODUCT(z1,z2,…)Argumentsz1: a complex numberz2: a complex numberNoteIf any of z1, z2,... is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMDIV.
IMREALIMREAL
the real part of the complex number zIMREAL(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMAGINARY.
IMSECIMSEC
the secant of the complex number zIMSEC(z)Argumentsz: a complex numberDescriptionIMSEC(z) = 1/IMCOS(z).NoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMCSC,
IMCOT.
IMSECHIMSECH
the hyperbolic secant of the complex number zIMSECH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMCSCH,
IMCOTH.
IMSINIMSIN
the sine of the complex number zIMSIN(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMCOS,
IMTAN.
IMSINHIMSINH
the hyperbolic sine of the complex number zIMSINH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMCOSH,
IMTANH.
IMSQRTIMSQRT
the square root of the complex number zIMSQRT(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMPOWER.
IMSUBIMSUB
the difference of two complex numbers
IMSUB(z1,z2)Argumentsz1: a complex numberz2: a complex numberNoteIf z1 or z2 is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMSUM.
IMSUMIMSUM
the sum of the given complex numbers
IMSUM(z1,z2,…)Argumentsz1: a complex numberz2: a complex numberNoteIf any of z1, z2,... is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMSUB.
IMTANIMTAN
the tangent of the complex number zIMTAN(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoIMSIN,
IMCOS.
IMTANHIMTANH
the hyperbolic tangent of the complex number zIMTANH(z)Argumentsz: a complex numberNoteIf z is not a valid complex number, #VALUE! is returned.See alsoIMSINH,
IMCOSH.
DatabaseDAVERAGEDAVERAGE
average of the values in field in database belonging to records that match criteriaDAVERAGE(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDCOUNT.
DCOUNTDCOUNT
count of numbers in field in database belonging to records that match criteriaDCOUNT(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDAVERAGE,
DCOUNTA.
DCOUNTADCOUNTA
count of cells with data in field in database belonging to records that match criteriaDCOUNTA(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDCOUNT.
DGETDGET
a value from field in database belonging to records that match criteriaDGET(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.NoteIf none of the records match the conditions, DGET returns #VALUE! If more than one record match the conditions, DGET returns #NUM!See alsoDCOUNT.
DMAXDMAX
largest number in field in database belonging to a record that match criteriaDMAX(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDMIN.
DMINDMIN
smallest number in field in database belonging to a record that match criteriaDMIN(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDCOUNT.
DPRODUCTDPRODUCT
product of all values in field in database belonging to records that match criteriaDPRODUCT(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDSUM.
DSTDEVDSTDEV
sample standard deviation of the values in field in database belonging to records that match criteriaDSTDEV(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDSTDEVP.
DSTDEVPDSTDEVP
standard deviation of the population of values in field in database belonging to records that match criteriaDSTDEVP(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDSTDEV.
DSUMDSUM
sum of the values in field in database belonging to records that match criteriaDSUM(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDPRODUCT.
DVARDVAR
sample variance of the values in field in database belonging to records that match criteriaDVAR(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDVARP.
DVARPDVARP
variance of the population of values in field in database belonging to records that match criteriaDVARP(database,field,criteria)Argumentsdatabase: a range in which rows of related information are records and columns of data are fieldsfield: a string or integer specifying which field is to be usedcriteria: a range containing conditionsDescriptiondatabase is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.See alsoDVAR.
GETPIVOTDATAGETPIVOTDATA
summary data from a pivot table
GETPIVOTDATA(pivot_table,field_name)Argumentspivot_table: cell range containing the pivot tablefield_name: name of the field for which the summary data is requestedNoteIf the summary data is unavailable, GETPIVOTDATA returns #REF!Date/TimeASCENSIONTHURSDAYASCENSIONTHURSDAY
Ascension Thursday in the Gregorian calendar according to the Roman rite of the Christian Church
ASCENSIONTHURSDAY(year)Argumentsyear: year between 1582 and 9956, defaults to the year of the next Ascension ThursdayNoteTwo digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.See alsoEASTERSUNDAY.
ASHWEDNESDAYASHWEDNESDAY
Ash Wednesday in the Gregorian calendar according to the Roman rite of the Christian Church
ASHWEDNESDAY(year)Argumentsyear: year between 1582 and 9956, defaults to the year of the next Ash WednesdayNoteTwo digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.See alsoEASTERSUNDAY.
DATEDATE
create a date serial value
DATE(year,month,day)Argumentsyear: year of datemonth: month of yearday: day of monthDescriptionThe DATE function creates date serial values. 1-Jan-1900 is serial value 1, 2-Jan-1900 is serial value 2, and so on. For compatibility reasons, a serial value is reserved for the non-existing date 29-Feb-1900.NoteIf month or day is less than 1 or too big, then the year and/or month will be adjusted. For spreadsheets created with the Mac version of Excel, serial 1 is 1-Jan-1904.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoTODAY,
YEAR,
MONTH,
DAY.
DATE2HDATEDATE2HDATE
Hebrew date
DATE2HDATE(date)Argumentsdate: Gregorian date, defaults to todaySee alsoHDATE,
DATE2HDATE_HEB.
DATE2HDATE_HEBDATE2HDATE_HEB
Hebrew date in Hebrew
DATE2HDATE_HEB(date)Argumentsdate: Gregorian date, defaults to todaySee alsoDATE2HDATE,
HDATE_HEB.
DATE2JULIANDATE2JULIAN
Julian day number for given Gregorian date
DATE2JULIAN(date)Argumentsdate: Gregorian date, defaults to todaySee alsoHDATE_JULIAN.
DATE2UNIXDATE2UNIX
the Unix timestamp corresponding to a date dDATE2UNIX(d)Argumentsd: dateDescriptionThe DATE2UNIX function translates a date into a Unix timestamp. A Unix timestamp is the number of seconds since midnight (0:00) of January 1st, 1970 GMT.See alsoUNIX2DATE,
DATE.
DATEDIFDATEDIF
difference between dates
DATEDIF(start_date,end_date,interval)Argumentsstart_date: starting date serial valueend_date: ending date serial valueinterval: counting unitDescriptionDATEDIF returns the distance from start_date to end_date according to the unit specified by interval.NoteIf interval is "y", "m", or "d" then the distance is measured in complete years, months, or days respectively. If interval is "ym" or "yd" then the distance is measured in complete months or days, respectively, but excluding any difference in years. If interval is "md" then the distance is measured in complete days but excluding any difference in months.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDAYS360.
DATEVALUEDATEVALUE
the date part of a date and time serial value
DATEVALUE(serial)Argumentsserial: date and time serial valueDescriptionDATEVALUE returns the date serial value part of a date and time serial value.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoTIMEVALUE,
DATE.
DAYDAY
the day-of-month part of a date serial value
DAY(date)Argumentsdate: date serial valueDescriptionThe DAY function returns the day-of-month part of date.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATE,
YEAR,
MONTH.
DAYSDAYS
difference between dates in days
DAYS(start_date,end_date)Argumentsstart_date: starting date serial valueend_date: ending date serial valueDescriptionDAYS returns the positive or negative number of days from start_date to end_date.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoDATEDIF.
DAYS360DAYS360
days between dates
DAYS360(start_date,end_date,method)Argumentsstart_date: starting date serial valueend_date: ending date serial valuemethod: counting methodDescriptionDAYS360 returns the number of days from start_date to end_date.NoteIf method is 0, the default, the MS Excel (tm) US method will be used. This is a somewhat complicated industry standard method where the last day of February is considered to be the 30th day of the month, but only for start_date. If method is 1, the European method will be used. In this case, if the day of the month is 31 it will be considered as 30 If method is 2, a saner version of the US method is used in which both dates get the same February treatment.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATEDIF.
EASTERSUNDAYEASTERSUNDAY
Easter Sunday in the Gregorian calendar according to the Roman rite of the Christian Church
EASTERSUNDAY(year)Argumentsyear: year between 1582 and 9956, defaults to the year of the next Easter SundayNoteTwo digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.OpenDocument Format (ODF) CompatibilityThe 1-argument version of EASTERSUNDAY is compatible with OpenOffice for years after 1904. This function is not specified in ODF/OpenFormula.See alsoASHWEDNESDAY.
EDATEEDATE
adjust a date by a number of months
EDATE(date,months)Argumentsdate: date serial valuemonths: signed number of monthsDescriptionEDATE returns date moved forward or backward the number of months specified by months.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATE.
EOMONTHEOMONTH
end of month
EOMONTH(date,months)Argumentsdate: date serial valuemonths: signed number of monthsDescriptionEOMONTH returns the date serial value of the end of the month specified by date adjusted forward or backward the number of months specified by months.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoEDATE.
GOODFRIDAYGOODFRIDAY
Good Friday in the Gregorian calendar according to the Roman rite of the Christian Church
GOODFRIDAY(year)Argumentsyear: year between 1582 and 9956, defaults to the year of the next Good FridayNoteTwo digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.See alsoEASTERSUNDAY.
HDATEHDATE
Hebrew date
HDATE(year,month,day)Argumentsyear: Gregorian year of date, defaults to the current yearmonth: Gregorian month of year, defaults to the current monthday: Gregorian day of month, defaults to the current daySee alsoHDATE_HEB,
DATE.
HDATE_DAYHDATE_DAY
Hebrew day of Gregorian date
HDATE_DAY(year,month,day)Argumentsyear: Gregorian year of date, defaults to the current yearmonth: Gregorian month of year, defaults to the current monthday: Gregorian day of month, defaults to the current daySee alsoHDATE_JULIAN.
HDATE_HEBHDATE_HEB
Hebrew date in Hebrew
HDATE_HEB(year,month,day)Argumentsyear: Gregorian year of date, defaults to the current yearmonth: Gregorian month of year, defaults to the current monthday: Gregorian day of month, defaults to the current daySee alsoHDATE,
DATE.
HDATE_JULIANHDATE_JULIAN
Julian day number for given Gregorian date
HDATE_JULIAN(year,month,day)Argumentsyear: Gregorian year of date, defaults to the current yearmonth: Gregorian month of year, defaults to the current monthday: Gregorian day of month, defaults to the current daySee alsoHDATE.
HDATE_MONTHHDATE_MONTH
Hebrew month of Gregorian date
HDATE_MONTH(year,month,day)Argumentsyear: Gregorian year of date, defaults to the current yearmonth: Gregorian month of year, defaults to the current monthday: Gregorian day of month, defaults to the current daySee alsoHDATE_JULIAN.
HDATE_YEARHDATE_YEAR
Hebrew year of Gregorian date
HDATE_YEAR(year,month,day)Argumentsyear: Gregorian year of date, defaults to the current yearmonth: Gregorian month of year, defaults to the current monthday: Gregorian day of month, defaults to the current daySee alsoHDATE_JULIAN.
HOURHOUR
compute hour part of fractional day
HOUR(time)Argumentstime: time of day as fractional dayDescriptionThe HOUR function computes the hour part of the fractional day given by time.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoTIME,
MINUTE,
SECOND.
ISOWEEKNUMISOWEEKNUM
ISO week number
ISOWEEKNUM(date)Argumentsdate: date serial valueDescriptionISOWEEKNUM calculates the week number according to the ISO 8601 standard. Weeks start on Mondays and week 1 contains the first Thursday of the year.NoteJanuary 1 of a year is sometimes in week 52 or 53 of the previous year. Similarly, December 31 is sometimes in week 1 of the following year.See alsoISOYEAR,
WEEKNUM.
ISOYEARISOYEAR
year corresponding to the ISO week number
ISOYEAR(date)Argumentsdate: date serial valueDescriptionISOYEAR calculates the year to go with week number according to the ISO 8601 standard.NoteJanuary 1 of a year is sometimes in week 52 or 53 of the previous year. Similarly, December 31 is sometimes in week 1 of the following year.See alsoISOWEEKNUM,
YEAR.
MINUTEMINUTE
compute minute part of fractional day
MINUTE(time)Argumentstime: time of day as fractional dayDescriptionThe MINUTE function computes the minute part of the fractional day given by time.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoTIME,
HOUR,
SECOND.
MONTHMONTH
the month part of a date serial value
MONTH(date)Argumentsdate: date serial valueDescriptionThe MONTH function returns the month part of date.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATE,
YEAR,
DAY.
NETWORKDAYSNETWORKDAYS
number of workdays in range
NETWORKDAYS(start_date,end_date,holidays,weekend)Argumentsstart_date: starting date serial valueend_date: ending date serial valueholidays: array of holidaysweekend: array of 0s and 1s, indicating whether a weekday (S, M, T, W, T, F, S) is on the weekend, defaults to {1,0,0,0,0,0,1}DescriptionNETWORKDAYS calculates the number of days from start_date to end_date skipping weekends and holidays in the process.NoteIf an entry of weekend is non-zero, the corresponding weekday is not a work day.Microsoft Excel CompatibilityThis function is Excel compatible if the last argument is omitted.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoWORKDAY.
NOWNOW
the date and time serial value of the current time
NOW()DescriptionThe NOW function returns the date and time serial value of the moment it is computed. Recomputing later will produce a different value.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATE.
PENTECOSTSUNDAYPENTECOSTSUNDAY
Pentecost Sunday in the Gregorian calendar according to the Roman rite of the Christian Church
PENTECOSTSUNDAY(year)Argumentsyear: year between 1582 and 9956, defaults to the year of the next Pentecost SundayNoteTwo digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.See alsoEASTERSUNDAY.
SECONDSECOND
compute seconds part of fractional day
SECOND(time)Argumentstime: time of day as fractional dayDescriptionThe SECOND function computes the seconds part of the fractional day given by time.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoTIME,
HOUR,
MINUTE.
TIMETIME
create a time serial value
TIME(hour,minute,second)Argumentshour: hour of the dayminute: minute within the hoursecond: second within the minuteDescriptionThe TIME function computes the fractional day between midnight at the time given by hour, minute, and second.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoHOUR,
MINUTE,
SECOND.
TIMEVALUETIMEVALUE
the time part of a date and time serial value
TIMEVALUE(serial)Argumentsserial: date and time serial valueDescriptionTIMEVALUE returns the time-of-day part of a date and time serial value.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATEVALUE,
TIME.
TODAYTODAY
the date serial value of today
TODAY()DescriptionThe TODAY function returns the date serial value of the day it is computed. Recomputing on a later date will produce a different value.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATE.
UNIX2DATEUNIX2DATE
date value corresponding to the Unix timestamp tUNIX2DATE(t)Argumentst: Unix time stampDescriptionThe UNIX2DATE function translates Unix timestamps into the corresponding date. A Unix timestamp is the number of seconds since midnight (0:00) of January 1st, 1970 GMT.See alsoDATE2UNIX,
DATE.
WEEKDAYWEEKDAY
day-of-week
WEEKDAY(date,method)Argumentsdate: date serial valuemethod: numbering system, defaults to 1DescriptionThe WEEKDAY function returns the day-of-week of date. The value of method determines how days are numbered; it defaults to 1. NoteIf method is 1, then Sunday is 1, Monday is 2, etc. If method is 2, then Monday is 1, Tuesday is 2, etc. If method is 3, then Monday is 0, Tuesday is 1, etc.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATE,
ISOWEEKNUM.
WEEKNUMWEEKNUM
week number
WEEKNUM(date,method)Argumentsdate: date serial valuemethod: numbering system, defaults to 1DescriptionWEEKNUM calculates the week number according to method which defaults to 1.NoteIf method is 1, then weeks start on Sundays and January 1 is in week 1. If method is 2, then weeks start on Mondays and January 1 is in week 1. If method is 150, then the ISO 8601 numbering is used.See alsoISOWEEKNUM.
WORKDAYWORKDAY
add working days
WORKDAY(date,days,holidays,weekend)Argumentsdate: date serial valuedays: number of days to addholidays: array of holidaysweekend: array of 0s and 1s, indicating whether a weekday (S, M, T, W, T, F, S) is on the weekend, defaults to {1,0,0,0,0,0,1}DescriptionWORKDAY adjusts date by days skipping over weekends and holidays in the process.Notedays may be negative. If an entry of weekend is non-zero, the corresponding weekday is not a work day.Microsoft Excel CompatibilityThis function is Excel compatible if the last argument is omitted.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoNETWORKDAYS.
YEARYEAR
the year part of a date serial value
YEAR(date)Argumentsdate: date serial valueDescriptionThe YEAR function returns the year part of date.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDATE,
MONTH,
DAY.
YEARFRACYEARFRAC
fractional number of years between dates
YEARFRAC(start_date,end_date,basis)Argumentsstart_date: starting date serial valueend_date: ending date serial valuebasis: calendar basisDescriptionYEARFRAC calculates the number of days from start_date to end_date according to the calendar specified by basis, which defaults to 0, and expresses the result as a fractional number of years.NoteIf basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoDATE.
EngineeringBASEBASE
string of digits representing the number n in base bBASE(n,b,length)Argumentsn: integerb: base (2 ≤ b ≤ 36)length: minimum length of the resulting stringDescriptionBASE converts n to its string representation in base b. Leading zeroes will be added to reach the minimum length given by length.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoDECIMAL.
BESSELIBESSELI
Modified Bessel function of the first kind of order α at xBESSELI(X,α)ArgumentsX: numberα: order (any number)NoteIf x or α are not numeric, #VALUE! is returned. If α < 0, #NUM! is returned.Microsoft Excel CompatibilityThis function is Excel compatible if only integer orders α are used.See alsoBESSELJ,
BESSELK,
BESSELY.
BESSELJBESSELJ
Bessel function of the first kind of order α at xBESSELJ(X,α)ArgumentsX: numberα: order (any non-negative integer)NoteIf x or α are not numeric, #VALUE! is returned. If α < 0, #NUM! is returned. If α is not an integer, it is truncated.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBESSELI,
BESSELK,
BESSELY.
BESSELKBESSELK
Modified Bessel function of the second kind of order α at xBESSELK(X,α)ArgumentsX: numberα: order (any number)NoteIf x or α are not numeric, #VALUE! is returned. If α < 0, #NUM! is returned.Microsoft Excel CompatibilityThis function is Excel compatible if only integer orders α are used.See alsoBESSELI,
BESSELJ,
BESSELY.
BESSELYBESSELY
Bessel function of the second kind of order α at xBESSELY(X,α)ArgumentsX: numberα: order (any non-negative integer)NoteIf x or α are not numeric, #VALUE! is returned. If α < 0, #NUM! is returned. If α is not an integer, it is truncated.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBESSELI,
BESSELJ,
BESSELK.
BIN2DECBIN2DEC
decimal representation of the binary number xBIN2DEC(x)Argumentsx: a binary number, either as a string or as a number involving only the digits 0 and 1Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDEC2BIN,
BIN2OCT,
BIN2HEX.
BIN2HEXBIN2HEX
hexadecimal representation of the binary number xBIN2HEX(x,places)Argumentsx: a binary number, either as a string or as a number involving only the digits 0 and 1places: number of digitsDescriptionIf places is given, BIN2HEX pads the result with zeros to achieve exactly places digits. If this is not possible, BIN2HEX returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoHEX2BIN,
BIN2OCT,
BIN2DEC.
BIN2OCTBIN2OCT
octal representation of the binary number xBIN2OCT(x,places)Argumentsx: a binary number, either as a string or as a number involving only the digits 0 and 1places: number of digitsDescriptionIf places is given, BIN2OCT pads the result with zeros to achieve exactly places digits. If this is not possible, BIN2OCT returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoOCT2BIN,
BIN2DEC,
BIN2HEX.
CONVERTCONVERT
a converted measurement
CONVERT(x,from,to)Argumentsx: numberfrom: unit (string)to: unit (string)DescriptionCONVERT returns a conversion from one measurement system to another. x is a value in from units that is to be converted into to units.from and to can be any of the following:Weight and mass: 'g' Gram 'sg' Slug 'lbm' Pound 'u' U (atomic mass) 'ozm' OunceDistance: 'm' Meter 'mi' Statute mile 'Nmi' Nautical mile 'in' Inch 'ft' Foot 'yd' Yard 'ang' Angstrom 'Pica' Pica Points 'picapt' Pica Points 'pica' PicaTime: 'yr' Year 'day' Day 'hr' Hour 'mn' Minute 'sec' SecondPressure: 'Pa' Pascal 'atm' Atmosphere 'mmHg' mm of MercuryForce: 'N' Newton 'dyn' Dyne 'lbf' Pound forceEnergy: 'J' Joule 'e' Erg 'c' Thermodynamic calorie 'cal' IT calorie 'eV' Electron volt 'HPh' Horsepower-hour 'Wh' Watt-hour 'flb' Foot-pound 'BTU' BTUPower: 'HP' Horsepower 'W' WattMagnetism: 'T' Tesla 'ga' GaussTemperature: 'C' Degree Celsius 'F' Degree Fahrenheit 'K' Degree KelvinLiquid measure: 'tsp' Teaspoon 'tbs' Tablespoon 'oz' Fluid ounce 'cup' Cup 'pt' Pint 'qt' Quart 'gal' Gallon 'l' LiterFor metric units any of the following prefixes can be used: 'Y' yotta 1E+24 'Z' zetta 1E+21 'E' exa 1E+18 'P' peta 1E+15 'T' tera 1E+12 'G' giga 1E+09 'M' mega 1E+06 'k' kilo 1E+03 'h' hecto 1E+02 'e' deca (deka) 1E+01 'd' deci 1E-01 'c' centi 1E-02 'm' milli 1E-03 'u' micro 1E-06 'n' nano 1E-09 'p' pico 1E-12 'f' femto 1E-15 'a' atto 1E-18 'z' zepto 1E-21 'y' yocto 1E-24NoteIf from and to are different types, CONVERT returns #N/A!Microsoft Excel CompatibilityThis function is Excel compatible (except "picapt").OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.DEC2BINDEC2BIN
binary representation of the decimal number xDEC2BIN(x,places)Argumentsx: integer (− 513 < x < 512)places: number of digitsDescriptionIf places is given and x is non-negative, DEC2BIN pads the result with zeros to achieve exactly places digits. If this is not possible, DEC2BIN returns #NUM!If places is given and x is negative, places is ignored.NoteIf x < − 512 or x > 511, DEC2BIN returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoBIN2DEC,
DEC2OCT,
DEC2HEX.
DEC2HEXDEC2HEX
hexadecimal representation of the decimal number xDEC2HEX(x,places)Argumentsx: integerplaces: number of digitsDescriptionIf places is given, DEC2HEX pads the result with zeros to achieve exactly places digits. If this is not possible, DEC2HEX returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoHEX2DEC,
DEC2BIN,
DEC2OCT.
DEC2OCTDEC2OCT
octal representation of the decimal number xDEC2OCT(x,places)Argumentsx: integerplaces: number of digitsDescriptionIf places is given, DEC2OCT pads the result with zeros to achieve exactly places digits. If this is not possible, DEC2OCT returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoOCT2DEC,
DEC2BIN,
DEC2HEX.
DECIMALDECIMAL
decimal representation of xDECIMAL(x,base)Argumentsx: number in base basebase: base of x, (2 ≤ base ≤ 36)OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoBASE.
DELTADELTA
Kronecker delta function
DELTA(x0,x1)Argumentsx0: numberx1: number, defaults to 0DescriptionDELTA returns 1 if x1 = x0 and 0 otherwise.NoteIf either argument is non-numeric, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoEXACT,
GESTEP.
ERFERF
Gauss error function
ERF(lower,upper)Argumentslower: lower limit of the integral, defaults to 0upper: upper limit of the integralDescriptionERF returns 2/sqrt(π)* integral from lower to upper of exp(-t*t) dtMicrosoft Excel CompatibilityThis function is Excel compatible if two arguments are supplied and neither is negative.See alsoERFC.
ERFCERFC
Complementary Gauss error function
ERFC(x)Argumentsx: numberDescriptionERFC returns 2/sqrt(π)* integral from x to ∞ of exp(-t*t) dtSee alsoERF.
GESTEPGESTEP
step function with step at x1 evaluated at x0GESTEP(x0,x1)Argumentsx0: numberx1: number, defaults to 0DescriptionGESTEP returns 1 if x1 ≤ x0 and 0 otherwise.NoteIf either argument is non-numeric, #VALUE! is returned.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoDELTA.
HEX2BINHEX2BIN
binary representation of the hexadecimal number xHEX2BIN(x,places)Argumentsx: a hexadecimal number, either as a string or as a number if no A to F are neededplaces: number of digitsDescriptionIf places is given, HEX2BIN pads the result with zeros to achieve exactly places digits. If this is not possible, HEX2BIN returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBIN2HEX,
HEX2OCT,
HEX2DEC.
HEX2DECHEX2DEC
decimal representation of the hexadecimal number xHEX2DEC(x)Argumentsx: a hexadecimal number, either as a string or as a number if no A to F are neededMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoDEC2HEX,
HEX2BIN,
HEX2OCT.
HEX2OCTHEX2OCT
octal representation of the hexadecimal number xHEX2OCT(x,places)Argumentsx: a hexadecimal number, either as a string or as a number if no A to F are neededplaces: number of digitsDescriptionIf places is given, HEX2OCT pads the result with zeros to achieve exactly places digits. If this is not possible, HEX2OCT returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoOCT2HEX,
HEX2BIN,
HEX2DEC.
INVSUMINVINVSUMINV
the reciprocal of the sum of reciprocals of the arguments
INVSUMINV(x0,x1,…)Argumentsx0: non-negative numberx1: non-negative numberDescriptionINVSUMINV sum calculates the reciprocal (the inverse) of the sum of reciprocals (inverses) of all its arguments.NoteIf any of the arguments is negative, #VALUE! is returned.If any argument is zero, the result is zero.See alsoHARMEAN.
OCT2BINOCT2BIN
binary representation of the octal number xOCT2BIN(x,places)Argumentsx: a octal number, either as a string or as a numberplaces: number of digitsDescriptionIf places is given, OCT2BIN pads the result with zeros to achieve exactly places digits. If this is not possible, OCT2BIN returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBIN2OCT,
OCT2DEC,
OCT2HEX.
OCT2DECOCT2DEC
decimal representation of the octal number xOCT2DEC(x)Argumentsx: a octal number, either as a string or as a numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoDEC2OCT,
OCT2BIN,
OCT2HEX.
OCT2HEXOCT2HEX
hexadecimal representation of the octal number xOCT2HEX(x,places)Argumentsx: a octal number, either as a string or as a numberplaces: number of digitsDescriptionIf places is given, OCT2HEX pads the result with zeros to achieve exactly places digits. If this is not possible, OCT2HEX returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoHEX2OCT,
OCT2BIN,
OCT2DEC.
ErlangDIMCIRCDIMCIRC
number of circuits required
DIMCIRC(traffic,gos)Argumentstraffic: number of callsgos: grade of serviceDescriptionDIMCIRC returns the number of circuits required given traffic calls with grade of service gos.See alsoOFFCAP,
OFFTRAF,
PROBBLOCK.
OFFCAPOFFCAP
traffic capacity
OFFCAP(circuits,gos)Argumentscircuits: number of circuitsgos: grade of serviceDescriptionOFFCAP returns the traffic capacity given circuits circuits with grade of service gos.See alsoDIMCIRC,
OFFTRAF,
PROBBLOCK.
OFFTRAFOFFTRAF
predicted number of offered calls
OFFTRAF(traffic,circuits)Argumentstraffic: number of carried callscircuits: number of circuitsDescriptionOFFTRAF returns the predicted number of offered calls given traffic carried calls (taken from measurements) on circuits circuits.Notetraffic cannot exceed circuits.See alsoPROBBLOCK,
DIMCIRC,
OFFCAP.
PROBBLOCKPROBBLOCK
probability of blocking
PROBBLOCK(traffic,circuits)Argumentstraffic: number of callscircuits: number of circuitsDescriptionPROBBLOCK returns probability of blocking when traffic calls load into circuits circuits.Notetraffic cannot exceed circuits.See alsoOFFTRAF,
DIMCIRC,
OFFCAP.
FinanceACCRINTACCRINT
accrued interest
ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis,calc_method)Argumentsissue: date of issuefirst_interest: date of first interest paymentsettlement: settlement daterate: nominal annual interest ratepar: par value, defaults to $1000frequency: number of interest payments per yearbasis: calendar basis, defaults to 0calc_method: calculation method, defaults to TRUEDescriptionIf first_interest < settlement and calc_method is TRUE, then ACCRINT returns the sum of the interest accrued in all coupon periods from issue date until settlement date.If first_interest < settlement and calc_method is FALSE, then ACCRINT returns the sum of the interest accrued in all coupon periods from first_interest date until settlement date.Otherwise ACCRINT returns the sum of the interest accrued in all coupon periods from issue date until settlement date.Notefrequency must be one of 1, 2 or 4, but the exact value does not affect the result. issue must precede both first_interest and settlement. frequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoACCRINTM.
ACCRINTMACCRINTM
accrued interest
ACCRINTM(issue,maturity,rate,par,basis)Argumentsissue: date of issuematurity: maturity daterate: nominal annual interest ratepar: par valuebasis: calendar basisDescriptionACCRINTM calculates the accrued interest from issue to maturity.Notepar defaults to $1000. If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoACCRINT.
AMORDEGRCAMORDEGRC
depreciation of an asset using French accounting conventions
AMORDEGRC(cost,purchase_date,first_period,salvage,period,rate,basis)Argumentscost: initial cost of assetpurchase_date: date of purchasefirst_period: end of first periodsalvage: value after depreciationperiod: subject periodrate: depreciation ratebasis: calendar basisDescriptionAMORDEGRC calculates the depreciation of an asset using French accounting conventions. Assets purchased in the middle of a period take prorated depreciation into account. This is similar to AMORLINC, except that a depreciation coefficient is applied in the calculation depending on the life of the assets.The depreciation coefficient used is:1.0 for an expected lifetime less than 3 years,1.5 for an expected lifetime of at least 3 years but less than 5 years,2.0 for an expected lifetime of at least 5 years but at most 6 years,2.5 for an expected lifetime of more than 6 years.NoteSpecial depreciation rules are applied for the last two periods resulting in a possible total depreciation exceeding the difference of cost - salvage. Named for AMORtissement DEGRessif Comptabilite. If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoAMORLINC.
AMORLINCAMORLINC
depreciation of an asset using French accounting conventions
AMORLINC(cost,purchase_date,first_period,salvage,period,rate,basis)Argumentscost: initial cost of assetpurchase_date: date of purchasefirst_period: end of first periodsalvage: value after depreciationperiod: subject periodrate: depreciation ratebasis: calendar basisDescriptionAMORLINC calculates the depreciation of an asset using French accounting conventions. Assets purchased in the middle of a period take prorated depreciation into account. NoteNamed for AMORtissement LINeaire Comptabilite. If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoAMORDEGRC.
COUPDAYBSCOUPDAYBS
number of days from coupon period to settlement
COUPDAYBS(settlement,maturity,frequency,basis,eom)Argumentssettlement: settlement datematurity: maturity datefrequency: number of interest payments per yearbasis: calendar basiseom: end-of-month flagDescriptionCOUPDAYBS calculates the number of days from the beginning of the coupon period to the settlement date.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoCOUPDAYS.
COUPDAYSCOUPDAYS
number of days in the coupon period of the settlement date
COUPDAYS(settlement,maturity,frequency,basis,eom)Argumentssettlement: settlement datematurity: maturity datefrequency: number of interest payments per yearbasis: calendar basiseom: end-of-month flagDescriptionCOUPDAYS calculates the number of days in the coupon period of the settlement date.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoCOUPDAYBS,
COUPDAYSNC.
COUPDAYSNCCOUPDAYSNC
number of days from the settlement date to the next coupon period
COUPDAYSNC(settlement,maturity,frequency,basis,eom)Argumentssettlement: settlement datematurity: maturity datefrequency: number of interest payments per yearbasis: calendar basiseom: end-of-month flagDescriptionCOUPDAYSNC calculates number of days from the settlement date to the next coupon period.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoCOUPDAYS,
COUPDAYBS.
COUPNCDCOUPNCD
the next coupon date after settlement
COUPNCD(settlement,maturity,frequency,basis,eom)Argumentssettlement: settlement datematurity: maturity datefrequency: number of interest payments per yearbasis: calendar basiseom: end-of-month flagDescriptionCOUPNCD calculates the coupon date following settlement.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoCOUPPCD,
COUPDAYS,
COUPDAYBS.
COUPNUMCOUPNUM
number of coupons
COUPNUM(settlement,maturity,frequency,basis,eom)Argumentssettlement: settlement datematurity: maturity datefrequency: number of interest payments per yearbasis: calendar basiseom: end-of-month flagDescriptionCOUPNUM calculates the number of coupons to be paid between the settlement and maturity dates, rounded up.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoCOUPNCD,
COUPPCD.
COUPPCDCOUPPCD
the last coupon date before settlement
COUPPCD(settlement,maturity,frequency,basis,eom)Argumentssettlement: settlement datematurity: maturity datefrequency: number of interest payments per yearbasis: calendar basiseom: end-of-month flagDescriptionCOUPPCD calculates the coupon date preceding settlement.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoCOUPNCD,
COUPDAYS,
COUPDAYBS.
CUM_BIV_NORM_DISTCUM_BIV_NORM_DIST
cumulative bivariate normal distribution
CUM_BIV_NORM_DIST(a,b,rho)Argumentsa: limit for first random variableb: limit for second random variablerho: correlation of the two random variablesDescriptionCUM_BIV_NORM_DIST calculates the probability that two standard normal distributed random variables with correlation rho are respectively each less than a and b.CUMIPMTCUMIPMT
cumulative interest payment
CUMIPMT(rate,nper,pv,start_period,end_period,type)Argumentsrate: interest rate per periodnper: number of periodspv: present valuestart_period: first period to accumulate forend_period: last period to accumulate fortype: payment typeDescriptionCUMIPMT calculates the cumulative interest paid on a loan from start_period to end_period.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoIPMT.
CUMPRINCCUMPRINC
cumulative principal
CUMPRINC(rate,nper,pv,start_period,end_period,type)Argumentsrate: interest rate per periodnper: number of periodspv: present valuestart_period: first period to accumulate forend_period: last period to accumulate fortype: payment typeDescriptionCUMPRINC calculates the cumulative principal paid on a loan from start_period to end_period.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoPPMT.
DBDB
depreciation of an asset
DB(cost,salvage,life,period,month)Argumentscost: initial cost of assetsalvage: value after depreciationlife: number of periodsperiod: subject periodmonth: number of months in first year of depreciationDescriptionDB calculates the depreciation of an asset for a given period using the fixed-declining balance method.See alsoDDB,
SLN,
SYD.
DDBDDB
depreciation of an asset
DDB(cost,salvage,life,period,factor)Argumentscost: initial cost of assetsalvage: value after depreciationlife: number of periodsperiod: subject periodfactor: factor at which the balance declinesDescriptionDDB calculates the depreciation of an asset for a given period using the double-declining balance method.See alsoDB,
SLN,
SYD.
DISCDISC
discount rate
DISC(settlement,maturity,par,redemption,basis)Argumentssettlement: settlement datematurity: maturity datepar: price per $100 face valueredemption: amount received at maturitybasis: calendar basisDescriptionDISC calculates the discount rate for a security.Noteredemption is the redemption value per $100 face value. If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoPRICEMAT.
DOLLARDEDOLLARDE
convert to decimal dollar amount
DOLLARDE(fractional_dollar,fraction)Argumentsfractional_dollar: amount to convertfraction: denominatorDescriptionDOLLARDE converts a fractional dollar amount into a decimal amount. This is the inverse of the DOLLARFR function.See alsoDOLLARFR.
DOLLARFRDOLLARFR
convert to dollar fraction
DOLLARFR(decimal_dollar,fraction)Argumentsdecimal_dollar: amount to convertfraction: denominatorDescriptionDOLLARFR converts a decimal dollar amount into a fractional amount which is represented as the digits after the decimal point. For example, 2/8 would be represented as .2 while 3/16 would be represented as .03. This is the inverse of the DOLLARDE function.See alsoDOLLARDE.
DURATIONDURATION
the duration of a security
DURATION(settlement,maturity,coupon,yield,frequency,basis)Argumentssettlement: settlement datematurity: maturity datecoupon: annual coupon rateyield: annual yield of securityfrequency: number of interest payments per yearbasis: calendar basisDescriptionDURATION calculates the duration of a security.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoMDURATION.
EFFECTEFFECT
effective interest rate
EFFECT(rate,nper)Argumentsrate: nominal annual interest ratenper: number of periods used for compoundingDescriptionEFFECT calculates the effective interest rate using the formula (1+rate/nper)^nper-1.See alsoNOMINAL.
EUROEURO
equivalent of 1 EUR
EURO(currency)Argumentscurrency: three-letter currency codeDescriptionEURO calculates the national currency amount corresponding to 1 EUR for any of the national currencies that were replaced by the Euro on its introduction.Notecurrency must be one of ATS (Austria), BEF (Belgium), CYP (Cyprus), DEM (Germany), EEK (Estonia), ESP (Spain), EUR (Euro), FIM (Finland), FRF (France), GRD (Greece), IEP (Ireland), ITL (Italy), LUF (Luxembourg), MTL (Malta), NLG (The Netherlands), PTE (Portugal), SIT (Slovenia), or SKK (Slovakia). This function is not likely to be useful anymore.See alsoEUROCONVERT.
EUROCONVERTEUROCONVERT
pre-Euro amount from one currency to another
EUROCONVERT(n,source,target,full_precision,triangulation_precision)Argumentsn: amountsource: three-letter source currency codetarget: three-letter target currency codefull_precision: whether to provide the full precision; defaults to falsetriangulation_precision: number of digits (at least 3) to be rounded to after conversion of the source currency to euro; defaults to no roundingDescriptionEUROCONVERT converts n units of currency source to currency target. The rates used are the official ones used on the introduction of the Euro.NoteIf full_precision is true, the result is not rounded; if it false the result is rounded to 0 or 2 decimals depending on the target currency; defaults to false. source and target must be one of the currencies listed for the EURO function. This function is not likely to be useful anymore.See alsoEURO.
FVFV
future value
FV(rate,nper,pmt,pv,type)Argumentsrate: effective interest rate per periodnper: number of periodspmt: payment at each periodpv: present valuetype: payment typeDescriptionFV calculates the future value of pv moved nper periods into the future, assuming a periodic payment of pmt and an interest rate of rate per period.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoPV.
FVSCHEDULEFVSCHEDULE
future value
FVSCHEDULE(principal,schedule)Argumentsprincipal: initial valueschedule: range of interest ratesDescriptionFVSCHEDULE calculates the future value of principal after applying a range of interest rates with compounding.See alsoFV.
G_DURATIONG_DURATION
the duration of a investment
G_DURATION(rate,pv,fv)Argumentsrate: effective annual interest ratepv: present valuefv: future valueDescriptionG_DURATION calculates the number of periods needed for an investment to attain a desired value.OpenDocument Format (ODF) CompatibilityG_DURATION is the OpenFormula function PDURATION.See alsoFV,
PV.
INTRATEINTRATE
interest rate
INTRATE(settlement,maturity,investment,redemption,basis)Argumentssettlement: settlement datematurity: maturity dateinvestment: amount paid on settlementredemption: amount received at maturitybasis: calendar basisDescriptionINTRATE calculates the interest of a fully vested security.NoteIf basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoRECEIVED.
IPMTIPMT
interest payment for period
IPMT(rate,per,nper,pv,fv,type)Argumentsrate: effective annual interest rateper: period numbernper: number of periodspv: present valuefv: future valuetype: payment typeDescriptionIPMT calculates the interest part of an annuity's payment for period number per.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoPPMT.
IRRIRR
internal rate of return
IRR(values,guess)Argumentsvalues: cash flowguess: an estimate of what the result should beDescriptionIRR calculates the internal rate of return of a cash flow with periodic payments. values lists the payments (negative values) and receipts (positive values) for each period.NoteThe optional guess is needed because there can be more than one valid result. It defaults to 10%.See alsoXIRR.
ISPMTISPMT
interest payment for period
ISPMT(rate,per,nper,pv)Argumentsrate: effective annual interest rateper: period numbernper: number of periodspv: present valueDescriptionISPMT calculates the interest payment for period number per.See alsoPV.
MDURATIONMDURATION
the Macaulay duration of a security
MDURATION(settlement,maturity,coupon,yield,frequency,basis)Argumentssettlement: settlement datematurity: maturity datecoupon: annual coupon rateyield: annual yield of securityfrequency: number of interest payments per yearbasis: calendar basisDescriptionMDURATION calculates the Macaulay duration of a security.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoDURATION.
MIRRMIRR
modified internal rate of return
MIRR(values,finance_rate,reinvest_rate)Argumentsvalues: cash flowfinance_rate: interest rate for financing costreinvest_rate: interest rate for reinvestmentsDescriptionMIRR calculates the modified internal rate of return of a periodic cash flow.See alsoIRR,
XIRR.
NOMINALNOMINAL
nominal interest rate
NOMINAL(rate,nper)Argumentsrate: effective annual interest ratenper: number of periods used for compoundingDescriptionNOMINAL calculates the nominal interest rate from the effective rate.See alsoEFFECT.
NPERNPER
number of periods
NPER(rate,pmt,pv,fv,type)Argumentsrate: effective annual interest ratepmt: payment at each periodpv: present valuefv: future valuetype: payment typeDescriptionNPER calculates the number of periods of an investment based on periodic constant payments and a constant interest rate.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoPV,
FV.
NPVNPV
net present value
NPV(rate,value1,value2,…)Argumentsrate: effective interest rate per periodvalue1: cash flow for period 1value2: cash flow for period 2DescriptionNPV calculates the net present value of a cash flow.See alsoPV.
ODDFPRICEODDFPRICE
price of a security that has an odd first period
ODDFPRICE(settlement,maturity,issue,first_interest,rate,yield,redemption,frequency,basis)Argumentssettlement: settlement datematurity: maturity dateissue: date of issuefirst_interest: first interest daterate: nominal annual interest rateyield: annual yield of securityredemption: amount received at maturityfrequency: number of interest payments per yearbasis: calendar basisDescriptionODDFPRICE calculates the price per $100 face value of a security that pays periodic interest, but has an odd first period.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoODDLPRICE,
ODDFYIELD.
ODDFYIELDODDFYIELD
yield of a security that has an odd first period
ODDFYIELD(settlement,maturity,issue,first_interest,rate,price,redemption,frequency,basis)Argumentssettlement: settlement datematurity: maturity dateissue: date of issuefirst_interest: first interest daterate: nominal annual interest rateprice: price of securityredemption: amount received at maturityfrequency: number of interest payments per yearbasis: calendar basisDescriptionODDFYIELD calculates the yield of a security that pays periodic interest, but has an odd first period.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoODDFPRICE,
ODDLYIELD.
ODDLPRICEODDLPRICE
price of a security that has an odd last period
ODDLPRICE(settlement,maturity,last_interest,rate,yield,redemption,frequency,basis)Argumentssettlement: settlement datematurity: maturity datelast_interest: last interest daterate: nominal annual interest rateyield: annual yield of securityredemption: amount received at maturityfrequency: number of interest payments per yearbasis: calendar basisDescriptionODDLPRICE calculates the price per $100 face value of a security that pays periodic interest, but has an odd last period.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoYIELD,
DURATION.
ODDLYIELDODDLYIELD
yield of a security that has an odd last period
ODDLYIELD(settlement,maturity,last_interest,rate,price,redemption,frequency,basis)Argumentssettlement: settlement datematurity: maturity datelast_interest: last interest daterate: nominal annual interest rateprice: price of securityredemption: amount received at maturityfrequency: number of interest payments per yearbasis: calendar basisDescriptionODDLYIELD calculates the yield of a security that pays periodic interest, but has an odd last period.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoYIELD,
DURATION.
OPT_2_ASSET_CORRELATIONOPT_2_ASSET_CORRELATION
theoretical price of options on 2 assets with correlation rhoOPT_2_ASSET_CORRELATION(call_put_flag,spot1,spot2,strike1,strike2,time,cost_of_carry1,cost_of_carry2,rate,volatility1,volatility2,rho)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot1: spot price of the underlying asset of the first optionspot2: spot price of the underlying asset of the second optionstrike1: strike prices of the first optionstrike2: strike prices of the second optiontime: time to maturity in yearscost_of_carry1: net cost of holding the underlying asset of the first option (for common stocks, the risk free rate less the dividend yield)cost_of_carry2: net cost of holding the underlying asset of the second option (for common stocks, the risk free rate less the dividend yield)rate: annualized risk-free interest ratevolatility1: annualized volatility in price of the underlying asset of the first optionvolatility2: annualized volatility in price of the underlying asset of the second optionrho: correlation between the two underlying assetsDescriptionOPT_2_ASSET_CORRELATION models the theoretical price of options on 2 assets with correlation rho. The payoff for a call is max(spot2 - strike2,0) if spot1 > strike1 or 0 otherwise. The payoff for a put is max (strike2 - spot2, 0) if spot1 < strike1 or 0 otherwise.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_AMER_EXCHANGEOPT_AMER_EXCHANGE
theoretical price of an American option to exchange assets
OPT_AMER_EXCHANGE(spot1,spot2,qty1,qty2,time,rate,cost_of_carry1,cost_of_carry2,volatility1,volatility2,rho)Argumentsspot1: spot price of asset 1spot2: spot price of asset 1qty1: quantity of asset 1qty2: quantity of asset 2time: time to maturity in yearsrate: annualized risk-free interest ratecost_of_carry1: net cost of holding asset 1 (for common stocks, the risk free rate less the dividend yield)cost_of_carry2: net cost of holding asset 2 (for common stocks, the risk free rate less the dividend yield)volatility1: annualized volatility in price of asset 1volatility2: annualized volatility in price of asset 2rho: correlation between the prices of the two assetsDescriptionOPT_AMER_EXCHANGE models the theoretical price of an American option to exchange one asset with quantity qty2 and spot price spot2 for another with quantity qty1 and spot price spot1.See alsoOPT_EURO_EXCHANGE,
OPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_BAW_AMEROPT_BAW_AMER
theoretical price of an option according to the Barone Adesie & Whaley approximation
OPT_BAW_AMER(call_put_flag,spot,strike,time,rate,cost_of_carry,volatility)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in daysrate: annualized risk-free interest ratecost_of_carry: net cost of holding the underlying assetvolatility: annualized volatility of the assetSee alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_BINOMIALOPT_BINOMIAL
theoretical price of either an American or European style option using a binomial tree
OPT_BINOMIAL(amer_euro_flag,call_put_flag,num_time_steps,spot,strike,time,rate,volatility,cost_of_carry)Argumentsamer_euro_flag: 'a' for an American style option or 'e' for a European style optioncall_put_flag: 'c' for a call and 'p' for a putnum_time_steps: number of time steps used in the valuationspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: annualized risk-free interest ratevolatility: annualized volatility of the assetcost_of_carry: net cost of holding the underlying assetNoteA larger num_time_steps yields greater accuracy but OPT_BINOMIAL is slower to calculate.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_BJER_STENSOPT_BJER_STENS
theoretical price of American options according to the Bjerksund & Stensland approximation technique
OPT_BJER_STENS(call_put_flag,spot,strike,time,rate,volatility,cost_of_carry)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in daysrate: annualized risk-free interest ratevolatility: annualized volatility of the assetcost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_BSOPT_BS
price of a European option
OPT_BS(call_put_flag,spot,strike,time,rate,volatility,cost_of_carry)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise datecost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0DescriptionOPT_BS uses the Black-Scholes model to calculate the price of a European option struck at strike on an asset with spot price spot.NoteThe returned value will be expressed in the same units as strike and spot.See alsoOPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_VEGA,
OPT_BS_GAMMA.
OPT_BS_CARRYCOSTOPT_BS_CARRYCOST
elasticity of a European option
OPT_BS_CARRYCOST(call_put_flag,spot,strike,time,rate,volatility,cost_of_carry)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise datecost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0DescriptionOPT_BS_CARRYCOST uses the Black-Scholes model to calculate the 'elasticity' of a European option struck at strike on an asset with spot price spot. The elasticity of an option is the rate of change of its price with respect to its cost_of_carry.NoteElasticity is expressed as the rate of change of the option value, per 100% volatility.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_BS_DELTAOPT_BS_DELTA
delta of a European option
OPT_BS_DELTA(call_put_flag,spot,strike,time,rate,volatility,cost_of_carry)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise datecost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0DescriptionOPT_BS_DELTA uses the Black-Scholes model to calculate the 'delta' of a European option struck at strike on an asset with spot price spot.NoteThe returned value will be expressed in the same units as strike and spot.See alsoOPT_BS,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_VEGA,
OPT_BS_GAMMA.
OPT_BS_GAMMAOPT_BS_GAMMA
gamma of a European option
OPT_BS_GAMMA(spot,strike,time,rate,volatility,cost_of_carry)Argumentsspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise datecost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0DescriptionOPT_BS_GAMMA uses the Black-Scholes model to calculate the 'gamma' of a European option struck at strike on an asset with spot price spot. The gamma of an option is the second derivative of its price with respect to the price of the underlying asset.NoteGamma is expressed as the rate of change of delta per unit change in spot. Gamma is the same for calls and puts.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_VEGA.
OPT_BS_RHOOPT_BS_RHO
rho of a European option
OPT_BS_RHO(call_put_flag,spot,strike,time,rate,volatility,cost_of_carry)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise datecost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0DescriptionOPT_BS_RHO uses the Black-Scholes model to calculate the 'rho' of a European option struck at strike on an asset with spot price spot. The rho of an option is the rate of change of its price with respect to the risk free interest rate.NoteRho is expressed as the rate of change of the option value, per 100% change in rate.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_THETA,
OPT_BS_VEGA,
OPT_BS_GAMMA.
OPT_BS_THETAOPT_BS_THETA
theta of a European option
OPT_BS_THETA(call_put_flag,spot,strike,time,rate,volatility,cost_of_carry)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise datecost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0DescriptionOPT_BS_THETA uses the Black-Scholes model to calculate the 'theta' of a European option struck at strike on an asset with spot price spot. The theta of an option is the rate of change of its price with respect to time to expiry.NoteTheta is expressed as the negative of the rate of change of the option value, per 365.25 days.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_VEGA,
OPT_BS_GAMMA.
OPT_BS_VEGAOPT_BS_VEGA
vega of a European option
OPT_BS_VEGA(spot,strike,time,rate,volatility,cost_of_carry)Argumentsspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise datecost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0DescriptionOPT_BS_VEGA uses the Black-Scholes model to calculate the 'vega' of a European option struck at strike on an asset with spot price spot. The vega of an option is the rate of change of its price with respect to volatility.NoteVega is the same for calls and puts. Vega is expressed as the rate of change of option value, per 100% volatility.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_COMPLEX_CHOOSEROPT_COMPLEX_CHOOSER
theoretical price of a complex chooser option
OPT_COMPLEX_CHOOSER(spot,strike_call,strike_put,time,time_call,time_put,rate,cost_of_carry,volatility)Argumentsspot: spot pricestrike_call: strike price, if exercised as a call optionstrike_put: strike price, if exercised as a put optiontime: time in years until the holder chooses a put or a call optiontime_call: time in years to maturity of the call option if chosentime_put: time in years to maturity of the put option if chosenrate: annualized risk-free interest ratecost_of_carry: net cost of holding the underlying assetvolatility: annualized volatility of the asset in percent for the period through to the exercise dateSee alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_EURO_EXCHANGEOPT_EURO_EXCHANGE
theoretical price of a European option to exchange assets
OPT_EURO_EXCHANGE(spot1,spot2,qty1,qty2,time,rate,cost_of_carry1,cost_of_carry2,volatility1,volatility2,rho)Argumentsspot1: spot price of asset 1spot2: spot price of asset 1qty1: quantity of asset 1qty2: quantity of asset 2time: time to maturity in yearsrate: annualized risk-free interest ratecost_of_carry1: net cost of holding asset 1 (for common stocks, the risk free rate less the dividend yield)cost_of_carry2: net cost of holding asset 2 (for common stocks, the risk free rate less the dividend yield)volatility1: annualized volatility in price of asset 1volatility2: annualized volatility in price of asset 2rho: correlation between the prices of the two assetsDescriptionOPT_EURO_EXCHANGE models the theoretical price of a European option to exchange one asset with quantity qty2 and spot price spot2 for another with quantity qty1 and spot price spot1.See alsoOPT_AMER_EXCHANGE,
OPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_EXECOPT_EXEC
theoretical price of executive stock options
OPT_EXEC(call_put_flag,spot,strike,time,rate,volatility,cost_of_carry,lambda)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in daysrate: annualized risk-free interest ratevolatility: annualized volatility of the assetcost_of_carry: net cost of holding the underlying assetlambda: jump rate for executivesNoteThe model assumes executives forfeit their options if they leave the company.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_EXTENDIBLE_WRITEROPT_EXTENDIBLE_WRITER
theoretical price of extendible writer options
OPT_EXTENDIBLE_WRITER(call_put_flag,spot,strike1,strike2,time1,time2,rate,cost_of_carry,volatility)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike1: strike price at which the option is struckstrike2: strike price at which the option is re-struck if out of the money at time1time1: initial maturity of the option in yearstime2: extended maturity in years if chosenrate: annualized risk-free interest ratecost_of_carry: net cost of holding the underlying assetvolatility: annualized volatility of the assetDescriptionOPT_EXTENDIBLE_WRITER models the theoretical price of extendible writer options. These are options that have their maturity extended to time2 if the option is out of the money at time1.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_FIXED_STRK_LKBKOPT_FIXED_STRK_LKBK
theoretical price of a fixed-strike lookback option
OPT_FIXED_STRK_LKBK(call_put_flag,spot,spot_min,spot_max,strike,time,rate,cost_of_carry,volatility)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricespot_min: minimum spot price of the underlying asset so far observedspot_max: maximum spot price of the underlying asset so far observedstrike: strike pricetime: time to maturity in yearsrate: annualized risk-free interest ratecost_of_carry: net cost of holding the underlying assetvolatility: annualized volatility of the assetDescriptionOPT_FIXED_STRK_LKBK determines the theoretical price of a fixed-strike lookback option where the holder of the option may exercise on expiry at the most favourable price observed during the options life of the underlying asset.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_FLOAT_STRK_LKBKOPT_FLOAT_STRK_LKBK
theoretical price of floating-strike lookback option
OPT_FLOAT_STRK_LKBK(call_put_flag,spot,spot_min,spot_max,time,rate,cost_of_carry,volatility)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricespot_min: minimum spot price of the underlying asset so far observedspot_max: maximum spot price of the underlying asset so far observedtime: time to maturity in yearsrate: annualized risk-free interest ratecost_of_carry: net cost of holding the underlying assetvolatility: annualized volatility of the assetDescriptionOPT_FLOAT_STRK_LKBK determines the theoretical price of a floating-strike lookback option where the holder of the option may exercise on expiry at the most favourable price observed during the options life of the underlying asset.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_FORWARD_STARTOPT_FORWARD_START
theoretical price of forward start options
OPT_FORWARD_START(call_put_flag,spot,alpha,time_start,time,rate,volatility,cost_of_carry)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricealpha: fraction setting the strike price at the future date time_starttime_start: time until the option starts in daystime: time to maturity in daysrate: annualized risk-free interest ratevolatility: annualized volatility of the assetcost_of_carry: net cost of holding the underlying assetSee alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_FRENCHOPT_FRENCH
theoretical price of a European option adjusted for trading day volatility
OPT_FRENCH(call_put_flag,spot,strike,time,ttime,rate,volatility,cost_of_carry)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: ratio of the number of calendar days to exercise and the number of calendar days in the yearttime: ratio of the number of trading days to exercise and the number of trading days in the yearrate: risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise datecost_of_carry: net cost of holding the underlying asset (for common stocks, the risk free rate less the dividend yield), defaults to 0DescriptionOPT_FRENCH values the theoretical price of a European option adjusted for trading day volatility, struck at strike on an asset with spot price spot.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_GARMAN_KOHLHAGENOPT_GARMAN_KOHLHAGEN
theoretical price of a European currency option
OPT_GARMAN_KOHLHAGEN(call_put_flag,spot,strike,time,domestic_rate,foreign_rate,volatility)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: number of days to exercisedomestic_rate: domestic risk-free interest rate to the exercise date in percentforeign_rate: foreign risk-free interest rate to the exercise date in percentvolatility: annualized volatility of the asset in percent for the period through to the exercise dateDescriptionOPT_GARMAN_KOHLHAGEN values the theoretical price of a European currency option struck at strike on an asset with spot price spot.See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_JUMP_DIFFOPT_JUMP_DIFF
theoretical price of an option according to the Jump Diffusion process
OPT_JUMP_DIFF(call_put_flag,spot,strike,time,rate,volatility,lambda,gamma)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime: time to maturity in yearsrate: the annualized rate of interestvolatility: annualized volatility of the asset in percent for the period through to the exercise datelambda: expected number of 'jumps' per yeargamma: proportion of volatility explained by the 'jumps'DescriptionOPT_JUMP_DIFF models the theoretical price of an option according to the Jump Diffusion process (Merton).See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_MILTERSEN_SCHWARTZOPT_MILTERSEN_SCHWARTZ
theoretical price of options on commodities futures according to Miltersen & Schwartz
OPT_MILTERSEN_SCHWARTZ(call_put_flag,p_t,f_t,strike,t1,t2,v_s,v_e,v_f,rho_se,rho_sf,rho_ef,kappa_e,kappa_f)Argumentscall_put_flag: 'c' for a call and 'p' for a putp_t: zero coupon bond with expiry at option maturityf_t: futures pricestrike: strike pricet1: time to maturity of the optiont2: time to maturity of the underlying commodity futures contractv_s: volatility of the spot commodity pricev_e: volatility of the future convenience yieldv_f: volatility of the forward rate of interestrho_se: correlation between the spot commodity price and the convenience yieldrho_sf: correlation between the spot commodity price and the forward interest raterho_ef: correlation between the forward interest rate and the convenience yieldkappa_e: speed of mean reversion of the convenience yieldkappa_f: speed of mean reversion of the forward interest rateSee alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_ON_OPTIONSOPT_ON_OPTIONS
theoretical price of options on options
OPT_ON_OPTIONS(type_flag,spot,strike1,strike2,time1,time2,rate,cost_of_carry,volatility)Argumentstype_flag: 'cc' for calls on calls, 'cp' for calls on puts, and so on for 'pc', and 'pp'spot: spot pricestrike1: strike price at which the option being valued is struckstrike2: strike price at which the underlying option is strucktime1: time in years to maturity of the optiontime2: time in years to the maturity of the underlying optionrate: annualized risk-free interest ratecost_of_carry: net cost of holding the underlying asset of the underlying optionvolatility: annualized volatility in price of the underlying asset of the underlying optionNoteFor common stocks, cost_of_carry is the risk free rate less the dividend yield. time2 ≥ time1See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_RGWOPT_RGW
theoretical price of an American option according to the Roll-Geske-Whaley approximation
OPT_RGW(spot,strike,time_payout,time_exp,rate,d,volatility)Argumentsspot: spot pricestrike: strike pricetime_payout: time to dividend payouttime_exp: time to expirationrate: annualized interest rated: amount of the dividend to be paid expressed in currencyvolatility: annualized volatility of the asset in percent for the period through to the exercise dateSee alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_SIMPLE_CHOOSEROPT_SIMPLE_CHOOSER
theoretical price of a simple chooser option
OPT_SIMPLE_CHOOSER(call_put_flag,spot,strike,time1,time2,cost_of_carry,volatility)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricetime1: time in years until the holder chooses a put or a call optiontime2: time in years until the chosen option expirescost_of_carry: net cost of holding the underlying assetvolatility: annualized volatility of the assetSee alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_SPREAD_APPROXOPT_SPREAD_APPROX
theoretical price of a European option on the spread between two futures contracts
OPT_SPREAD_APPROX(call_put_flag,fut_price1,fut_price2,strike,time,rate,volatility1,volatility2,rho)Argumentscall_put_flag: 'c' for a call and 'p' for a putfut_price1: price of the first futures contractfut_price2: price of the second futures contractstrike: strike pricetime: time to maturity in yearsrate: annualized risk-free interest ratevolatility1: annualized volatility in price of the first underlying futures contractvolatility2: annualized volatility in price of the second underlying futures contractrho: correlation between the two futures contractsSee alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
OPT_TIME_SWITCHOPT_TIME_SWITCH
theoretical price of time switch options
OPT_TIME_SWITCH(call_put_flag,spot,strike,a,time,m,dt,rate,cost_of_carry,volatility)Argumentscall_put_flag: 'c' for a call and 'p' for a putspot: spot pricestrike: strike pricea: amount received for each time periodtime: time to maturity in yearsm: number of time units the option has already met the conditiondt: agreed upon discrete time period expressed as a fraction of a yearrate: annualized risk-free interest ratecost_of_carry: net cost of holding the underlying assetvolatility: annualized volatility of the assetDescriptionOPT_TIME_SWITCH models the theoretical price of time switch options. (Pechtl 1995). The holder receives a * dt for each period that the asset price was greater than strike (for a call) or below it (for a put).See alsoOPT_BS,
OPT_BS_DELTA,
OPT_BS_RHO,
OPT_BS_THETA,
OPT_BS_GAMMA.
PMTPMT
payment for annuity
PMT(rate,nper,pv,fv,type)Argumentsrate: effective annual interest ratenper: number of periodspv: present valuefv: future valuetype: payment typeDescriptionPMT calculates the payment amount for an annuity.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoPV,
FV,
RATE,
ISPMT.
PPMTPPMT
interest payment for period
PPMT(rate,per,nper,pv,fv,type)Argumentsrate: effective annual interest rateper: period numbernper: number of periodspv: present valuefv: future valuetype: payment typeDescriptionPPMT calculates the principal part of an annuity's payment for period number per.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoIPMT.
PRICEPRICE
price of a security
PRICE(settlement,maturity,rate,yield,redemption,frequency,basis)Argumentssettlement: settlement datematurity: maturity daterate: nominal annual interest rateyield: annual yield of securityredemption: amount received at maturityfrequency: number of interest payments per yearbasis: calendar basisDescriptionPRICE calculates the price per $100 face value of a security that pays periodic interest.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoYIELD,
DURATION.
PRICEDISCPRICEDISC
discounted price
PRICEDISC(settlement,maturity,discount,redemption,basis)Argumentssettlement: settlement datematurity: maturity datediscount: annual rate at which to discountredemption: amount received at maturitybasis: calendar basisDescriptionPRICEDISC calculates the price per $100 face value of a bond that does not pay interest at maturity.NoteIf basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoPRICEMAT.
PRICEMATPRICEMAT
price at maturity
PRICEMAT(settlement,maturity,issue,discount,yield,basis)Argumentssettlement: settlement datematurity: maturity dateissue: date of issuediscount: annual rate at which to discountyield: annual yield of securitybasis: calendar basisDescriptionPRICEMAT calculates the price per $100 face value of a bond that pays interest at maturity.NoteIf basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoPRICEDISC.
PVPV
present value
PV(rate,nper,pmt,fv,type)Argumentsrate: effective interest rate per periodnper: number of periodspmt: payment at each periodfv: future valuetype: payment typeDescriptionPV calculates the present value of fv which is nper periods into the future, assuming a periodic payment of pmt and an interest rate of rate per period.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoFV.
RATERATE
rate of investment
RATE(nper,pmt,pv,fv,type,guess)Argumentsnper: number of periodspmt: payment at each periodpv: present valuefv: future valuetype: payment typeguess: an estimate of what the result should beDescriptionRATE calculates the rate of return.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period. The optional guess is needed because there can be more than one valid result. It defaults to 10%.See alsoPV,
FV.
RECEIVEDRECEIVED
amount to be received at maturity
RECEIVED(settlement,maturity,investment,rate,basis)Argumentssettlement: settlement datematurity: maturity dateinvestment: amount paid on settlementrate: nominal annual interest ratebasis: calendar basisDescriptionRECEIVED calculates the amount to be received when a security matures.NoteIf basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoINTRATE.
RRIRRI
equivalent interest rate for an investment increasing in value
RRI(p,pv,fv)Argumentsp: number of periodspv: present valuefv: future valueDescriptionRRI determines an equivalent interest rate for an investment that increases in value. The interest is compounded after each complete period.NoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period. Note that p need not be an integer but for fractional value the calculated rate is only approximate.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoPV,
FV,
RATE.
SLNSLN
depreciation of an asset
SLN(cost,salvage,life)Argumentscost: initial cost of assetsalvage: value after depreciationlife: number of periodsDescriptionSLN calculates the depreciation of an asset using the straight-line method.See alsoDB,
DDB,
SYD.
SYDSYD
sum-of-years depreciation
SYD(cost,salvage,life,period)Argumentscost: initial cost of assetsalvage: value after depreciationlife: number of periodsperiod: subject periodDescriptionSYD calculates the depreciation of an asset using the sum-of-years method.See alsoDB,
DDB,
SLN.
TBILLEQTBILLEQ
bond-equivalent yield for a treasury bill
TBILLEQ(settlement,maturity,discount)Argumentssettlement: settlement datematurity: maturity datediscount: annual rate at which to discountDescriptionTBILLEQ calculates the bond-equivalent yield for a treasury bill.See alsoTBILLPRICE,
TBILLYIELD.
TBILLPRICETBILLPRICE
price of a treasury bill
TBILLPRICE(settlement,maturity,discount)Argumentssettlement: settlement datematurity: maturity datediscount: annual rate at which to discountDescriptionTBILLPRICE calculates the price per $100 face value for a treasury bill.See alsoTBILLEQ,
TBILLYIELD.
TBILLYIELDTBILLYIELD
yield of a treasury bill
TBILLYIELD(settlement,maturity,price)Argumentssettlement: settlement datematurity: maturity dateprice: priceDescriptionTBILLYIELD calculates the yield of a treasury bill.See alsoTBILLEQ,
TBILLPRICE.
VDBVDB
depreciation of an asset
VDB(cost,salvage,life,start_period,end_period,factor,no_switch)Argumentscost: initial cost of assetsalvage: value after depreciationlife: number of periodsstart_period: first period to accumulate forend_period: last period to accumulate forfactor: factor at which the balance declinesno_switch: do not switch to straight-line depreciationDescriptionVDB calculates the depreciation of an asset for a given period range using the variable-rate declining balance method.NoteIf no_switch is FALSE, the calculation switches to straight-line depreciation when depreciation is greater than the declining balance calculation.See alsoDB,
DDB.
XIRRXIRR
internal rate of return
XIRR(values,dates,guess)Argumentsvalues: cash flowdates: dates of cash flowguess: an estimate of what the result should beDescriptionXIRR calculates the annualized internal rate of return of a cash flow at arbitrary points in time. values lists the payments (negative values) and receipts (positive values) with one value for each entry in dates.NoteThe optional guess is needed because there can be more than one valid result. It defaults to 10%.See alsoIRR.
XNPVXNPV
net present value
XNPV(rate,values,dates)Argumentsrate: effective annual interest ratevalues: cash flowdates: dates of cash flowDescriptionXNPV calculates the net present value of a cash flow at irregular timesNoteIf type is 0, the default, payment is at the end of each period. If type is 1, payment is at the beginning of each period.See alsoNPV.
YIELDYIELD
yield of a security
YIELD(settlement,maturity,rate,price,redemption,frequency,basis)Argumentssettlement: settlement datematurity: maturity daterate: nominal annual interest rateprice: price of securityredemption: amount received at maturityfrequency: number of interest payments per yearbasis: calendar basisDescriptionYIELD calculates the yield of a security that pays periodic interest.Notefrequency may be 1 (annual), 2 (semi-annual), or 4 (quarterly). If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoPRICE,
DURATION.
YIELDDISCYIELDDISC
yield of a discounted security
YIELDDISC(settlement,maturity,price,redemption,basis)Argumentssettlement: settlement datematurity: maturity dateprice: price of securityredemption: amount received at maturitybasis: calendar basisDescriptionYIELDDISC calculates the yield of a discounted security.NoteIf basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoPRICE,
DURATION.
YIELDMATYIELDMAT
yield of a security
YIELDMAT(settlement,maturity,issue,rate,price,basis)Argumentssettlement: settlement datematurity: maturity dateissue: date of issuerate: nominal annual interest rateprice: price of securitybasis: calendar basisDescriptionYIELDMAT calculates the yield of a security for which the interest is paid at maturity date.NoteIf basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.See alsoYIELDDISC,
YIELD.
GnumericGNUMERIC_VERSIONGNUMERIC_VERSION
the current version of Gnumeric
GNUMERIC_VERSION()DescriptionGNUMERIC_VERSION returns the version of gnumeric as a string.InformationCELLCELL
information of type about cellCELL(type,cell)Argumentstype: string specifying the type of information requestedcell: cell referenceDescriptiontype specifies the type of information you want to obtain: address Returns the given cell reference as text. col Returns the number of the column in cell. color Returns 0. contents Returns the contents of the cell in cell. column Returns the number of the column in cell. columnwidth Returns the column width. coord Returns the absolute address of cell. datatype same as type filename Returns the name of the file of cell. format Returns the code of the format of the cell. formulatype same as type locked Returns 1 if cell is locked. parentheses Returns 1 if cell contains a negative value and its format displays it with parentheses. prefix Returns a character indicating the horizontal alignment of cell. prefixcharacter same as prefix protect Returns 1 if cell is locked. row Returns the number of the row in cell. sheetname Returns the name of the sheet of cell. type Returns "l" if cell contains a string, "v" if it contains some other value, and "b" if cell is blank. value Returns the contents of the cell in cell. width Returns the column width.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoINDIRECT.
COUNTBLANKCOUNTBLANK
the number of blank cells in rangeCOUNTBLANK(range)Argumentsrange: a cell rangeMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCOUNT.
ERRORERROR
the error with the given nameERROR(name)Argumentsname: stringSee alsoISERROR.
ERROR.TYPEERROR.TYPE
the type of errorERROR.TYPE(error)Argumentserror: an errorDescriptionERROR.TYPE returns an error number corresponding to the given error value. The error numbers for error values are: #DIV/0! 2 #VALUE! 3 #REF! 4 #NAME? 5 #NUM! 6 #N/A 7Microsoft Excel CompatibilityThis function is Excel compatible.See alsoISERROR.
EXPRESSIONEXPRESSION
expression in cell as a string
EXPRESSION(cell)Argumentscell: a cell referenceNoteIf cell contains no expression, EXPRESSION returns empty.See alsoTEXT.
GET.FORMULAGET.FORMULA
the formula in cell as a string
GET.FORMULA(cell)Argumentscell: the referenced cellOpenDocument Format (ODF) CompatibilityGET.FORMULA is the OpenFormula function FORMULA.See alsoEXPRESSION,
ISFORMULA.
GET.LINKGET.LINK
the target of the hyperlink attached to cell as a string
GET.LINK(cell)Argumentscell: the referenced cellNoteThe value return is not updated automatically when the link attached to cell changes but requires a recalculation.See alsoHYPERLINK.
GETENVGETENV
the value of execution environment variable nameGETENV(name)Argumentsname: the name of the environment variableNoteIf a variable called name does not exist, #N/A! will be returned. Variable names are case sensitive.INFOINFO
information about the current operating environment according to typeINFO(type)Argumentstype: string giving the type of information requestedDescriptionINFO returns information about the current operating environment according to type: memavail Returns the amount of memory available, bytes. memused Returns the amount of memory used (bytes). numfile Returns the number of active worksheets. osversion Returns the operating system version. recalc Returns the recalculation mode (automatic). release Returns the version of Gnumeric as text. system Returns the name of the environment. totmem Returns the amount of total memory available.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoCELL.
ISBLANKISBLANK
TRUE if value is blank
ISBLANK(value)Argumentsvalue: a valueDescriptionThis function checks if a value is blank. Empty cells are blank, but empty strings are not.Microsoft Excel CompatibilityThis function is Excel compatible.ISERRISERR
TRUE if value is any error value except #N/A
ISERR(value)Argumentsvalue: a valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoISERROR.
ISERRORISERROR
TRUE if value is any error value
ISERROR(value)Argumentsvalue: a valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoISERR,
ISNA.
ISEVENISEVEN
TRUE if n is even
ISEVEN(n)Argumentsn: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoISODD.
ISFORMULAISFORMULA
TRUE if cell contains a formula
ISFORMULA(cell)Argumentscell: the referenced cellOpenDocument Format (ODF) CompatibilityISFORMULA is OpenFormula compatible.See alsoGET.FORMULA.
ISLOGICALISLOGICAL
TRUE if value is a logical value
ISLOGICAL(value)Argumentsvalue: a valueDescriptionThis function checks if a value is either TRUE or FALSE.Microsoft Excel CompatibilityThis function is Excel compatible.ISNAISNA
TRUE if value is the #N/A error value
ISNA(value)Argumentsvalue: a valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoNA.
ISNONTEXTISNONTEXT
TRUE if value is not text
ISNONTEXT(value)Argumentsvalue: a valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoISTEXT.
ISNUMBERISNUMBER
TRUE if value is a number
ISNUMBER(value)Argumentsvalue: a valueDescriptionThis function checks if a value is a number. Neither TRUE nor FALSE are numbers for this purpose.Microsoft Excel CompatibilityThis function is Excel compatible.ISODDISODD
TRUE if n is odd
ISODD(n)Argumentsn: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoISEVEN.
ISREFISREF
TRUE if value is a reference
ISREF(value,…)Argumentsvalue: a valueDescriptionThis function checks if a value is a cell reference.Microsoft Excel CompatibilityThis function is Excel compatible.ISTEXTISTEXT
TRUE if value is text
ISTEXT(value)Argumentsvalue: a valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoISNONTEXT.
NNtext converted to a number
N(text)Argumentstext: stringNoteIf text contains non-numerical text, 0 is returned.Microsoft Excel CompatibilityThis function is Excel compatible.NANA
the error value #N/A
NA()Microsoft Excel CompatibilityThis function is Excel compatible.See alsoISNA.
TYPETYPE
a number indicating the data type of valueTYPE(value)Argumentsvalue: a valueDescriptionTYPE returns a number indicating the data type of value:1 = number2 = text4 = boolean16 = error64 = arrayMicrosoft Excel CompatibilityThis function is Excel compatible.LogicANDAND
logical conjunction
AND(b0,b1,…)Argumentsb0: logical valueb1: logical valueDescriptionAND calculates the logical conjunction of its arguments b0,b1,...NoteIf an argument is numerical, zero is considered FALSE and anything else TRUE. Strings and empty values are ignored. If no logical values are provided, then the error #VALUE! is returned. This function is strict: if any argument is an error, the result will be the first such error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoOR,
NOT,
IF.
FALSEFALSE
the value FALSEFALSE()DescriptionFALSE returns the value FALSE.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoTRUE,
IF.
IFIF
conditional expression
IF(cond,trueval,falseval)Argumentscond: conditiontrueval: value to use if condition is truefalseval: value to use if condition is falseDescriptionThis function first evaluates the condition. If the result is true, it will then evaluate and return the second argument. Otherwise, it will evaluate and return the last argument.See alsoAND,
OR,
XOR,
NOT,
IFERROR.
IFERRORIFERROR
test for error
IFERROR(x,y)Argumentsx: value to test for errory: alternate valueDescriptionThis function returns the first value, unless that is an error, in which case it returns the second.See alsoIF,
ISERROR.
IFNAIFNA
test for #NA! error
IFNA(x,y)Argumentsx: value to test for #NA! errory: alternate valueDescriptionThis function returns the first value, unless that is #NA!, in which case it returns the second.See alsoIF,
ISERROR.
NOTNOT
logical negation
NOT(b)Argumentsb: logical valueDescriptionNOT calculates the logical negation of its argument.NoteIf the argument is numerical, zero is considered FALSE and anything else TRUE. Strings and empty values are ignored.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAND,
OR,
IF.
OROR
logical disjunction
OR(b0,b1,…)Argumentsb0: logical valueb1: logical valueDescriptionOR calculates the logical disjunction of its arguments b0,b1,...NoteIf an argument is numerical, zero is considered FALSE and anything else TRUE. Strings and empty values are ignored. If no logical values are provided, then the error #VALUE! is returned. This function is strict: if any argument is an error, the result will be the first such error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAND,
XOR,
NOT,
IF.
TRUETRUE
the value TRUETRUE()DescriptionTRUE returns the value TRUE.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoFALSE,
IF.
XORXOR
logical exclusive disjunction
XOR(b0,b1,…)Argumentsb0: logical valueb1: logical valueDescriptionXOR calculates the logical exclusive disjunction of its arguments b0,b1,...NoteIf an argument is numerical, zero is considered FALSE and anything else TRUE. Strings and empty values are ignored. If no logical values are provided, then the error #VALUE! is returned. This function is strict: if any argument is an error, the result will be the first such error.See alsoOR,
AND,
NOT,
IF.
LookupADDRESSADDRESS
cell address as text
ADDRESS(row_num,col_num,abs_num,a1,text)Argumentsrow_num: row numbercol_num: column numberabs_num: 1 for an absolute, 2 for a row absolute and column relative, 3 for a row relative and column absolute, and 4 for a relative reference; defaults to 1a1: if TRUE, an A1-style reference is provided, otherwise an R1C1-style reference; defaults to TRUEtext: name of the worksheet, defaults to no sheetNoteIf row_num or col_num is less than one, ADDRESS returns #VALUE! If abs_num is greater than 4 ADDRESS returns #VALUE!See alsoCOLUMNNUMBER.
AREASAREAS
number of areas in referenceAREAS(reference,…)Argumentsreference: rangeSee alsoADDRESS,
INDEX,
INDIRECT,
OFFSET.
ARRAYARRAY
vertical array of the arguments
ARRAY(v,…)Argumentsv: valueSee alsoTRANSPOSE.
CHOOSECHOOSE
the (index+1)th argument
CHOOSE(index,value1,value2,…)Argumentsindex: positive numbervalue1: first valuevalue2: second valueDescriptionCHOOSE returns its (index+1)th argument.Noteindex is truncated to an integer. If index < 1 or the truncated index > number of values, CHOOSE returns #VALUE!See alsoIF.
COLUMNCOLUMN
vector of column numbers
COLUMN(x)Argumentsx: reference, defaults to the position of the current expressionDescriptionCOLUMN function returns a Nx1 array containing the sequence of integers from the first column to the last column of x.NoteIf x is neither an array nor a reference nor a range, returns #VALUE!See alsoCOLUMNS,
ROW,
ROWS.
COLUMNNUMBERCOLUMNNUMBER
column number for the given column called nameCOLUMNNUMBER(name)Argumentsname: column name such as "IV"NoteIf name is invalid, COLUMNNUMBER returns #VALUE!See alsoADDRESS.
COLUMNSCOLUMNS
number of columns in referenceCOLUMNS(reference)Argumentsreference: array or areaNoteIf reference is neither an array nor a reference nor a range, COLUMNS returns #VALUE!See alsoCOLUMN,
ROW,
ROWS.
HLOOKUPHLOOKUP
search the first row of range for valueHLOOKUP(value,range,row,approximate,as_index)Argumentsvalue: search valuerange: range to searchrow: 1-based row offset indicating the return values approximate: if false, an exact match of value must be found; defaults to TRUEas_index: if true, the 0-based column offset is returned; defaults to FALSEDescriptionHLOOKUP function finds the row in range that has a first cell similar to value. If approximate is not true it finds the column with an exact equality. If approximate is true, it finds the last column with first value less than or equal to value. If as_index is true the 0-based column offset is returned.NoteIf approximate is true, then the values must be sorted in order of ascending value. HLOOKUP returns #REF! if row falls outside range.See alsoVLOOKUP.
HYPERLINKHYPERLINK
second or first arguments
HYPERLINK(link_location,label)Argumentslink_location: stringlabel: string, optionalDescriptionHYPERLINK function currently returns its 2nd argument, or if that is omitted the 1st argument.INDEXINDEX
reference to a cell in the given arrayINDEX(array,row,col,area)Argumentsarray: cell or inline arrayrow: desired row, defaults to 1col: desired column, defaults to 1area: from which area to select a cell, defaults to 1DescriptionINDEX gives a reference to a cell in the given array. The cell is selected by row and col, which count the rows and columns in the array.NoteIf the reference falls outside the range of array, INDEX returns #REF!INDIRECTINDIRECT
contents of the cell pointed to by the ref_text string
INDIRECT(ref_text,format)Argumentsref_text: textual referenceformat: if true, ref_text is given in A1-style, otherwise it is given in R1C1 style; defaults to trueNoteIf ref_text is not a valid reference in the style determined by format, INDIRECT returns #REF!See alsoAREAS,
INDEX,
CELL.
LOOKUPLOOKUP
contents of vector2 at the corresponding location to value in vector1LOOKUP(value,vector1,vector2)Argumentsvalue: value to look upvector1: range to search:vector2: range of return valuesDescriptionIf vector1 has more rows than columns, LOOKUP searches the first row of vector1, otherwise the first column. If vector2 is omitted the return value is taken from the last row or column of vector1.NoteIf LOOKUP can't find value it uses the largest value less than value. The data must be sorted. If value is smaller than the first value it returns #N/A. If the corresponding location does not exist in vector2, it returns #N/A.See alsoVLOOKUP,
HLOOKUP.
MATCHMATCH
the index of seek in vectorMATCH(seek,vector,type)Argumentsseek: value to findvector: n by 1 or 1 by n range to be searchedtype: +1 (the default) to find the largest value ≤ seek, 0 to find the first value = seek, or-1 to find the smallest value ≥ seekDescriptionMATCH searches vector for seek and returns the 1-based index.Note For type = -1 the data must be sorted in descending order; for type = +1 the data must be sorted in ascending order. If seek could not be found, #N/A is returned. If vector is neither n by 1 nor 1 by n, #N/A is returned.See alsoLOOKUP.
OFFSETOFFSET
an offset cell range
OFFSET(range,row,col,height,width)Argumentsrange: reference or rangerow: number of rows to offset rangecol: number of columns to offset rangeheight: height of the offset range, defaults to height of rangewidth: width of the offset range, defaults to width of rangeDescriptionOFFSET returns the cell range starting at offset (row,col) from range of height height and width width.NoteIf range is neither a reference nor a range, OFFSET returns #VALUE!See alsoCOLUMN,
COLUMNS,
ROWS,
INDEX,
INDIRECT,
ADDRESS.
ROWROW
vector of row numbers
ROW(x)Argumentsx: reference, defaults to the position of the current expressionDescriptionROW function returns a 1xN array containing the sequence of integers from the first row to the last row of x.NoteIf x is neither an array nor a reference nor a range, returns #VALUE!See alsoCOLUMN,
COLUMNS,
ROWS.
ROWSROWS
number of rows in referenceROWS(reference)Argumentsreference: array, reference, or rangeNoteIf reference is neither an array nor a reference nor a range, ROWS returns #VALUE!See alsoCOLUMN,
COLUMNS,
ROW.
SHEETSHEET
sheet number of referenceSHEET(reference)Argumentsreference: reference or literal sheet name, defaults to the current sheetNoteIf reference is neither a reference nor a literal sheet name, SHEET returns #VALUE!See alsoSHEETS,
ROW,
COLUMNNUMBER.
SHEETSSHEETS
number of sheets in referenceSHEETS(reference)Argumentsreference: array, reference, or range, defaults to the maximum rangeNoteIf reference is neither an array nor a reference nor a range, SHEETS returns #VALUE!See alsoCOLUMNS,
ROWS.
SORTSORT
sorted list of numbers as vertical array
SORT(ref,order)Argumentsref: list of numbersorder: 0 (descending order) or 1 (ascending order); defaults to 0NoteStrings, booleans, and empty cells are ignored.See alsoARRAY.
TRANSPOSETRANSPOSE
the transpose of matrixTRANSPOSE(matrix)Argumentsmatrix: rangeSee alsoMMULT.
VLOOKUPVLOOKUP
search the first column of range for valueVLOOKUP(value,range,column,approximate,as_index)Argumentsvalue: search valuerange: range to searchcolumn: 1-based column offset indicating the return valuesapproximate: if false, an exact match of value must be found; defaults to TRUEas_index: if true, the 0-based row offset is returned; defaults to FALSEDescriptionVLOOKUP function finds the row in range that has a first cell similar to value. If approximate is not true it finds the row with an exact equality. If approximate is true, it finds the last row with first value less than or equal to value. If as_index is true the 0-based row offset is returned.NoteIf approximate is true, then the values must be sorted in order of ascending value. VLOOKUP returns #REF! if column falls outside range.See alsoHLOOKUP.
MathematicsABSABS
absolute value
ABS(x)Argumentsx: numberDescriptionABS gives the absolute value of x, i.e. the non-negative number of the same magnitude as x.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoCEIL,
CEILING,
FLOOR,
INT,
MOD.
ACOSACOS
the arc cosine of xACOS(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCOS,
SIN,
DEGREES,
RADIANS.
ACOSHACOSH
the hyperbolic arc cosine of xACOSH(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoACOS,
ASINH.
ACOTACOT
inverse cotangent of xACOT(x)Argumentsx: valueSee alsoCOT,
TAN.
ACOTHACOTH
the inverse hyperbolic cotangent of xACOTH(x)Argumentsx: numberSee alsoCOTH,
TANH.
ARABICARABIC
the Roman numeral roman as number
ARABIC(roman)Argumentsroman: Roman numeralDescriptionAny Roman symbol to the left of a larger symbol (directly or indirectly) reduces the final value by the symbol amount, otherwise, it increases the final amount by the symbol's amount.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoROMAN.
ASINASIN
the arc sine of xASIN(x)Argumentsx: numberDescriptionASIN calculates the arc sine of x; that is the value whose sine is x.NoteIf x falls outside the range -1 to 1, ASIN returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoSIN,
COS,
ASINH,
DEGREES,
RADIANS.
ASINHASINH
the inverse hyperbolic sine of xASINH(x)Argumentsx: numberDescriptionASINH calculates the inverse hyperbolic sine of x; that is the value whose hyperbolic sine is x.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoASIN,
ACOSH,
SIN,
COS.
ATANATAN
the arc tangent of xATAN(x)Argumentsx: numberDescriptionATAN calculates the arc tangent of x; that is the value whose tangent is x.NoteThe result will be between −π/2 and +π/2.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoTAN,
COS,
SIN,
DEGREES,
RADIANS.
ATAN2ATAN2
the arc tangent of the ratio y/xATAN2(x,y)Argumentsx: x-coordinatey: y-coordinateDescriptionATAN2 calculates the direction from the origin to the point (x,y) as an angle from the x-axis in radians.NoteThe result will be between −π and +π. The order of the arguments may be unexpected.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoATAN,
ATANH,
COS,
SIN.
ATANHATANH
the inverse hyperbolic tangent of xATANH(x)Argumentsx: numberDescriptionATANH calculates the inverse hyperbolic tangent of x; that is the value whose hyperbolic tangent is x.NoteIf the absolute value of x is greater than 1.0, ATANH returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoATAN,
COS,
SIN.
AVERAGEIFAVERAGEIF
average of the cells in actual range for which the corresponding cells in the range meet the given criteriaAVERAGEIF(range,criteria,actual_range)Argumentsrange: cell areacriteria: condition for a cell to be includedactual_range: cell area, defaults to rangeMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoSUMIF,
COUNTIF.
BETABETA
Euler beta function
BETA(x,y)Argumentsx: numbery: numberDescriptionBETA function returns the value of the Euler beta function extended to all real numbers except 0 and negative integers.NoteIf x, y, or (x + y) are non-positive integers, BETA returns #NUM!See alsoBETALN,
GAMMALN.
BETALNBETALN
natural logarithm of the absolute value of the Euler beta function
BETALN(x,y)Argumentsx: numbery: numberDescriptionBETALN function returns the natural logarithm of the absolute value of the Euler beta function extended to all real numbers except 0 and negative integers.NoteIf x, y, or (x + y) are non-positive integers, BETALN returns #NUM!See alsoBETA,
GAMMALN.
CEILCEIL
smallest integer larger than or equal to xCEIL(x)Argumentsx: numberDescriptionCEIL(x) is the smallest integer that is at least as large as x.OpenDocument Format (ODF) CompatibilityThis function is the OpenFormula function CEILING(x).See alsoCEILING,
FLOOR,
ABS,
INT,
MOD.
CEILINGCEILING
nearest multiple of significance whose absolute value is at least ABS(x)
CEILING(x,significance)Argumentsx: numbersignificance: base multiple (defaults to 1 for x > 0 and -1 for x <0)DescriptionCEILING(x,significance) is the nearest multiple of significance whose absolute value is at least ABS(x).NoteIf x or significance is non-numeric, CEILING returns a #VALUE! error. If x and significance have different signs, CEILING returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityCEILING(x) is exported to ODF as CEILING(x,SIGN(x),1). CEILING(x,significance) is the OpenFormula function CEILING(x,significance,1).See alsoCEIL,
FLOOR,
ABS,
INT,
MOD.
CHOLESKYCHOLESKY
the Cholesky decomposition of the symmetric positive-definite matrixCHOLESKY(matrix)Argumentsmatrix: a symmetric positive definite matrixNoteIf the Cholesky-Banachiewicz algorithm applied to matrix fails, Cholesky returns #NUM! If matrix does not contain an equal number of columns and rows, CHOLESKY returns #VALUE!See alsoMINVERSE,
MMULT,
MDETERM.
COMBINCOMBIN
binomial coefficient
COMBIN(n,k)Argumentsn: non-negative integerk: non-negative integerDescriptionCOMBIN returns the binomial coefficient "n choose k", the number of k-combinations of an n-element set without repetition.NoteIf n is less than kCOMBIN returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.COMBINACOMBINA
the number of k-combinations of an n-element set with repetition
COMBINA(n,k)Argumentsn: non-negative integerk: non-negative integerOpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoCOMBIN.
COSCOS
the cosine of xCOS(x)Argumentsx: angle in radiansDescriptionThis function is Excel compatible.See alsoSIN,
TAN,
SINH,
COSH,
TANH,
RADIANS,
DEGREES.
COSHCOSH
the hyperbolic cosine of xCOSH(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoSIN,
TAN,
SINH,
COSH,
TANH.
COTCOT
the cotangent of xCOT(x)Argumentsx: numberSee alsoTAN,
ACOT.
COTHCOTH
the hyperbolic cotangent of xCOTH(x)Argumentsx: numberSee alsoTANH,
ACOTH.
COUNTIFCOUNTIF
count of the cells meeting the given criteriaCOUNTIF(range,criteria)Argumentsrange: cell areacriteria: condition for a cell to be countedMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCOUNT,
SUMIF.
CSCCSC
the cosecant of xCSC(x)Argumentsx: angle in radiansMicrosoft Excel CompatibilityThis function is not Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoSIN,
COS,
TAN,
SEC,
SINH,
COSH,
TANH,
RADIANS,
DEGREES.
CSCHCSCH
the hyperbolic cosecant of xCSCH(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is not Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoSIN,
COS,
TAN,
CSC,
SEC,
SINH,
COSH,
TANH.
DEGREESDEGREES
equivalent degrees to x radians
DEGREES(x)Argumentsx: angle in radiansMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoRADIANS,
PI.
EIGENEIGEN
eigenvalues and eigenvectors of the symmetric matrixEIGEN(matrix)Argumentsmatrix: a symmetric matrixNoteIf matrix is not symmetric, EIGEN returns #NUM! If matrix does not contain an equal number of columns and rows, EIGEN returns #VALUE!EVENEVENx rounded away from 0 to the next even integer
EVEN(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoODD.
EXPEXP
e raised to the power of xEXP(x)Argumentsx: numberNotee is the base of the natural logarithm.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoLOG,
LOG2,
LOG10.
EXPM1EXPM1
EXP(x)-1
EXPM1(x)Argumentsx: numberNoteThis function has a higher resulting precision than evaluating EXP(x)-1.See alsoEXP,
LN1P.
FACTFACT
the factorial of x, i.e. x!
FACT(x)Argumentsx: numberNoteThe domain of this function has been extended using the GAMMA function.Microsoft Excel CompatibilityThis function is Excel compatible.FACTDOUBLEFACTDOUBLE
double factorial
FACTDOUBLE(x)Argumentsx: non-negative integerDescriptionFACTDOUBLE function returns the double factorial x!!NoteIf x is not an integer, it is truncated. If x is negative, FACTDOUBLE returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoFACT.
FIBFIB
Fibonacci numbers
FIB(n)Argumentsn: positive integerDescriptionFIB(n) is the nth Fibonacci number.NoteIf n is not an integer, it is truncated. If it is negative or zero FIB returns #NUM!FLOORFLOOR
nearest multiple of significance whose absolute value is at most ABS(x)
FLOOR(x,significance)Argumentsx: numbersignificance: base multiple (defaults to 1 for x > 0 and -1 for x <0)DescriptionFLOOR(x,significance) is the nearest multiple of significance whose absolute value is at most ABS(x)Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityFLOOR(x) is exported to ODF as FLOOR(x,SIGN(x),1). FLOOR(x,significance) is the OpenFormula function FLOOR(x,significance,1).See alsoCEIL,
CEILING,
ABS,
INT,
MOD.
G_PRODUCTG_PRODUCT
product of all the values and cells referenced
G_PRODUCT(x1,x2,…)Argumentsx1: numberx2: numberNoteEmpty cells are ignored and the empty product is 1.See alsoSUM,
COUNT.
GAMMAGAMMA
the Gamma function
GAMMA(x)Argumentsx: numberSee alsoGAMMALN.
GAMMALNGAMMALN
natural logarithm of the Gamma function
GAMMALN(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoGAMMA.
GCDGCD
the greatest common divisor
GCD(n0,n1,…)Argumentsn0: positive integern1: positive integerDescriptionGCD calculates the greatest common divisor of the given numbers n0,n1,..., the greatest integer that is a divisor of each argument.NoteIf any of the arguments is not an integer, it is truncated.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoLCM.
GDGD
Gudermannian function
GD(x)Argumentsx: valueSee alsoTAN,
TANH.
HYPOTHYPOT
the square root of the sum of the squares of the arguments
HYPOT(n0,n1,…)Argumentsn0: numbern1: numberSee alsoMIN,
MAX.
INTINT
largest integer not larger than xINT(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCEIL,
CEILING,
FLOOR,
ABS,
MOD.
LCMLCM
the least common multiple
LCM(n0,n1,…)Argumentsn0: positive integern1: positive integerDescriptionLCM calculates the least common multiple of the given numbers n0,n1,..., the smallest integer that is a multiple of each argument.NoteIf any of the arguments is not an integer, it is truncated.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoGCD.
LNLN
the natural logarithm of xLN(x)Argumentsx: positive numberNoteIf x ≤ 0, LN returns #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoEXP,
LOG2,
LOG10.
LN1PLN1P
LN(1+x)
LN1P(x)Argumentsx: positive numberDescriptionLN1P calculates LN(1+x) but yielding a higher precision than evaluating LN(1+x).NoteIf x ≤ -1, LN returns #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoEXP,
LN,
EXPM1.
LOGLOG
logarithm of x with base baseLOG(x,base)Argumentsx: positive numberbase: base of the logarithm, defaults to 10Notebase must be positive and not equal to 1. If x ≤ 0, LOG returns #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoLN,
LOG2,
LOG10.
LOG10LOG10
the base-10 logarithm of xLOG10(x)Argumentsx: positive numberNoteIf x ≤ 0, LOG10 returns #NUM!See alsoEXP,
LOG2,
LOG.
LOG2LOG2
the base-2 logarithm of xLOG2(x)Argumentsx: positive numberNoteIf x ≤ 0, LOG2 returns #NUM!See alsoEXP,
LOG10,
LOG.
MDETERMMDETERM
the determinant of the matrix matrixMDETERM(matrix)Argumentsmatrix: a square matrixMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoMMULT,
MINVERSE.
MINVERSEMINVERSE
the inverse matrix of matrixMINVERSE(matrix)Argumentsmatrix: a square matrixNoteIf matrix is not invertible, MINVERSE returns #NUM! If matrix does not contain an equal number of columns and rows, MINVERSE returns #VALUE!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoMMULT,
MDETERM.
MMULTMMULT
the matrix product of mat1 and mat2MMULT(mat1,mat2)Argumentsmat1: a matrixmat2: a matrixMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoTRANSPOSE,
MINVERSE.
MODMOD
the remainder of x under division by nMOD(x,n)Argumentsx: integern: integerDescriptionMOD function returns the remainder when x is divided by n.NoteIf n is 0, MOD returns #DIV/0!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoCEIL,
CEILING,
FLOOR,
ABS,
INT,
ABS.
MROUNDMROUNDx rounded to a multiple of mMROUND(x,m)Argumentsx: numberm: numberNoteIf x and m have different sign, MROUND returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoROUNDDOWN,
ROUND,
ROUNDUP.
MULTINOMIALMULTINOMIAL
multinomial coefficient (x1+⋯+xn) choose (x1,…,xn)
MULTINOMIAL(x1,x2,xn,…)Argumentsx1: first numberx2: second numberxn: nth numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCOMBIN,
SUM.
MUNITMUNIT
the n by n identity matrix
MUNIT(n)Argumentsn: size of the matrixOpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoMMULT,
MDETERM,
MINVERSE.
ODDODDx rounded away from 0 to the next odd integer
ODD(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoEVEN.
PIPI
the constant π
PI()Microsoft Excel CompatibilityThis function is Excel compatible, but it returns π with a better precision.See alsoSQRTPI.
POWERPOWER
the value of x raised to the power yPOWER(x,y)Argumentsx: numbery: numberNoteIf both x and y equal 0, POWER returns #NUM! If x = 0 and y < 0, POWER returns #DIV/0! If x < 0 and y is not an integer, POWER returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoEXP.
PRODUCTPRODUCT
product of the given values
PRODUCT(values,…)Argumentsvalues: a list of values to multiplyDescriptionPRODUCT computes the product of all the values and cells referenced in the argument list.NoteIf all cells are empty, the result will be 0.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoSUM,
COUNT,
G_PRODUCT.
QUOTIENTQUOTIENT
integer portion of a division
QUOTIENT(numerator,denominator)Argumentsnumerator: integerdenominator: non-zero integerDescriptionQUOTIENT yields the integer portion of the division numerator/denominator.QUOTIENT (numerator,denominator)⨉denominator+MOD(numerator,denominator)=numeratorMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoMOD.
RADIANSRADIANS
the number of radians equivalent to x degrees
RADIANS(x)Argumentsx: angle in degreesMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoPI,
DEGREES.
ROMANROMANn as a roman numeral text
ROMAN(n,type)Argumentsn: non-negative integertype: 0,1,2,3,or 4, defaults to 0DescriptionROMAN returns the arabic number n as a roman numeral text.If type is 0 or it is omitted, ROMAN returns classic roman numbers.Type 1 is more concise than classic type, type 2 is more concise than type 1, and type 3 is more concise than type 2. Type 4 is a simplified type.Microsoft Excel CompatibilityThis function is Excel compatible.ROUNDROUND
rounded xROUND(x,d)Argumentsx: numberd: integer, defaults to 0DescriptionIf d is greater than zero, x is rounded to the given number of digits.If d is zero, x is rounded to the next integer.If d is less than zero, x is rounded to the left of the decimal pointMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoROUNDDOWN,
ROUNDUP.
ROUNDDOWNROUNDDOWNx rounded towards 0
ROUNDDOWN(x,d)Argumentsx: numberd: integer, defaults to 0DescriptionIf d is greater than zero, x is rounded toward 0 to the given number of digits.If d is zero, x is rounded toward 0 to the next integer.If d is less than zero, x is rounded toward 0 to the left of the decimal pointMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoROUND,
ROUNDUP.
ROUNDUPROUNDUPx rounded away from 0
ROUNDUP(x,d)Argumentsx: numberd: integer, defaults to 0DescriptionIf d is greater than zero, x is rounded away from 0 to the given number of digits.If d is zero, x is rounded away from 0 to the next integer.If d is less than zero, x is rounded away from 0 to the left of the decimal pointMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoROUND,
ROUNDDOWN,
INT.
SECSEC
Secant
SEC(x)Argumentsx: angle in radiansMicrosoft Excel CompatibilityThis function is not Excel compatible.OpenDocument Format (ODF) CompatibilitySEC(x) is exported to OpenFormula as 1/COS(x).See alsoSIN,
COS,
TAN,
CSC,
SINH,
COSH,
TANH,
RADIANS,
DEGREES.
SECHSECH
the hyperbolic secant of xSECH(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is not Excel compatible.OpenDocument Format (ODF) CompatibilitySECH(x) is exported to OpenFormula as 1/COSH(x).See alsoSIN,
COS,
TAN,
CSC,
SEC,
SINH,
COSH,
TANH.
SERIESSUMSERIESSUM
sum of a power series at xSERIESSUM(x,n,m,coeff)Argumentsx: number where to evaluate the power seriesn: non-negative integer, exponent of the lowest term of the seriesm: increment to each exponentcoeff: coefficients of the power seriesMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCOUNT,
SUM.
SIGNSIGN
sign of xSIGN(x)Argumentsx: numberDescriptionSIGN returns 1 if the x is positive and it returns -1 if x is negative.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoABS.
SINSIN
the sine of xSIN(x)Argumentsx: angle in radiansMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCOS,
TAN,
CSC,
SEC,
SINH,
COSH,
TANH,
RADIANS,
DEGREES.
SINHSINH
the hyperbolic sine of xSINH(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoSIN,
COSH,
ASINH.
SQRTSQRT
square root of xSQRT(x)Argumentsx: non-negative numberNoteIf x is negative, SQRT returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPOWER.
SQRTPISQRTPI
the square root of x times π
SQRTPI(x)Argumentsx: non-negative numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoPI.
SUMSUM
sum of the given values
SUM(values,…)Argumentsvalues: a list of values to addDescriptionSUM computes the sum of all the values and cells referenced in the argument list.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoAVERAGE,
COUNT.
SUMASUMA
sum of all values and cells referenced
SUMA(area0,area1,…)Argumentsarea0: first cell areaarea1: second cell areaDescriptionNumbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1).See alsoAVERAGE,
SUM,
COUNT.
SUMIFSUMIF
sum of the cells in actual_range for which the corresponding cells in the range meet the given criteriaSUMIF(range,criteria,actual_range)Argumentsrange: cell areacriteria: condition for a cell to be summedactual_range: cell area, defaults to rangeMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoSUM,
COUNTIF.
SUMPRODUCTSUMPRODUCT
multiplies components and adds the results
SUMPRODUCT(,…)DescriptionMultiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.NoteIf an entry is not numeric, the value zero is used instead. If arrays or range arguments do not have the same dimensions, return #VALUE! error. SUMPRODUCTs arguments are arrays or ranges. Attempting to use A1:A5>0 will not work, implicit intersection will kick in. Instead use --(A1:A5>0)See alsoSUM,
PRODUCT,
G_PRODUCT.
SUMSQSUMSQ
sum of the squares of all values and cells referenced
SUMSQ(area0,area1,…)Argumentsarea0: first cell areaarea1: second cell areaMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoSUM,
COUNT.
SUMX2MY2SUMX2MY2
sum of the difference of squares
SUMX2MY2(array0,array1)Argumentsarray0: first cell areaarray1: second cell areaDescriptionSUMX2MY2 function returns the sum of the difference of squares of corresponding values in two arrays. The equation of SUMX2MY2 is SUM(x^2-y^2).Microsoft Excel CompatibilityThis function is Excel compatible.See alsoSUMSQ,
SUMX2PY2.
SUMX2PY2SUMX2PY2
sum of the sum of squares
SUMX2PY2(array0,array1)Argumentsarray0: first cell areaarray1: second cell areaDescriptionSUMX2PY2 function returns the sum of the sum of squares of corresponding values in two arrays. The equation of SUMX2PY2 is SUM(x^2+y^2).NoteIf array0 and array1 have different number of data points, SUMX2PY2 returns #N/A.Strings and empty cells are simply ignored.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoSUMSQ,
SUMX2MY2.
SUMXMY2SUMXMY2
sum of the squares of differences
SUMXMY2(array0,array1)Argumentsarray0: first cell areaarray1: second cell areaDescriptionSUMXMY2 function returns the sum of the squares of the differences of corresponding values in two arrays. The equation of SUMXMY2 is SUM((x-y)^2).NoteIf array0 and array1 have different number of data points, SUMXMY2 returns #N/A.Strings and empty cells are simply ignored.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoSUMSQ,
SUMX2MY2,
SUMX2PY2.
TANTAN
the tangent of xTAN(x)Argumentsx: angle in radiansMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoTANH,
COS,
COSH,
SIN,
SINH,
DEGREES,
RADIANS.
TANHTANH
the hyperbolic tangent of xTANH(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoTAN,
SIN,
SINH,
COS,
COSH.
TRUNCTRUNCx truncated to d digits
TRUNC(x,d)Argumentsx: numberd: non-negative integer, defaults to 0NoteIf d is omitted or negative then it defaults to zero. If it is not an integer then it is truncated to an integer.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoINT.
Number TheoryISPRIMEISPRIME
whether n is prime
ISPRIME(n)Argumentsn: positive integerDescriptionISPRIME returns TRUE if n is prime and FALSE otherwise.See alsoNT_D,
NT_SIGMA.
ITHPRIMEITHPRIMEith prime
ITHPRIME(i)Argumentsi: positive integerDescriptionITHPRIME finds the ith prime.See alsoNT_D,
NT_SIGMA.
NT_DNT_D
number of divisors
NT_D(n)Argumentsn: positive integerDescriptionNT_D calculates the number of divisors of n.See alsoITHPRIME,
NT_PHI,
NT_SIGMA.
NT_MUNT_MU
Möbius mu function
NT_MU(n)Argumentsn: positive integerDescriptionNT_MU function (Möbius mu function) returns 0 if n is divisible by the square of a prime. Otherwise, if n has an odd number of different prime factors, NT_MU returns -1, and if n has an even number of different prime factors, it returns 1. If n = 1, NT_MU returns 1.See alsoITHPRIME,
NT_PHI,
NT_SIGMA,
NT_D.
NT_PHINT_PHI
Euler's totient function
NT_PHI(n)Argumentsn: positive integerNoteEuler's totient function gives the number of integers less than or equal to n that are relatively prime (coprime) to n.See alsoNT_D,
ITHPRIME,
NT_SIGMA.
NT_PINT_PI
number of primes upto nNT_PI(n)Argumentsn: positive integerDescriptionNT_PI returns the number of primes less than or equal to n.See alsoITHPRIME,
NT_PHI,
NT_D,
NT_SIGMA.
NT_SIGMANT_SIGMA
sigma function
NT_SIGMA(n)Argumentsn: positive integerDescriptionNT_SIGMA calculates the sum of the divisors of n.See alsoNT_D,
ITHPRIME,
NT_PHI.
PFACTORPFACTOR
smallest prime factor
PFACTOR(n)Argumentsn: positive integerDescriptionPFACTOR finds the smallest prime factor of its argument.NoteThe argument n must be at least 2. Otherwise a #VALUE! error is returned.See alsoITHPRIME.
Random NumbersRANDRAND
a random number between zero and one
RAND()Microsoft Excel CompatibilityThis function is Excel compatible.See alsoRANDBETWEEN.
RANDBERNOULLIRANDBERNOULLI
random variate from a Bernoulli distribution
RANDBERNOULLI(p)Argumentsp: probability of successNoteIf p < 0 or p > 1 RANDBERNOULLI returns #NUM!See alsoRAND,
RANDBETWEEN.
RANDBETARANDBETA
random variate from a Beta distribution
RANDBETA(a,b)Argumentsa: parameter of the Beta distributionb: parameter of the Beta distributionSee alsoRAND,
RANDGAMMA.
RANDBETWEENRANDBETWEEN
a random integer number between and including bottom and topRANDBETWEEN(bottom,top)Argumentsbottom: lower limittop: upper limitNoteIf bottom > top, RANDBETWEEN returns #NUM!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoRAND,
RANDUNIFORM.
RANDBINOMRANDBINOM
random variate from a binomial distribution
RANDBINOM(p,n)Argumentsp: probability of success in a single trialn: number of trialsNoteIf p < 0 or p > 1 RANDBINOM returns #NUM! If n < 0 RANDBINOM returns #NUM!See alsoRAND,
RANDBETWEEN.
RANDCAUCHYRANDCAUCHY
random variate from a Cauchy or Lorentz distribution
RANDCAUCHY(a)Argumentsa: scale parameter of the distributionNoteIf a < 0 RANDCAUCHY returns #NUM!See alsoRAND.
RANDCHISQRANDCHISQ
random variate from a Chi-square distribution
RANDCHISQ(df)Argumentsdf: degrees of freedomSee alsoRAND,
RANDGAMMA.
RANDDISCRETERANDDISCRETE
random variate from a finite discrete distribution
RANDDISCRETE(val_range,prob_range)Argumentsval_range: possible values of the random variableprob_range: probabilities of the corresponding values in val_range, defaults to equal probabilitiesDescriptionRANDDISCRETE returns one of the values in the val_range. The probabilities for each value are given in the prob_range.NoteIf the sum of all values in prob_range is not one, RANDDISCRETE returns #NUM! If val_range and prob_range are not the same size, RANDDISCRETE returns #NUM! If val_range or prob_range is not a range, RANDDISCRETE returns #VALUE!See alsoRANDBETWEEN,
RAND.
RANDEXPRANDEXP
random variate from an exponential distribution
RANDEXP(b)Argumentsb: parameter of the exponential distributionSee alsoRAND,
RANDBETWEEN.
RANDEXPPOWRANDEXPPOW
random variate from an exponential power distribution
RANDEXPPOW(a,b)Argumentsa: scale parameter of the exponential power distributionb: exponent of the exponential power distributionDescriptionFor b = 1 the exponential power distribution reduces to the Laplace distribution.For b = 2 the exponential power distribution reduces to the normal distribution with σ = a/sqrt(2)See alsoRAND.
RANDFDISTRANDFDIST
random variate from an F distribution
RANDFDIST(df1,df2)Argumentsdf1: numerator degrees of freedomdf2: denominator degrees of freedomSee alsoRAND,
RANDGAMMA.
RANDGAMMARANDGAMMA
random variate from a Gamma distribution
RANDGAMMA(a,b)Argumentsa: parameter of the Gamma distributionb: parameter of the Gamma distributionNoteIf a ≤ 0, RANDGAMMA returns #NUM!See alsoRAND.
RANDGEOMRANDGEOM
random variate from a geometric distribution
RANDGEOM(p)Argumentsp: probability of success in a single trialNoteIf p < 0 or p > 1 RANDGEOM returns #NUM!See alsoRAND.
RANDGUMBELRANDGUMBEL
random variate from a Gumbel distribution
RANDGUMBEL(a,b,type)Argumentsa: parameter of the Gumbel distributionb: parameter of the Gumbel distributiontype: type of the Gumbel distribution, defaults to 1NoteIf type is neither 1 nor 2, RANDGUMBEL returns #NUM!See alsoRAND.
RANDHYPERGRANDHYPERG
random variate from a hypergeometric distribution
RANDHYPERG(n1,n2,t)Argumentsn1: number of objects of type 1n2: number of objects of type 2t: total number of objects selectedSee alsoRAND.
RANDLANDAURANDLANDAU
random variate from the Landau distribution
RANDLANDAU()See alsoRAND.
RANDLAPLACERANDLAPLACE
random variate from a Laplace distribution
RANDLAPLACE(a)Argumentsa: parameter of the Laplace distributionSee alsoRAND.
RANDLEVYRANDLEVY
random variate from a Lévy distribution
RANDLEVY(c,α,β)Argumentsc: parameter of the Lévy distributionα: parameter of the Lévy distributionβ: parameter of the Lévy distribution, defaults to 0DescriptionFor α = 1, β=0, the Lévy distribution reduces to the Cauchy (or Lorentzian) distribution.For α = 2, β=0, the Lévy distribution reduces to the normal distribution.NoteIf α ≤ 0 or α > 2, RANDLEVY returns #NUM! If β < -1 or β > 1, RANDLEVY returns #NUM!See alsoRAND.
RANDLOGRANDLOG
random variate from a logarithmic distribution
RANDLOG(p)Argumentsp: probabilityNoteIf p < 0 or p > 1 RANDLOG returns #NUM!See alsoRAND.
RANDLOGISTICRANDLOGISTIC
random variate from a logistic distribution
RANDLOGISTIC(a)Argumentsa: parameter of the logistic distributionSee alsoRAND.
RANDLOGNORMRANDLOGNORM
random variate from a lognormal distribution
RANDLOGNORM(ζ,σ)Argumentsζ: parameter of the lognormal distributionσ: standard deviation of the distributionNoteIf σ < 0, RANDLOGNORM returns #NUM!See alsoRAND.
RANDNEGBINOMRANDNEGBINOM
random variate from a negative binomial distribution
RANDNEGBINOM(p,n)Argumentsp: probability of success in a single trialn: number of failuresNoteIf p < 0 or p > 1 RANDNEGBINOM returns #NUM! If n < 1 RANDNEGBINOM returns #NUM!See alsoRAND,
RANDBETWEEN.
RANDNORMRANDNORM
random variate from a normal distribution
RANDNORM(μ,σ)Argumentsμ: mean of the distributionσ: standard deviation of the distributionNoteIf σ < 0, RANDNORM returns #NUM!See alsoRAND.
RANDNORMTAILRANDNORMTAIL
random variate from the upper tail of a normal distribution with mean 0
RANDNORMTAIL(a,σ)Argumentsa: lower limit of the tailσ: standard deviation of the normal distributionNoteThe method is based on Marsaglia's famous rectangle-wedge-tail algorithm (Ann Math Stat 32, 894-899 (1961)), with this aspect explained in Knuth, v2, 3rd ed, p139, 586 (exercise 11).See alsoRAND.
RANDPARETORANDPARETO
random variate from a Pareto distribution
RANDPARETO(a,b)Argumentsa: parameter of the Pareto distributionb: parameter of the Pareto distributionSee alsoRAND.
RANDPOISSONRANDPOISSON
random variate from a Poisson distribution
RANDPOISSON(λ)Argumentsλ: parameter of the Poisson distributionNoteIf λ < 0 RANDPOISSON returns #NUM!See alsoRAND,
RANDBETWEEN.
RANDRAYLEIGHRANDRAYLEIGH
random variate from a Rayleigh distribution
RANDRAYLEIGH(σ)Argumentsσ: scale parameter of the Rayleigh distributionSee alsoRAND.
RANDRAYLEIGHTAILRANDRAYLEIGHTAIL
random variate from the tail of a Rayleigh distribution
RANDRAYLEIGHTAIL(a,σ)Argumentsa: lower limit of the tailσ: scale parameter of the Rayleigh distributionSee alsoRAND,
RANDRAYLEIGH.
RANDSNORMRANDSNORM
random variate from a skew normal distribution
RANDSNORM(a,μ,σ)Argumentsa: amount of skew, defaults to 0μ: mean of the underlying normal distribution, defaults to 0σ: standard deviation of the underlying normal distribution, defaults to 1NoteIf σ < 0, RANDSNORM returns #NUM!See alsoRANDNORM.
RANDSTDISTRANDSTDIST
random variate from a skew t distribution
RANDSTDIST(df,a)Argumentsdf: degrees of freedoma: amount of skew, defaults to 0See alsoRANDTDIST.
RANDTDISTRANDTDIST
random variate from a Student t distribution
RANDTDIST(df)Argumentsdf: degrees of freedomSee alsoRAND.
RANDUNIFORMRANDUNIFORM
random variate from the uniform distribution from a to bRANDUNIFORM(a,b)Argumentsa: lower limit of the uniform distributionb: upper limit of the uniform distributionNoteIf a > bRANDUNIFORM returns #NUM!See alsoRANDBETWEEN,
RAND.
RANDWEIBULLRANDWEIBULL
random variate from a Weibull distribution
RANDWEIBULL(a,b)Argumentsa: parameter of the Weibull distributionb: parameter of the Weibull distributionSee alsoRAND.
SIMTABLESIMTABLE
one of the values in the given argument list depending on the round number of the simulation tool
SIMTABLE(d1,d2,…)Argumentsd1: first valued2: second valueDescriptionSIMTABLE returns one of the values in the given argument list depending on the round number of the simulation tool. When the simulation tool is not activated, SIMTABLE returns d1.With the simulation tool and the SIMTABLE function you can test given decision variables. Each SIMTABLE function contains the possible values of a simulation variable. In most valid simulation models you should have the same number of values dN for all decision variables. If the simulation is run more rounds than there are values defined, SIMTABLE returns #N/A! error (e.g. if A1 contains `=SIMTABLE(1)' and A2 `=SIMTABLE(1,2)', A1 yields #N/A! error on the second round).The successive use of the simulation tool also requires that you give to the tool at least one input variable having RAND() or any other RAND<distribution name>() function in it. On each round, the simulation tool iterates for the given number of rounds over all the input variables to reevaluate them. On each iteration, the values of the output variables are stored, and when the round is completed, descriptive statistical information is created according to the values.StatisticsADTESTADTEST
Anderson-Darling Test of Normality
ADTEST(x)Argumentsx: array of sample valuesDescriptionThis function returns an array with the first row giving the p-value of the Anderson-Darling Test, the second row the test statistic of the test, and the third the number of observations in the sample.NoteIf there are less than 8 sample values, ADTEST returns #VALUE!See alsoCHITEST,
CVMTEST,
LKSTEST,
SFTEST.
AVEDEVAVEDEV
average of the absolute deviations of a data set
AVEDEV(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoSTDEV.
AVERAGEAVERAGE
average of all the numeric values and cells
AVERAGE(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoSUM,
COUNT.
AVERAGEAAVERAGEA
average of all the values and cells
AVERAGEA(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionNumbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE.
BERNOULLIBERNOULLI
probability mass function of a Bernoulli distribution
BERNOULLI(k,p)Argumentsk: integerp: probability of successNoteIf k != 0 and k != 1 this function returns a #NUM! error. If p < 0 or p > 1 this function returns a #NUM! error.See alsoRANDBERNOULLI.
BETADISTBETADIST
cumulative distribution function of the beta distribution
BETADIST(x,alpha,beta,a,b)Argumentsx: numberalpha: scale parameterbeta: scale parametera: optional lower bound, defaults to 0b: optional upper bound, defaults to 1NoteIf x < a or x > b this function returns a #NUM! error. If alpha <= 0 or beta <= 0, this function returns a #NUM! error. If a >= b this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBETAINV.
BETAINVBETAINV
inverse of the cumulative distribution function of the beta distribution
BETAINV(p,alpha,beta,a,b)Argumentsp: probabilityalpha: scale parameterbeta: scale parametera: optional lower bound, defaults to 0b: optional upper bound, defaults to 1NoteIf p < 0 or p > 1 this function returns a #NUM! error. If alpha <= 0 or beta <= 0, this function returns a #NUM! error. If a >= b this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBETADIST.
BINOM.DIST.RANGEBINOM.DIST.RANGE
probability of the binomial distribution over an interval
BINOM.DIST.RANGE(trials,p,start,end)Argumentstrials: number of trialsp: probability of success in each trialstart: start of the intervalend: end of the interval, defaults to startNoteIf start, end or trials are non-integer they are truncated. If trials < 0 this function returns a #NUM! error. If p < 0 or p > 1 this function returns a #NUM! error. If start > end this function returns 0.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoBINOMDIST,
R.PBINOM.
BINOMDISTBINOMDIST
probability mass or cumulative distribution function of the binomial distribution
BINOMDIST(n,trials,p,cumulative)Argumentsn: number of successestrials: number of trialsp: probability of success in each trialcumulative: whether to evaluate the mass function or the cumulative distribution functionNoteIf n or trials are non-integer they are truncated. If n < 0 or trials < 0 this function returns a #NUM! error. If n > trials this function returns a #NUM! error. If p < 0 or p > 1 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPOISSON.
CAUCHYCAUCHY
probability density or cumulative distribution function of the Cauchy, Lorentz or Breit-Wigner distribution
CAUCHY(x,a,cumulative)Argumentsx: numbera: scale parametercumulative: whether to evaluate the density function or the cumulative distribution functionNoteIf a < 0 this function returns a #NUM! error. If cumulative is neither TRUE nor FALSE this function returns a #VALUE! error.See alsoRANDCAUCHY.
CHIDISTCHIDIST
survival function of the chi-squared distribution
CHIDIST(x,dof)Argumentsx: numberdof: number of degrees of freedomDescriptionThe survival function is 1 minus the cumulative distribution function.NoteIf dof is non-integer it is truncated. If dof < 1 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityCHIDIST(x,dof) is the OpenFormula function LEGACY.CHIDIST(x,dof).See alsoCHIINV,
CHITEST.
CHIINVCHIINV
inverse of the survival function of the chi-squared distribution
CHIINV(p,dof)Argumentsp: probabilitydof: number of degrees of freedomDescriptionThe survival function is 1 minus the cumulative distribution function.NoteIf p < 0 or p > 1 or dof < 1 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityCHIINV(p,dof) is the OpenFormula function LEGACY.CHIDIST(p,dof).See alsoCHIDIST,
CHITEST.
CHITESTCHITEST
p value of the Goodness of Fit Test
CHITEST(actual_range,theoretical_range)Argumentsactual_range: observed datatheoretical_range: expected valuesNoteIf the actual range is not an n by 1 or 1 by n range, but an n by m range, then CHITEST uses (n-1) times (m-1) as degrees of freedom. This is useful if the expected values were calculated from the observed value in a test of independence or test of homogeneity.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityCHITEST is the OpenFormula function LEGACY.CHITEST.See alsoCHIDIST,
CHIINV.
CONFIDENCECONFIDENCE
margin of error of a confidence interval for the population mean
CONFIDENCE(alpha,stddev,size)Argumentsalpha: significance levelstddev: population standard deviationsize: sample sizeNoteThis function requires the usually unknown population standard deviation. If size is non-integer it is truncated. If size < 0 this function returns a #NUM! error. If size is 0 this function returns a #DIV/0! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE.
CORRELCORREL
Pearson correlation coefficient of two data sets
CORREL(array1,array2)Argumentsarray1: first data setarray2: second data setDescriptionStrings and empty cells are simply ignored.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoCOVAR,
FISHER,
FISHERINV.
COUNTCOUNT
total number of integer or floating point arguments passed
COUNT(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE.
COUNTACOUNTA
number of arguments passed not including empty cells
COUNTA(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
COUNT,
DCOUNT,
DCOUNTA,
PRODUCT,
SUM.
COVARCOVAR
covariance of two data sets
COVAR(array1,array2)Argumentsarray1: first data setarray2: set data setDescriptionStrings and empty cells are simply ignored.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoCORREL,
FISHER,
FISHERINV.
CRITBINOMCRITBINOM
right-tailed critical value of the binomial distribution
CRITBINOM(trials,p,alpha)Argumentstrials: number of trialsp: probability of success in each trialalpha: significance level (area of the tail)NoteIf trials is a non-integer it is truncated. If trials < 0 this function returns a #NUM! error. If p < 0 or p > 1 this function returns a #NUM! error. If alpha < 0 or alpha > 1 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBINOMDIST.
CRONBACHCRONBACH
Cronbach's alpha
CRONBACH(ref1,ref2,…)Argumentsref1: first data setref2: second data setSee alsoVAR.
CVMTESTCVMTEST
Cramér-von Mises Test of Normality
CVMTEST(x)Argumentsx: array of sample valuesDescriptionThis function returns an array with the first row giving the p-value of the Cramér-von Mises Test, the second row the test statistic of the test, and the third the number of observations in the sample.NoteIf there are less than 8 sample values, CVMTEST returns #VALUE!See alsoCHITEST,
ADTEST,
LKSTEST,
SFTEST.
DEVSQDEVSQ
sum of squares of deviations of a data set
DEVSQ(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionStrings and empty cells are simply ignored.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoSTDEV.
EXPONDISTEXPONDIST
probability density or cumulative distribution function of the exponential distribution
EXPONDIST(x,y,cumulative)Argumentsx: numbery: scale parametercumulative: whether to evaluate the density function or the cumulative distribution functionDescriptionIf cumulative is false it will return: y * exp (-y*x),otherwise it will return 1 - exp (-y*x).NoteIf x < 0 or y <= 0 this will return an error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPOISSON.
EXPPOWDISTEXPPOWDIST
the probability density function of the Exponential Power distribution
EXPPOWDIST(x,a,b)Argumentsx: numbera: scale parameterb: scale parameterDescriptionThis distribution has been recommended for lifetime analysis when a U-shaped hazard function is desired. This corresponds to rapid failure once the product starts to wear out after a period of steady or even improving reliability.See alsoRANDEXPPOW.
FDISTFDIST
survival function of the F distribution
FDIST(x,dof_of_num,dof_of_denom)Argumentsx: numberdof_of_num: numerator degrees of freedomdof_of_denom: denominator degrees of freedomDescriptionThe survival function is 1 minus the cumulative distribution function.NoteIf x < 0 this function returns a #NUM! error. If dof_of_num < 1 or dof_of_denom < 1, this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityFDIST is the OpenFormula function LEGACY.FDIST.See alsoFINV.
FINVFINV
inverse of the survival function of the F distribution
FINV(p,dof_of_num,dof_of_denom)Argumentsp: probabilitydof_of_num: numerator degrees of freedomdof_of_denom: denominator degrees of freedomDescriptionThe survival function is 1 minus the cumulative distribution function.NoteIf p < 0 or p > 1 this function returns a #NUM! error. If dof_of_num < 1 or dof_of_denom < 1 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityFINV is the OpenFormula function LEGACY.FINV.See alsoFDIST.
FISHERFISHER
Fisher transformation
FISHER(x)Argumentsx: numberNoteIf x is not a number, this function returns a #VALUE! error. If x <= -1 or x >= 1, this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoFISHERINV,
ATANH.
FISHERINVFISHERINV
inverse of the Fisher transformation
FISHERINV(x)Argumentsx: numberNoteIf x is a non-number this function returns a #VALUE! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoFISHER,
TANH.
FORECASTFORECAST
estimates a future value according to existing values using simple linear regression
FORECAST(x,known_ys,known_xs)Argumentsx: x-value whose matching y-value should be forecastknown_ys: known y-valuesknown_xs: known x-valuesDescriptionThis function estimates a future value according to existing values using simple linear regression.NoteIf known_xs or known_ys contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the known_xs is zero, this function returns a #DIV/0 error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoINTERCEPT,
TREND.
FREQUENCYFREQUENCY
frequency table
FREQUENCY(data_array,bins_array)Argumentsdata_array: data valuesbins_array: array of cutoff valuesDescriptionThe results are given as an array.If the bins_array is empty, this function returns the number of data points in data_array.Microsoft Excel CompatibilityThis function is Excel compatible.FTESTFTEST
p-value for the two-tailed hypothesis test comparing the variances of two populations
FTEST(array1,array2)Argumentsarray1: sample from the first populationarray2: sample from the second populationMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoFDIST,
FINV.
GAMMADISTGAMMADIST
probability density or cumulative distribution function of the gamma distribution
GAMMADIST(x,alpha,beta,cumulative)Argumentsx: numberalpha: scale parameterbeta: scale parametercumulative: whether to evaluate the density function or the cumulative distribution functionNoteIf x < 0 this function returns a #NUM! error. If alpha <= 0 or beta <= 0, this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoGAMMAINV.
GAMMAINVGAMMAINV
inverse of the cumulative gamma distribution
GAMMAINV(p,alpha,beta)Argumentsp: probabilityalpha: scale parameterbeta: scale parameterNoteIf p < 0 or p > 1 this function returns a #NUM! error. If alpha <= 0 or beta <= 0 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoGAMMADIST.
GEOMDISTGEOMDIST
probability mass or cumulative distribution function of the geometric distribution
GEOMDIST(k,p,cumulative)Argumentsk: number of trialsp: probability of success in any trialcumulative: whether to evaluate the mass function or the cumulative distribution functionNoteIf k < 0 this function returns a #NUM! error. If p < 0 or p > 1 this function returns a #NUM! error. If cumulative is neither TRUE nor FALSE this function returns a #VALUE! error.See alsoRANDGEOM.
GEOMEANGEOMEAN
geometric mean
GEOMEAN(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionThe geometric mean is equal to the Nth root of the product of the N values.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
HARMEAN,
MEDIAN,
MODE,
TRIMMEAN.
GROWTHGROWTH
exponential growth prediction
GROWTH(known_ys,known_xs,new_xs,affine)Argumentsknown_ys: known y-valuesknown_xs: known x-values; defaults to the array {1, 2, 3, …}new_xs: x-values for which to estimate the y-values; defaults to known_xsaffine: if true, the model contains a constant term, defaults to trueDescriptionGROWTH function applies the “least squares” method to fit an exponential curve to your data and predicts the exponential growth by using this curve.GROWTH returns an array having one column and a row for each data point in new_xs.NoteIf known_ys and known_xs have unequal number of data points, this function returns a #NUM! error.See alsoLOGEST,
GROWTH,
TREND.
HARMEANHARMEAN
harmonic mean
HARMEAN(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionThe harmonic mean of N data points is N divided by the sum of the reciprocals of the data points).Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
GEOMEAN,
MEDIAN,
MODE,
TRIMMEAN.
HYPGEOMDISTHYPGEOMDIST
probability mass or cumulative distribution function of the hypergeometric distribution
HYPGEOMDIST(x,n,M,N,cumulative)Argumentsx: number of successesn: sample sizeM: number of possible successes in the populationN: population sizecumulative: whether to evaluate the mass function or the cumulative distribution functionNoteIf x,n,M or N is a non-integer it is truncated. If x,n,M or N < 0 this function returns a #NUM! error. If x > M or n > N this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBINOMDIST,
POISSON.
INTERCEPTINTERCEPT
the intercept of a linear regression line
INTERCEPT(known_ys,known_xs)Argumentsknown_ys: known y-valuesknown_xs: known x-valuesNoteIf known_xs or known_ys contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the known_xs is zero, this function returns #DIV/0 error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoFORECAST,
TREND.
KURTKURT
unbiased estimate of the kurtosis of a data set
KURT(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionStrings and empty cells are simply ignored.NoteThis is only meaningful if the underlying distribution really has a fourth moment. The kurtosis is offset by three such that a normal distribution will have zero kurtosis. If fewer than four numbers are given or all of them are equal this function returns a #DIV/0! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
VAR,
SKEW,
KURTP.
KURTPKURTP
population kurtosis of a data set
KURTP(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionStrings and empty cells are simply ignored.NoteIf fewer than two numbers are given or all of them are equal this function returns a #DIV/0! error.See alsoAVERAGE,
VARP,
SKEWP,
KURT.
LANDAULANDAU
approximate probability density function of the Landau distribution
LANDAU(x)Argumentsx: numberSee alsoRANDLANDAU.
LAPLACELAPLACE
probability density function of the Laplace distribution
LAPLACE(x,a)Argumentsx: numbera: meanSee alsoRANDLAPLACE.
LARGELARGEk-th largest value in a data set
LARGE(data,k)Argumentsdata: data setk: which value to findNoteIf data set is empty this function returns a #NUM! error. If k <= 0 or k is greater than the number of data items given this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPERCENTILE,
PERCENTRANK,
QUARTILE,
SMALL.
LINESTLINEST
multiple linear regression coefficients and statistics
LINEST(known_ys,known_xs,affine,stats)Argumentsknown_ys: vector of values of dependent variableknown_xs: array of values of independent variables, defaults to a single vector {1,…,n}affine: if true, the model contains a constant term, defaults to truestats: if true, some additional statistics are provided, defaults to falseDescriptionThis function returns an array with the first row giving the regression coefficients for the independent variables x_m, x_(m-1),…,x_2, x_1 followed by the y-intercept if affine is true.If stats is true, the second row contains the corresponding standard errors of the regression coefficients.In this case, the third row contains the R^2 value and the standard error for the predicted value. The fourth row contains the observed F value and its degrees of freedom. Finally, the fifth row contains the regression sum of squares and the residual sum of squares.If affine is false, R^2 is the uncentered version of the coefficient of determination; that is the proportion of the sum of squares explained by the model.NoteIf the length of known_ys does not match the corresponding length of known_xs, this function returns a #NUM! error.See alsoLOGEST,
TREND.
LKSTESTLKSTEST
Lilliefors (Kolmogorov-Smirnov) Test of Normality
LKSTEST(x)Argumentsx: array of sample valuesDescriptionThis function returns an array with the first row giving the p-value of the Lilliefors (Kolmogorov-Smirnov) Test, the second row the test statistic of the test, and the third the number of observations in the sample.NoteIf there are less than 5 sample values, LKSTEST returns #VALUE!See alsoCHITEST,
ADTEST,
SFTEST,
CVMTEST.
LOGESTLOGEST
exponential least square fit
LOGEST(known_ys,known_xs,affine,stat)Argumentsknown_ys: known y-valuesknown_xs: known x-values; default to an array {1, 2, 3, …}affine: if true, the model contains a constant term, defaults to truestat: if true, extra statistical information will be returned; defaults to FALSEDescriptionLOGEST function applies the “least squares” method to fit an exponential curve of the form y = b * m{1}^x{1} * m{2}^x{2}... to your data.LOGEST returns an array { m{n},m{n-1}, ...,m{1},b }.NoteExtra statistical information is written below the regression line coefficients in the result array. Extra statistical information consists of four rows of data. In the first row the standard error values for the coefficients m1, (m2, ...), b are represented. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares. If known_ys and known_xs have unequal number of data points, this function returns a #NUM! error.See alsoGROWTH,
TREND.
LOGFITLOGFIT
logarithmic least square fit (using a trial and error method)
LOGFIT(known_ys,known_xs)Argumentsknown_ys: known y-valuesknown_xs: known x-valuesDescriptionLOGFIT function applies the “least squares” method to fit the logarithmic equation y = a + b * ln(sign * (x - c)) , sign = +1 or -1 to your data. The graph of the equation is a logarithmic curve moved horizontally by c and possibly mirrored across the y-axis (if sign = -1).LOGFIT returns an array having five columns and one row. `Sign' is given in the first column, `a', `b', and `c' are given in columns 2 to 4. Column 5 holds the sum of squared residuals.NoteAn error is returned when there are less than 3 different x's or y's, or when the shape of the point cloud is too different from a ``logarithmic'' one. You can use the above formula = a + b * ln(sign * (x - c)) or rearrange it to = (exp((y - a) / b)) / sign + c to compute unknown y's or x's, respectively. This is non-linear fitting by trial-and-error. The accuracy of `c' is: width of x-range -> rounded to the next smaller (10^integer), times 0.000001. There might be cases in which the returned fit is not the best possible.See alsoLOGREG,
LINEST,
LOGEST.
LOGINVLOGINV
inverse of the cumulative distribution function of the lognormal distribution
LOGINV(p,mean,stddev)Argumentsp: probabilitymean: meanstddev: standard deviationNoteIf p < 0 or p > 1 or stddev <= 0 this function returns #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoEXP,
LN,
LOG,
LOG10,
LOGNORMDIST.
LOGISTICLOGISTIC
probability density function of the logistic distribution
LOGISTIC(x,a)Argumentsx: numbera: scale parameterSee alsoRANDLOGISTIC.
LOGNORMDISTLOGNORMDIST
cumulative distribution function of the lognormal distribution
LOGNORMDIST(x,mean,stddev)Argumentsx: numbermean: meanstddev: standard deviationNoteIf stddev = 0 LOGNORMDIST returns a #DIV/0! error. If x <= 0, mean < 0 or stddev <= 0 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoNORMDIST.
LOGREGLOGREG
the logarithmic regression
LOGREG(known_ys,known_xs,affine,stat)Argumentsknown_ys: known y-valuesknown_xs: known x-values; defaults to the array {1, 2, 3, …}affine: if true, the model contains a constant term, defaults to truestat: if true, extra statistical information will be returned; defaults to FALSEDescriptionLOGREG function transforms your x's to z=ln(x) and applies the “least squares” method to fit the linear equation y = m * z + b to your y's and z's --- equivalent to fitting the equation y = m * ln(x) + b to y's and x's. LOGREG returns an array having two columns and one row. m is given in the first column and b in the second. Any extra statistical information is written below m and b in the result array. This extra statistical information consists of four rows of data: In the first row the standard error values for the coefficients m, b are given. The second row contains the square of R and the standard error for the y estimate. The third row contains the F-observed value and the degrees of freedom. The last row contains the regression sum of squares and the residual sum of squares.The default of stat is FALSE.NoteIf known_ys and known_xs have unequal number of data points, this function returns a #NUM! error.See alsoLOGFIT,
LINEST,
LOGEST.
MAXMAX
largest value, with negative numbers considered smaller than positive numbers
MAX(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoMIN,
ABS.
MAXAMAXA
largest value, with negative numbers considered smaller than positive numbers
MAXA(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionNumbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoMAX,
MINA.
MEDIANMEDIAN
median of a data set
MEDIAN(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionStrings and empty cells are simply ignored.NoteIf even numbers are given MEDIAN returns the average of the two numbers in the center.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
COUNT,
COUNTA,
DAVERAGE,
MODE,
SSMEDIAN,
SUM.
MINMIN
smallest value, with negative numbers considered smaller than positive numbers
MIN(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoMAX,
ABS.
MINAMINA
smallest value, with negative numbers considered smaller than positive numbers
MINA(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionNumbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoMIN,
MAXA.
MODEMODE
first most common number in the dataset
MODE(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionStrings and empty cells are simply ignored.If the data set does not contain any duplicates this function returns a #N/A error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
MEDIAN.
NEGBINOMDISTNEGBINOMDIST
probability mass function of the negative binomial distribution
NEGBINOMDIST(f,t,p)Argumentsf: number of failurest: threshold number of successesp: probability of a successNoteIf f or t is a non-integer it is truncated. If (f + t -1) <= 0 this function returns a #NUM! error. If p < 0 or p > 1 this functions returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBINOMDIST,
COMBIN,
FACT,
HYPGEOMDIST,
PERMUT.
NORMDISTNORMDIST
probability density or cumulative distribution function of a normal distribution
NORMDIST(x,mean,stddev,cumulative)Argumentsx: numbermean: mean of the distributionstddev: standard deviation of the distributioncumulative: whether to evaluate the density function or the cumulative distribution functionNoteIf stddev is 0 this function returns a #DIV/0! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPOISSON.
NORMINVNORMINV
inverse of the cumulative distribution function of a normal distribution
NORMINV(p,mean,stddev)Argumentsp: probabilitymean: mean of the distributionstddev: standard deviation of the distributionNoteIf p < 0 or p > 1 or stddev <= 0 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoNORMDIST,
NORMSDIST,
NORMSINV,
STANDARDIZE,
ZTEST.
NORMSDISTNORMSDIST
cumulative density function of the standard normal distribution
NORMSDIST(x)Argumentsx: numberMicrosoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityNORMSDIST is the OpenFormula function LEGACY.NORMSDIST.See alsoNORMDIST.
NORMSINVNORMSINV
inverse of the cumulative density function of the standard normal distribution
NORMSINV(p)Argumentsp: given probabilityNoteIf p < 0 or p > 1 this function returns #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityNORMSINV is the OpenFormula function LEGACY.NORMSINV.See alsoNORMDIST,
NORMINV,
NORMSDIST,
STANDARDIZE,
ZTEST.
PARETOPARETO
probability density function of the Pareto distribution
PARETO(x,a,b)Argumentsx: numbera: exponentb: scale parameterSee alsoRANDPARETO.
PEARSONPEARSON
Pearson correlation coefficient of the paired set of data
PEARSON(array1,array2)Argumentsarray1: first component valuesarray2: second component valuesDescriptionStrings and empty cells are simply ignored.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoINTERCEPT,
LINEST,
RSQ,
SLOPE,
STEYX.
PERCENTILEPERCENTILE
determines the 100*k-th percentile of the given data points
PERCENTILE(array,k)Argumentsarray: data pointsk: which percentile to calculateNoteIf array is empty, this function returns a #NUM! error. If k < 0 or k > 1, this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoQUARTILE.
PERCENTRANKPERCENTRANK
rank of a data point in a data set
PERCENTRANK(array,x,significance)Argumentsarray: range of numeric valuesx: data point to be rankedsignificance: number of significant digits, defaults to 3NoteIf array contains no data points, this function returns a #NUM! error. If significance is less than one, this function returns a #NUM! error. If x exceeds the largest value or is less than the smallest value in array, this function returns a #NUM! error. If x does not match any of the values in array or x matches more than once, this function interpolates the returned value.See alsoLARGE,
MAX,
MEDIAN,
MIN,
PERCENTILE,
QUARTILE,
SMALL.
PERMUTPERMUT
number of k-permutations of a n-set
PERMUT(n,k)Argumentsn: size of the base setk: number of elements in each permutationNoteIf n = 0 this function returns a #NUM! error. If n < k this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoCOMBIN.
PERMUTATIONAPERMUTATIONA
the number of permutations of y objects chosen from x objects with repetition allowed
PERMUTATIONA(x,y)Argumentsx: total number of objectsy: number of selected objectsNoteIf both x and y equal 0, PERMUTATIONA returns 1. If x < 0 or y < 0, PERMUTATIONA returns #NUM! If x or y are not integers, they are truncatedOpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoPOWER.
POISSONPOISSON
probability mass or cumulative distribution function of the Poisson distribution
POISSON(x,mean,cumulative)Argumentsx: number of eventsmean: mean of the distributioncumulative: whether to evaluate the mass function or the cumulative distribution functionNoteIf x is a non-integer it is truncated. If x < 0 this function returns a #NUM! error. If mean <= 0 POISSON returns the #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoNORMDIST,
WEIBULL.
PROBPROB
probability of an interval for a discrete (and finite) probability distribution
PROB(x_range,prob_range,lower_limit,upper_limit)Argumentsx_range: possible valuesprob_range: probabilities of the corresponding valueslower_limit: lower interval limitupper_limit: upper interval limit, defaults to lower_limitNoteIf the sum of the probabilities in prob_range is not equal to 1 this function returns a #NUM! error. If any value in prob_range is <=0 or > 1, this function returns a #NUM! error. If x_range and prob_range contain a different number of data entries, this function returns a #N/A error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoBINOMDIST,
CRITBINOM.
QUARTILEQUARTILE
the k-th quartile of the data points
QUARTILE(array,quart)Argumentsarray: data pointsquart: a number from 0 to 4, indicating which quartile to calculateNoteIf array is empty, this function returns a #NUM! error. If quart < 0 or quart > 4, this function returns a #NUM! error. If quart = 0, the smallest value of array to be returned. If quart is not an integer, it is truncated.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoLARGE,
MAX,
MEDIAN,
MIN,
PERCENTILE,
SMALL.
R.DBETAR.DBETA
probability density function of the beta distribution
R.DBETA(x,a,b,give_log)Argumentsx: observationa: the first shape parameter of the distributionb: the second scale parameter of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the beta distribution.See alsoR.PBETA,
R.QBETA.
R.DBINOMR.DBINOM
probability density function of the binomial distribution
R.DBINOM(x,n,psuc,give_log)Argumentsx: observationn: the number of trialspsuc: the probability of success in each trialgive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the binomial distribution.See alsoR.PBINOM,
R.QBINOM.
R.DCAUCHYR.DCAUCHY
probability density function of the Cauchy distribution
R.DCAUCHY(x,location,scale,give_log)Argumentsx: observationlocation: the center of the distributionscale: the scale parameter of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the Cauchy distribution.See alsoR.PCAUCHY,
R.QCAUCHY.
R.DCHISQR.DCHISQ
probability density function of the chi-square distribution
R.DCHISQ(x,df,give_log)Argumentsx: observationdf: the number of degrees of freedom of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the chi-square distribution.OpenDocument Format (ODF) CompatibilityA two argument invocation R.DCHISQ(x,df) is exported to OpenFormula as CHISQDIST(x,df,FALSE()).See alsoR.PCHISQ,
R.QCHISQ.
R.DEXPR.DEXP
probability density function of the exponential distribution
R.DEXP(x,scale,give_log)Argumentsx: observationscale: the scale parameter of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the exponential distribution.See alsoR.PEXP,
R.QEXP.
R.DFR.DF
probability density function of the F distribution
R.DF(x,n1,n2,give_log)Argumentsx: observationn1: the first number of degrees of freedom of the distributionn2: the second number of degrees of freedom of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the F distribution.See alsoR.PF,
R.QF.
R.DGAMMAR.DGAMMA
probability density function of the gamma distribution
R.DGAMMA(x,shape,scale,give_log)Argumentsx: observationshape: the shape parameter of the distributionscale: the scale parameter of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the gamma distribution.See alsoR.PGAMMA,
R.QGAMMA.
R.DGEOMR.DGEOM
probability density function of the geometric distribution
R.DGEOM(x,psuc,give_log)Argumentsx: observationpsuc: the probability of success in each trialgive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the geometric distribution.See alsoR.PGEOM,
R.QGEOM.
R.DHYPERR.DHYPER
probability density function of the hypergeometric distribution
R.DHYPER(x,r,b,n,give_log)Argumentsx: observationr: the number of red ballsb: the number of black ballsn: the number of balls drawngive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the hypergeometric distribution.See alsoR.PHYPER,
R.QHYPER.
R.DLNORMR.DLNORM
probability density function of the log-normal distribution
R.DLNORM(x,logmean,logsd,give_log)Argumentsx: observationlogmean: mean of the underlying normal distributionlogsd: standard deviation of the underlying normal distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the log-normal distribution.See alsoR.PLNORM,
R.QLNORM.
R.DNBINOMR.DNBINOM
probability density function of the negative binomial distribution
R.DNBINOM(x,n,psuc,give_log)Argumentsx: observationn: the number of trialspsuc: the probability of success in each trialgive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the negative binomial distribution.See alsoR.PNBINOM,
R.QNBINOM.
R.DNORMR.DNORM
probability density function of the normal distribution
R.DNORM(x,mu,sigma,give_log)Argumentsx: observationmu: mean of the distributionsigma: standard deviation of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the normal distribution.See alsoR.PNORM,
R.QNORM.
R.DPOISR.DPOIS
probability density function of the Poisson distribution
R.DPOIS(x,lambda,give_log)Argumentsx: observationlambda: the mean of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the Poisson distribution.See alsoR.PPOIS,
R.QPOIS.
R.DSNORMR.DSNORM
probability density function of the skew-normal distribution
R.DSNORM(x,shape,location,scale,give_log)Argumentsx: observationshape: the shape parameter of the distributionlocation: the location parameter of the distributionscale: the scale parameter of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the skew-normal distribution.See alsoR.PSNORM.
R.DSTR.DST
probability density function of the skew-t distribution
R.DST(x,n,shape,give_log)Argumentsx: observationn: the number of degrees of freedom of the distributionshape: the shape parameter of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the skew-t distribution.R.DTR.DT
probability density function of the Student t distribution
R.DT(x,n,give_log)Argumentsx: observationn: the number of degrees of freedom of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the Student t distribution.See alsoR.PT,
R.QT.
R.DWEIBULLR.DWEIBULL
probability density function of the Weibull distribution
R.DWEIBULL(x,shape,scale,give_log)Argumentsx: observationshape: the shape parameter of the distributionscale: the scale parameter of the distributiongive_log: if true, log of the result will be returned insteadDescriptionThis function returns the probability density function of the Weibull distribution.See alsoR.PWEIBULL,
R.QWEIBULL.
R.PBETAR.PBETA
cumulative distribution function of the beta distribution
R.PBETA(x,a,b,lower_tail,log_p)Argumentsx: observationa: the first shape parameter of the distributionb: the second scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the beta distribution.See alsoR.DBETA,
R.QBETA.
R.PBINOMR.PBINOM
cumulative distribution function of the binomial distribution
R.PBINOM(x,n,psuc,lower_tail,log_p)Argumentsx: observationn: the number of trialspsuc: the probability of success in each triallower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the binomial distribution.See alsoR.DBINOM,
R.QBINOM.
R.PCAUCHYR.PCAUCHY
cumulative distribution function of the Cauchy distribution
R.PCAUCHY(x,location,scale,lower_tail,log_p)Argumentsx: observationlocation: the center of the distributionscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the Cauchy distribution.See alsoR.DCAUCHY,
R.QCAUCHY.
R.PCHISQR.PCHISQ
cumulative distribution function of the chi-square distribution
R.PCHISQ(x,df,lower_tail,log_p)Argumentsx: observationdf: the number of degrees of freedom of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the chi-square distribution.OpenDocument Format (ODF) CompatibilityA two argument invocation R.PCHISQ(x,df) is exported to OpenFormula as CHISQDIST(x,df).See alsoR.DCHISQ,
R.QCHISQ.
R.PEXPR.PEXP
cumulative distribution function of the exponential distribution
R.PEXP(x,scale,lower_tail,log_p)Argumentsx: observationscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the exponential distribution.See alsoR.DEXP,
R.QEXP.
R.PFR.PF
cumulative distribution function of the F distribution
R.PF(x,n1,n2,lower_tail,log_p)Argumentsx: observationn1: the first number of degrees of freedom of the distributionn2: the second number of degrees of freedom of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the F distribution.See alsoR.DF,
R.QF.
R.PGAMMAR.PGAMMA
cumulative distribution function of the gamma distribution
R.PGAMMA(x,shape,scale,lower_tail,log_p)Argumentsx: observationshape: the shape parameter of the distributionscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the gamma distribution.See alsoR.DGAMMA,
R.QGAMMA.
R.PGEOMR.PGEOM
cumulative distribution function of the geometric distribution
R.PGEOM(x,psuc,lower_tail,log_p)Argumentsx: observationpsuc: the probability of success in each triallower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the geometric distribution.See alsoR.DGEOM,
R.QGEOM.
R.PHYPERR.PHYPER
cumulative distribution function of the hypergeometric distribution
R.PHYPER(x,r,b,n,lower_tail,log_p)Argumentsx: observationr: the number of red ballsb: the number of black ballsn: the number of balls drawnlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the hypergeometric distribution.See alsoR.DHYPER,
R.QHYPER.
R.PLNORMR.PLNORM
cumulative distribution function of the log-normal distribution
R.PLNORM(x,logmean,logsd,lower_tail,log_p)Argumentsx: observationlogmean: mean of the underlying normal distributionlogsd: standard deviation of the underlying normal distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the log-normal distribution.See alsoR.DLNORM,
R.QLNORM.
R.PNBINOMR.PNBINOM
cumulative distribution function of the negative binomial distribution
R.PNBINOM(x,n,psuc,lower_tail,log_p)Argumentsx: observationn: the number of trialspsuc: the probability of success in each triallower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the negative binomial distribution.See alsoR.DNBINOM,
R.QNBINOM.
R.PNORMR.PNORM
cumulative distribution function of the normal distribution
R.PNORM(x,mu,sigma,lower_tail,log_p)Argumentsx: observationmu: mean of the distributionsigma: standard deviation of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the normal distribution.See alsoR.DNORM,
R.QNORM.
R.PPOISR.PPOIS
cumulative distribution function of the Poisson distribution
R.PPOIS(x,lambda,lower_tail,log_p)Argumentsx: observationlambda: the mean of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the Poisson distribution.See alsoR.DPOIS,
R.QPOIS.
R.PSNORMR.PSNORM
cumulative distribution function of the skew-normal distribution
R.PSNORM(x,shape,location,scale,lower_tail,log_p)Argumentsx: observationshape: the shape parameter of the distributionlocation: the location parameter of the distributionscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the skew-normal distribution.See alsoR.DSNORM.
R.PTR.PT
cumulative distribution function of the Student t distribution
R.PT(x,n,lower_tail,log_p)Argumentsx: observationn: the number of degrees of freedom of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the Student t distribution.See alsoR.DT,
R.QT.
R.PWEIBULLR.PWEIBULL
cumulative distribution function of the Weibull distribution
R.PWEIBULL(x,shape,scale,lower_tail,log_p)Argumentsx: observationshape: the shape parameter of the distributionscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the cumulative distribution function of the Weibull distribution.See alsoR.DWEIBULL,
R.QWEIBULL.
R.QBETAR.QBETA
probability quantile function of the beta distribution
R.QBETA(p,a,b,lower_tail,log_p)Argumentsp: probabilitya: the first shape parameter of the distributionb: the second scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the beta distribution.See alsoR.DBETA,
R.PBETA.
R.QBINOMR.QBINOM
probability quantile function of the binomial distribution
R.QBINOM(x,n,psuc,lower_tail,log_p)Argumentsx: observationn: the number of trialspsuc: the probability of success in each triallower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the binomial distribution.See alsoR.DBINOM,
R.PBINOM.
R.QCAUCHYR.QCAUCHY
probability quantile function of the Cauchy distribution
R.QCAUCHY(p,location,scale,lower_tail,log_p)Argumentsp: probabilitylocation: the center of the distributionscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the Cauchy distribution.See alsoR.DCAUCHY,
R.PCAUCHY.
R.QCHISQR.QCHISQ
probability quantile function of the chi-square distribution
R.QCHISQ(p,df,lower_tail,log_p)Argumentsp: probabilitydf: the number of degrees of freedom of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the chi-square distribution.OpenDocument Format (ODF) CompatibilityA two argument invocation R.QCHISQ(p,df) is exported to OpenFormula as CHISQINV(p,df).See alsoR.DCHISQ,
R.PCHISQ.
R.QEXPR.QEXP
probability quantile function of the exponential distribution
R.QEXP(p,scale,lower_tail,log_p)Argumentsp: probabilityscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the exponential distribution.See alsoR.DEXP,
R.PEXP.
R.QFR.QF
probability quantile function of the F distribution
R.QF(x,n1,n2,lower_tail,log_p)Argumentsx: observationn1: the first number of degrees of freedom of the distributionn2: the second number of degrees of freedom of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the F distribution.See alsoR.DF,
R.PF.
R.QGAMMAR.QGAMMA
probability quantile function of the gamma distribution
R.QGAMMA(p,shape,scale,lower_tail,log_p)Argumentsp: probabilityshape: the shape parameter of the distributionscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the gamma distribution.See alsoR.DGAMMA,
R.PGAMMA.
R.QGEOMR.QGEOM
probability quantile function of the geometric distribution
R.QGEOM(p,psuc,lower_tail,log_p)Argumentsp: probabilitypsuc: the probability of success in each triallower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the geometric distribution.See alsoR.DGEOM,
R.PGEOM.
R.QHYPERR.QHYPER
probability quantile function of the hypergeometric distribution
R.QHYPER(p,r,b,n,lower_tail,log_p)Argumentsp: probabilityr: the number of red ballsb: the number of black ballsn: the number of balls drawnlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the hypergeometric distribution.See alsoR.DHYPER,
R.PHYPER.
R.QLNORMR.QLNORM
probability quantile function of the log-normal distribution
R.QLNORM(x,logmean,logsd,lower_tail,log_p)Argumentsx: observationlogmean: mean of the underlying normal distributionlogsd: standard deviation of the underlying normal distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the log-normal distribution.See alsoR.DLNORM,
R.PLNORM.
R.QNBINOMR.QNBINOM
probability quantile function of the negative binomial distribution
R.QNBINOM(p,n,psuc,lower_tail,log_p)Argumentsp: probabilityn: the number of trialspsuc: the probability of success in each triallower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the negative binomial distribution.See alsoR.DNBINOM,
R.PNBINOM.
R.QNORMR.QNORM
probability quantile function of the normal distribution
R.QNORM(p,mu,sigma,lower_tail,log_p)Argumentsp: probabilitymu: mean of the distributionsigma: standard deviation of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the normal distribution.See alsoR.DNORM,
R.PNORM.
R.QPOISR.QPOIS
probability quantile function of the Poisson distribution
R.QPOIS(p,lambda,lower_tail,log_p)Argumentsp: probabilitylambda: the mean of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the Poisson distribution.See alsoR.DPOIS,
R.PPOIS.
R.QTR.QT
probability quantile function of the Student t distribution
R.QT(p,n,lower_tail,log_p)Argumentsp: probabilityn: the number of degrees of freedom of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the Student t distribution.See alsoR.DT,
R.PT.
R.QWEIBULLR.QWEIBULL
probability quantile function of the Weibull distribution
R.QWEIBULL(p,shape,scale,lower_tail,log_p)Argumentsp: probabilityshape: the shape parameter of the distributionscale: the scale parameter of the distributionlower_tail: if true (the default), the lower tail of the distribution is consideredlog_p: if true, log of the probability is usedDescriptionThis function returns the probability quantile function, i.e., the inverse of the cumulative distribution function, of the Weibull distribution.See alsoR.DWEIBULL,
R.PWEIBULL.
RANKRANK
rank of a number in a list of numbers
RANK(x,ref,order)Argumentsx: number whose rank you want to findref: list of numbersorder: 0 (descending order) or non-zero (ascending order); defaults to 0NoteIn case of a tie, RANK returns the largest possible rank.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPERCENTRANK,
RANK.AVG.
RANK.AVGRANK.AVG
rank of a number in a list of numbers
RANK.AVG(x,ref,order)Argumentsx: number whose rank you want to findref: list of numbersorder: 0 (descending order) or non-zero (ascending order); defaults to 0NoteIn case of a tie, RANK returns the average rank.Microsoft Excel CompatibilityThis function is Excel 2010 compatible.See alsoPERCENTRANK,
RANK.
RAYLEIGHRAYLEIGH
probability density function of the Rayleigh distribution
RAYLEIGH(x,sigma)Argumentsx: numbersigma: scale parameterSee alsoRANDRAYLEIGH.
RAYLEIGHTAILRAYLEIGHTAIL
probability density function of the Rayleigh tail distribution
RAYLEIGHTAIL(x,a,sigma)Argumentsx: numbera: lower limitsigma: scale parameterSee alsoRANDRAYLEIGHTAIL.
RSQRSQ
square of the Pearson correlation coefficient of the paired set of data
RSQ(array1,array2)Argumentsarray1: first component valuesarray2: second component valuesDescriptionStrings and empty cells are simply ignored.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoCORREL,
COVAR,
INTERCEPT,
LINEST,
LOGEST,
PEARSON,
SLOPE,
STEYX,
TREND.
SFTESTSFTEST
Shapiro-Francia Test of Normality
SFTEST(x)Argumentsx: array of sample valuesDescriptionThis function returns an array with the first row giving the p-value of the Shapiro-Francia Test, the second row the test statistic of the test, and the third the number of observations in the sample.NoteIf there are less than 5 or more than 5000 sample values, SFTEST returns #VALUE!See alsoCHITEST,
ADTEST,
LKSTEST,
CVMTEST.
SKEWSKEW
unbiased estimate for skewness of a distribution
SKEW(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionStrings and empty cells are simply ignored.NoteThis is only meaningful if the underlying distribution really has a third moment. The skewness of a symmetric (e.g., normal) distribution is zero. If less than three numbers are given, this function returns a #DIV/0! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
VAR,
SKEWP,
KURT.
SKEWPSKEWP
population skewness of a data set
SKEWP(number1,number2,…)Argumentsnumber1: first valuenumber2: second valueDescriptionStrings and empty cells are simply ignored.NoteIf less than two numbers are given, SKEWP returns a #DIV/0! error.See alsoAVERAGE,
VARP,
SKEW,
KURTP.
SLOPESLOPE
the slope of a linear regression line
SLOPE(known_ys,known_xs)Argumentsknown_ys: known y-valuesknown_xs: known x-valuesNoteIf known_xs or known_ys contains no data entries or different number of data entries, this function returns a #N/A error. If the variance of the known_xs is zero, this function returns #DIV/0 error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoSTDEV,
STDEVPA.
SMALLSMALLk-th smallest value in a data set
SMALL(data,k)Argumentsdata: data setk: which value to findNoteIf data set is empty this function returns a #NUM! error. If k <= 0 or k is greater than the number of data items given this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPERCENTILE,
PERCENTRANK,
QUARTILE,
LARGE.
SSMEDIANSSMEDIAN
median for grouped data
SSMEDIAN(array,interval)Argumentsarray: data setinterval: length of each grouping interval, defaults to 1DescriptionThe data are assumed to be grouped into intervals of width interval. Each data point in array is the midpoint of the interval containing the true value. The median is calculated by interpolation within the median interval (the interval containing the median value), assuming that the true values within that interval are distributed uniformly:median = L + interval*(N/2 - CF)/Fwhere:L = the lower limit of the median intervalN = the total number of data pointsCF = the number of data points below the median intervalF = the number of data points in the median intervalNoteIf array is empty, this function returns a #NUM! error. If interval <= 0, this function returns a #NUM! error. SSMEDIAN does not check whether the data points are at least interval apart.See alsoMEDIAN.
STANDARDIZESTANDARDIZE
z-score of a value
STANDARDIZE(x,mean,stddev)Argumentsx: valuemean: mean of the original distributionstddev: standard deviation of the original distributionNoteIf stddev is 0 this function returns a #DIV/0! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE.
STDEVSTDEV
sample standard deviation of the given sample
STDEV(area1,area2,…)Argumentsarea1: first cell areaarea2: second cell areaDescriptionSTDEV is also known as the N-1-standard deviation.To obtain the population standard deviation of a whole population use STDEVP.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
DSTDEV,
DSTDEVP,
STDEVA,
STDEVPA,
VAR.
STDEVASTDEVA
sample standard deviation of the given sample
STDEVA(area1,area2,…)Argumentsarea1: first cell areaarea2: second cell areaDescriptionSTDEVA is also known as the N-1-standard deviation.To obtain the population standard deviation of a whole population use STDEVPA.Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoSTDEV,
STDEVPA.
STDEVPSTDEVP
population standard deviation of the given population
STDEVP(area1,area2,…)Argumentsarea1: first cell areaarea2: second cell areaDescriptionThis is also known as the N-standard deviationMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoSTDEV,
STDEVA,
STDEVPA.
STDEVPASTDEVPA
population standard deviation of an entire population
STDEVPA(area1,area2,…)Argumentsarea1: first cell areaarea2: second cell areaDescriptionThis is also known as the N-standard deviationNumbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoSTDEVA,
STDEVP.
STEYXSTEYX
standard error of the predicted y-value in the regression
STEYX(known_ys,known_xs)Argumentsknown_ys: known y-valuesknown_xs: known x-valuesNoteIf known_ys and known_xs are empty or have a different number of arguments then this function returns a #N/A error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPEARSON,
RSQ,
SLOPE.
SUBTOTALSUBTOTAL
the subtotal of the given list of arguments
SUBTOTAL(function_nbr,ref1,ref2,…)Argumentsfunction_nbr: determines which function to use according to the following table: 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARPref1: first valueref2: second valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCOUNT,
SUM.
TDISTTDIST
survival function of the Student t-distribution
TDIST(x,dof,tails)Argumentsx: numberdof: number of degrees of freedomtails: 1 or 2DescriptionThe survival function is 1 minus the cumulative distribution function.This function is Excel compatible for non-negative x.NoteIf dof < 1 this function returns a #NUM! error. If tails is neither 1 or 2 this function returns a #NUM! error. The parameterization of this function is different from what is used for, e.g., NORMSDIST. This is a common source of mistakes, but necessary for compatibility.See alsoTINV,
TTEST.
TINVTINV
inverse of the survival function of the Student t-distribution
TINV(p,dof)Argumentsp: probabilitydof: number of degrees of freedomDescriptionThe survival function is 1 minus the cumulative distribution function.NoteIf p < 0 or p > 1 or dof < 1 this function returns a #NUM! error. The parameterization of this function is different from what is used for, e.g., NORMSINV. This is a common source of mistakes, but necessary for compatibility.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoTDIST,
TTEST.
TRENDTREND
estimates future values of a given data set using a least squares approximation
TREND(known_ys,known_xs,new_xs,affine)Argumentsknown_ys: vector of values of dependent variableknown_xs: array of values of independent variables, defaults to a single vector {1,…,n}new_xs: array of x-values for which to estimate the y-values; defaults to known_xsaffine: if true, the model contains a constant term, defaults to trueNoteIf the length of known_ys does not match the corresponding length of known_xs, this function returns a #NUM! error.See alsoLINEST.
TRIMMEANTRIMMEAN
mean of the interior of a data set
TRIMMEAN(ref,fraction)Argumentsref: list of numbers whose mean you want to calculatefraction: fraction of the data set excluded from the meanDescriptionIf fraction=0.2 and the data set contains 40 numbers, 8 numbers are trimmed from the data set (40 x 0.2): the 4 largest and the 4 smallest. To avoid a bias, the number of points to be excluded is always rounded down to the nearest even number.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoAVERAGE,
GEOMEAN,
HARMEAN,
MEDIAN,
MODE.
TTESTTTEST
p-value for a hypothesis test comparing the means of two populations using the Student t-distribution
TTEST(array1,array2,tails,type)Argumentsarray1: sample from the first populationarray2: sample from the second populationtails: number of tails to considertype: Type of test to perform. 1 indicates a test for paired variables, 2 a test of unpaired variables with equal variances, and 3 a test of unpaired variables with unequal variancesNoteIf the data sets contain a different number of data points and the test is paired (type one), TTEST returns the #N/A error. tails and type are truncated to integers. If tails is not one or two, this function returns a #NUM! error. If type is any other than one, two, or three, this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoFDIST,
FINV.
VARVAR
sample variance of the given sample
VAR(area1,area2,…)Argumentsarea1: first cell areaarea2: second cell areaDescriptionVAR is also known as the N-1-variance.NoteSince the N-1-variance includes Bessel's correction, whereas the N-variance calculated by VARPA or VARP does not, under reasonable conditions the N-1-variance is an unbiased estimator of the variance of the population from which the sample is drawn.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoVARP,
STDEV,
VARA.
VARAVARA
sample variance of the given sample
VARA(area1,area2,…)Argumentsarea1: first cell areaarea2: second cell areaDescriptionVARA is also known as the N-1-variance.To get the true variance of a complete population use VARPA.Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.NoteSince the N-1-variance includes Bessel's correction, whereas the N-variance calculated by VARPA or VARP does not, under reasonable conditions the N-1-variance is an unbiased estimator of the variance of the population from which the sample is drawn.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoVAR,
VARPA.
VARPVARP
variance of an entire population
VARP(area1,area2,…)Argumentsarea1: first cell areaarea2: second cell areaDescriptionVARP is also known as the N-variance.See alsoAVERAGE,
DVAR,
DVARP,
STDEV,
VAR.
VARPAVARPA
variance of an entire population
VARPA(area1,area2,…)Argumentsarea1: first cell areaarea2: second cell areaDescriptionVARPA is also known as the N-variance.Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoVARA,
VARP.
WEIBULLWEIBULL
probability density or cumulative distribution function of the Weibull distribution
WEIBULL(x,alpha,beta,cumulative)Argumentsx: numberalpha: scale parameterbeta: scale parametercumulative: whether to evaluate the density function or the cumulative distribution functionDescriptionIf the cumulative boolean is true it will return: 1 - exp (-(x/beta)^alpha),otherwise it will return (alpha/beta^alpha) * x^(alpha-1) * exp(-(x/beta^alpha)).NoteIf x < 0 this function returns a #NUM! error. If alpha <= 0 or beta <= 0 this function returns a #NUM! error.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoPOISSON.
ZTESTZTEST
the probability of observing a sample mean as large as or larger than the mean of the given sample
ZTEST(ref,x,stddev)Argumentsref: data set (sample)x: population meanstddev: population standard deviation, defaults to the sample standard deviationDescriptionZTEST calulates the probability of observing a sample mean as large as or larger than the mean of the given sample for samples drawn from a normal distribution with mean x and standard deviation stddev.NoteIf ref contains less than two data items ZTEST returns #DIV/0! error.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoCONFIDENCE,
NORMDIST,
NORMINV,
NORMSDIST,
NORMSINV,
STANDARDIZE.
StringASCASC
text with full-width katakana and ASCII characters converted to half-width
ASC(text)Argumentstext: stringDescriptionASC converts full-width katakana and ASCII characters to half-width equivalent characters, copying all others. The distinction between half-width and full-width characters is described in http://www.unicode.org/reports/tr11/.NoteWhile in obsolete encodings ASC used to translate between 2-byte and 1-byte characters, this is not the case in UTF-8.Microsoft Excel CompatibilityFor most strings, this function has the same effect as in Excel.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoJIS.
CHARCHAR
the CP1252 (Windows-1252) character for the code point xCHAR(x)Argumentsx: code pointDescriptionCHAR(x) returns the CP1252 (Windows-1252) character with code x.x must be in the range 1 to 255.CP1252 (Windows-1252) is also known as the "ANSI code page", but it is not an ANSI standard.CP1252 (Windows-1252) is based on an early draft of ISO-8859-1, and contains all of its printable characters. It also contains all of ISO-8859-15's printable characters (but partially at different positions.)This function is Excel compatible.NoteIn CP1252 (Windows-1252), 129, 141, 143, 144, and 157 do not have matching characters. For x from 1 to 255 except 129, 141, 143, 144, and 157 we have CODE(CHAR(x))=x.See alsoCODE.
CLEANCLEANtext with any non-printable characters removed
CLEAN(text)Argumentstext: stringDescriptionCLEAN removes non-printable characters from its argument leaving only regular characters and white-space.Microsoft Excel CompatibilityThis function is Excel compatible.CODECODE
the CP1252 (Windows-1252) code point for the character cCODE(c)Argumentsc: characterDescriptionc must be a valid CP1252 (Windows-1252) character.CP1252 (Windows-1252) is also known as the "ANSI code page", but it is not an ANSI standard.CP1252 (Windows-1252) is based on an early draft of ISO-8859-1, and contains all of its printable characters (but partially at different positions.)This function is Excel compatible.NoteIn CP1252 (Windows-1252), 129, 141, 143, 144, and 157 do not have matching characters. For x from 1 to 255 except 129, 141, 143, 144, and 157 we have CODE(CHAR(x))=x.See alsoCHAR.
CONCATENATECONCATENATE
the concatenation of the strings s1, s2,…
CONCATENATE(s1,s2,…)Argumentss1: first strings2: second stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoLEFT,
MID,
RIGHT.
DOLLARDOLLARnum formatted as currency
DOLLAR(num,decimals)Argumentsnum: numberdecimals: decimalsMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoFIXED,
TEXT,
VALUE.
EXACTEXACT
TRUE if string1 is exactly equal to string2EXACT(string1,string2)Argumentsstring1: first stringstring2: second stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoLEN,
SEARCH,
DELTA.
FINDFIND
first position of string1 in string2 following position startFIND(string1,string2,start)Argumentsstring1: search stringstring2: search fieldstart: starting position, defaults to 1NoteThis search is case-sensitive.Microsoft Excel CompatibilityThis function is Excel compatible.See alsoEXACT,
LEN,
MID,
SEARCH.
FINDBFINDB
first byte position of string1 in string2 following byte position startFINDB(string1,string2,start)Argumentsstring1: search stringstring2: search fieldstart: starting byte position, defaults to 1NoteThis search is case-sensitive.Microsoft Excel CompatibilityWhile this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.OpenDocument Format (ODF) CompatibilityWhile this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.See alsoFIND,
LEFTB,
RIGHTB,
LENB,
LEFT,
MID,
RIGHT,
LEN.
FIXEDFIXED
formatted string representation of numFIXED(num,decimals,no_commas)Argumentsnum: numberdecimals: number of decimalsno_commas: TRUE if no thousand separators should be used, defaults to FALSEMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoTEXT,
VALUE,
DOLLAR.
JISJIS
text with half-width katakana and ASCII characters converted to full-width
JIS(text)Argumentstext: original textDescriptionJIS converts half-width katakana and ASCII characters to full-width equivalent characters, copying all others. The distinction between half-width and full-width characters is described in http://www.unicode.org/reports/tr11/.NoteWhile in obsolete encodings JIS used to translate between 1-byte and 2-byte characters, this is not the case in UTF-8.Microsoft Excel CompatibilityFor most strings, this function has the same effect as in Excel.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoASC.
LEFTLEFT
the first num_chars characters of the string sLEFT(s,num_chars)Argumentss: the stringnum_chars: the number of characters to return (defaults to 1)NoteIf the string s is in a right-to-left script, the returned first characters are from the right of the string.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoMID,
RIGHT,
LEN,
MIDB,
RIGHTB,
LENB.
LEFTBLEFTB
the first characters of the string s comprising at most num_bytes bytes
LEFTB(s,num_bytes)Argumentss: the stringnum_bytes: the maximum number of bytes to return (defaults to 1)NoteThe semantics of this function is subject to change as various applications implement it. If the string is in a right-to-left script, the returned first characters are from the right of the string.Microsoft Excel CompatibilityWhile this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.OpenDocument Format (ODF) CompatibilityWhile this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.See alsoMIDB,
RIGHTB,
LENB,
LEFT,
MID,
RIGHT,
LEN.
LENLEN
the number of characters of the string sLEN(s)Argumentss: the stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCHAR,
CODE,
LENB.
LENBLENB
the number of bytes in the string sLENB(s)Argumentss: the stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCHAR,
CODE,
LEN.
LOWERLOWER
a lower-case version of the string textLOWER(text)Argumentstext: stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoUPPER.
MIDMID
the substring of the string s starting at position position consisting of length characters
MID(s,position,length)Argumentss: the stringposition: the starting positionlength: the number of characters to returnMicrosoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoLEFT,
RIGHT,
LEN,
LEFTB,
MIDB,
RIGHTB,
LENB.
MIDBMIDB
the characters following the first start_pos bytes comprising at most num_bytes bytes
MIDB(s,start_pos,num_bytes)Argumentss: the stringstart_pos: the number of the byte with which to start (defaults to 1)num_bytes: the maximum number of bytes to return (defaults to 1)NoteThe semantics of this function is subject to change as various applications implement it.Microsoft Excel CompatibilityWhile this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.OpenDocument Format (ODF) CompatibilityWhile this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.See alsoLEFTB,
RIGHTB,
LENB,
LEFT,
MID,
RIGHT,
LEN.
NUMBERVALUENUMBERVALUE
numeric value of textNUMBERVALUE(text,separator)Argumentstext: stringseparator: decimal separatorNoteIf text does not look like a decimal number, NUMBERVALUE returns the value VALUE would return (ignoring the given separator).OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoVALUE.
PROPERPROPERtext with initial of each word capitalised
PROPER(text)Argumentstext: stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoLOWER,
UPPER.
REPLACEREPLACE
string old with num characters starting at start replaced by newREPLACE(old,start,num,new)Argumentsold: original textstart: starting positionnum: number of characters to be replacednew: replacement stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoMID,
SEARCH,
SUBSTITUTE,
TRIM.
REPLACEBREPLACEB
string old with up to num bytes starting at start replaced by newREPLACEB(old,start,num,new)Argumentsold: original textstart: starting byte positionnum: number of bytes to be replacednew: replacement stringDescriptionREPLACEB replaces the string of valid unicode characters starting at the byte start and ending at start+num-1 with the string new.NoteThe semantics of this function is subject to change as various applications implement it.Microsoft Excel CompatibilityWhile this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.OpenDocument Format (ODF) CompatibilityWhile this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.See alsoMID,
SEARCH,
SUBSTITUTE,
TRIM.
REPTREPTnum repetitions of string textREPT(text,num)Argumentstext: stringnum: non-negative integerMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCONCATENATE.
RIGHTRIGHT
the last num_chars characters of the string sRIGHT(s,num_chars)Argumentss: the stringnum_chars: the number of characters to return (defaults to 1)NoteIf the string s is in a right-to-left script, the returned last characters are from the left of the string.Microsoft Excel CompatibilityThis function is Excel compatible.OpenDocument Format (ODF) CompatibilityThis function is OpenFormula compatible.See alsoLEFT,
MID,
LEN,
LEFTB,
MIDB,
RIGHTB,
LENB.
RIGHTBRIGHTB
the last characters of the string s comprising at most num_bytes bytes
RIGHTB(s,num_bytes)Argumentss: the stringnum_bytes: the maximum number of bytes to return (defaults to 1)NoteThe semantics of this function is subject to change as various applications implement it. If the string s is in a right-to-left script, the returned last characters are from the left of the string.Microsoft Excel CompatibilityWhile this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.OpenDocument Format (ODF) CompatibilityWhile this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.See alsoLEFTB,
MIDB,
LENB,
LEFT,
MID,
RIGHT,
LEN.
SEARCHSEARCH
the location of the search string within text after position startSEARCH(search,text,start)Argumentssearch: search stringtext: search fieldstart: starting position, defaults to 1Descriptionsearch may contain wildcard characters (*) and question marks (?). A question mark matches any single character, and a wildcard matches any string including the empty string. To search for * or ?, precede the symbol with ~.NoteThis search is not case sensitive. If search is not found, SEARCH returns #VALUE! If start is less than one or it is greater than the length of text, SEARCH returns #VALUE!Microsoft Excel CompatibilityThis function is Excel compatible.See alsoFIND,
SEARCHB.
SEARCHBSEARCHB
the location of the search string within text after byte position startSEARCHB(search,text,start)Argumentssearch: search stringtext: search fieldstart: starting byte position, defaults to 1Descriptionsearch may contain wildcard characters (*) and question marks (?). A question mark matches any single character, and a wildcard matches any string including the empty string. To search for * or ?, precede the symbol with ~.NoteThis search is not case sensitive. If search is not found, SEARCHB returns #VALUE! If start is less than one or it is greater than the byte length of text, SEARCHB returns #VALUE! The semantics of this function is subject to change as various applications implement it.Microsoft Excel CompatibilityWhile this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.OpenDocument Format (ODF) CompatibilityWhile this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.See alsoFINDB,
SEARCH.
SUBSTITUTESUBSTITUTEtext with all occurrences of old replaced by newSUBSTITUTE(text,old,new,num)Argumentstext: original textold: string to be replacednew: replacement stringnum: if num is specified and a number only the numth occurrence of old is replacedMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoREPLACE,
TRIM.
TTvalue if and only if value is text, otherwise empty
T(value)Argumentsvalue: original valueMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCELL,
N,
VALUE.
TEXTTEXTvalue as a string formatted as formatTEXT(value,format)Argumentsvalue: value to be formattedformat: desired formatMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoDOLLAR,
FIXED,
VALUE.
TRIMTRIMtext with only single spaces between words
TRIM(text)Argumentstext: stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoCLEAN,
MID,
REPLACE,
SUBSTITUTE.
UNICHARUNICHAR
the Unicode character represented by the Unicode code point xUNICHAR(x)Argumentsx: Unicode code pointSee alsoCHAR,
UNICODE,
CODE.
UNICODEUNICODE
the Unicode code point for the character cUNICODE(c)Argumentsc: characterSee alsoUNICHAR,
CODE,
CHAR.
UPPERUPPER
an upper-case version of the string textUPPER(text)Argumentstext: stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoLOWER.
VALUEVALUE
numeric value of textVALUE(text)Argumentstext: stringMicrosoft Excel CompatibilityThis function is Excel compatible.See alsoDOLLAR,
FIXED,
TEXT.
Time Series AnalysisFOURIERFOURIER
Fourier or inverse Fourier transform
FOURIER(Sequence,Inverse,Separate)ArgumentsSequence: the data sequence to be transformedInverse: if true, the inverse Fourier transform is calculated, defaults to falseSeparate: if true, the real and imaginary parts are given separately, defaults to falseDescriptionThis array function returns the Fourier or inverse Fourier transform of the given data sequence.The output consists of one column of complex numbers if Separate is false and of two columns of real numbers if Separate is true.If Separate is true the first output column contains the real parts and the second column the imaginary parts.NoteIf Sequence is neither an n by 1 nor 1 by n array, this function returns #NUM!INTERPOLATIONINTERPOLATION
interpolated values corresponding to the given abscissa targets
INTERPOLATION(abscissae,ordinates,targets,interpolation)Argumentsabscissae: ordered abscissae of the given data pointsordinates: ordinates of the given data pointstargets: abscissae of the interpolated datainterpolation: method of interpolation, defaults to 0 ('linear')DescriptionThe output consists always of one column of numbers.Possible interpolation methods are:0: linear;1: linear with averaging;2: staircase;3: staircase with averaging;4: natural cubic spline;5: natural cubic spline with averaging.NoteThe abscissae must be given in increasing order. If any of interpolation methods 1 ('linear with averaging'), 3 ('staircase with averaging'), and 5 ('natural cubic spline with averaging') is used, the number of returned values is one less than the number of targets and the targets values must be given in increasing order. Strings and empty cells in abscissae and ordinates are ignored. If several target data are provided they must be in the same column in consecutive cells.See alsoPERIODOGRAM.
PERIODOGRAMPERIODOGRAM
periodogram of the given data
PERIODOGRAM(ordinates,filter,abscissae,interpolation,number)Argumentsordinates: ordinates of the given datafilter: windowing function to be used, defaults to no filterabscissae: abscissae of the given data, defaults to regularly spaced abscissaeinterpolation: method of interpolation, defaults to nonenumber: number of interpolated data pointsDescriptionIf an interpolation method is used, the number of returned values is one less than the number of targets and the targets values must be given in increasing order.The output consists always of one column of numbers.Possible interpolation methods are:0: linear;1: linear with averaging;2: staircase;3: staircase with averaging;4: natural cubic spline;5: natural cubic spline with averaging.Possible window functions are:0: no filter (rectangular window)1: Bartlett (triangular window)2: Hahn (cosine window)3: Welch (parabolic window)NoteStrings and empty cells in abscissae and ordinates are ignored. If several target data are provided they must be in the same column in consecutive cells.See alsoINTERPOLATION.
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/worksheets.xml0000644000000000000000000002350711634354176025373 0ustar rootrootOverview
Worksheets contain the elements, such as the cell grid area, which
provide the principal work entities for &gnum; users. The
worksheet grid area allows users to enter data, develop analyses
of these data, and display both data and results. Worksheets also
contain graphical elements such as graphs and widgets. The
worksheets are themselves grouped into a workbook which will be
stored in a &gnum; file. The manipulation of workbooks is
explained in while the material
below explains the manipulation of worksheets.
Worksheets contain both working elements and metadata
elements. The working elements include the data contents of cells
in the grid area, cell comments, cell formatting, and sheet
objects, such as graphical plots. The metadata include the
worksheet name and worksheet settings controlling the visual
appearance of the worksheet or the display of the worksheet.
This section explains the main ways to manipulate &gnum;
worksheets. explains
how to navigate the worksheet to change the area which is
displayed and change the currently selected area. presents several alternative
settings which alter the display of cell contents, of the grid
area, of the worksheet as a whole or of &gnum; itself. explains how to alter
settings which affect all the contents of the worksheet such as
the status of the content protection mechanism. gives a brief
explanation of the print settings which apply specifically to each
worksheet; a more complete explanation of the print settings is
given in . Finally, explains how the entire
collection of worksheets can be manipulated so as to add,
duplicate, delete or re-order the worksheets within a workbook.
Worksheet Navigation
&gnum; worksheets can be conceived of as a single, continuous,
two-dimensional grid of cells. However, &gnum; cannot display the
entire grid at once but only shows a portion of the
worksheet. Since only a portion of the worksheet can be seen at
any particular time, &gnum; provides users with several ways to
change the portion of the worksheet that is displayed. explains the
various ways that the display window can be moved to a different
section of the worksheet grid, while , further below, explains more
powerful methods to re-organize the display of the cell grid area.
Moving Around a WorksheetMoving the SelectionWorksheet Display
The display of each worksheet can be controlled by several
settings and configurations. The worksheet, conceptually, consists
of a single continuous two dimensional grid of cells arranged in
65536 rows by 258 columns, and &gnum;, by default, displays a
small portion of the worksheet area as a continuous region. This
chapter...
...or which allow
the user to rearrange the cell grid to fix parts of the worksheet
grid while scrolling others or to group rows or columns of data
within a worksheet for convenient editing and analysis...
Changing the default size of the &gnum; cell grid.
The worksheet grid is 65536 rows by 258 columns of cells, by
default. This can be changed but only by altering the computer
program files and recompiling the code to make a new version of
the &gnum; program.
AppearanceThe cell content appearance
This section has not yet been written.
Displaying Formulas or Results
This section has not yet been written.
Displaying Zeros or Blank cells
This section has not yet been written.
The grid area appearance
This section has not yet been written.
Displaying Gridlines
This section has not yet been written.
Displaying Row and Column Headers
This section has not yet been written.
The workbook appearance
This section has not yet been written.
Zoom: Changing the Scale of a View
This section has not yet been written.
Full Screen Mode
This section has not yet been written.
Displaying Workbook Tabs
This section has not yet been written.
Displaying Grid Area Scrollbars
This section has not yet been written.
Grouping Rows and ColumnsDisplay PanesGeneral SettingsContent ProtectionPrint SettingsManaging Worksheets
This section has not yet been written.
Alternative Approaches
This section has not yet been written.
Using the menu
This section has not yet been written.
Using the mouse
This section has not yet been written.
Using the context menu
This section has not yet been written.
Using the sheet management dialog
This section has not yet been written.
Adding a Blank Worksheet
This section has not yet been written.
Duplicating a Worksheet
This section has not yet been written.
Copying or Pasting a Worksheet
This section has not yet been written.
Renaming a Worksheet
This section has not yet been written.
Reordering Worksheets in a Workbook
This section has not yet been written.
Changing the appearance of Worksheet Tabs
This section has not yet been written.
Deleting Worksheets
This section has not yet been written.
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/files-saving.xml0000644000000000000000000013215711634354176025566 0ustar rootrootSaving Files
There are several ways to save a &gnum; workbook that is
currently open.
Existing files can be saved directly but this process does not
allow a user to change any settings to the file creation process.
Saving files directly
If the workbook has already been saved to a file
or if the workbook was opened from a file that already existed,
&gnum; will simply overwrite the file with the newer version.
Three alternative ways to save a file directlyUsing the Menus
Select, in the File menu, the
Save menu item.
Using the Standard Toolbar
Click on the Save button:
An image of the file save button.Using a Keyboard Shortcut
Type the combination
Ctrls,
typing both keys simultaneously.
Each of these approaches will save the file directly, allowing
no intervention on the part the user. If the file has been newly
created, &gnum; will automatically launch the Save
As... dialog asking the user for a file name and
other configuration options for the file, as is explained below.
Users wishing to save an existing file to a new file must invoke
the Save As... dialog. The Save
As... dialog can be invoked at any time to save the
current workbook to a new file with either a different name or a
different file format type. This dialog is automatically launched
when a user attempts to use one of the methods described above to
save a workbook which does not already have an existing file.
The Save As...
dialog asks the user to provide a name for the file to be
created, to select a folder in which to place the new file, and to
select a file format type for the file.
The steps required to save a file to a standard location.
Launch the File Save dialog.
In the File menu, select the
Save As menu item.
Name the file. Open the folder containing the desired file.
In the text entry area, enter the file name.
Select the desired folder in which to save the file.
Select one of the standard locations to open the file.
Specify a file format type.
Click on the Save button.
The remainder of this section explains these steps in greater
detail, first, by describing the components in the File
Save dialog and, then, by explaining each of the steps
above in greater detail.
Using the <interface>File Save</interface> dialog.
Saving a workbook to a file can be a simple process, depending
on the folder in which the file is to be saved. If this folder
is in the predefined list of standard folders and user bookmark
folders, the file can be created with the compact
File Save dialog. The components of the
compact File Save dialog and the
procedure to save a workbook to a file in the predefined list of
folders are explained next.
However, when the workbook is to be saved to a file created in a
folder which is not in the preselected list, the expanded
File Save dialog will be required. The
components of the expanded File Save
dialog, the procedure for saving files in a different folder,
and an explanation of bookmark folders and their use are given
further below.
The components of the compact <interface>File Save</interface>
dialog.
The File Save dialog allows the user to
save a workbook into a new file but requires that the user
provide a name for the file, select the folder in which to
save the file, and select a file format type to use for this
file. This dialog also provides a way to navigate the folder
hierarchy as will be explained further below.
The File Save dialog first opens in a
compact layout. The different areas of the dialog in this
compact layout are shown and labeled in .
The purpose of each labeled area will be explained below:
The components of the compact <interface>File
Save</interface> dialogA - The naming area.
This area is used to give the file its name. This is a
standard text entry area allowing all the basic
editing commands. The cursor can be moved left or
right using the keyboard arrow keys. The cursor can be
placed anywhere in the text by placing the mouse
pointer where the cursor should go and clicking with
the primary mouse button. The mouse can also select
part or all of the text with a click and drag. The
keyboard shortcuts for copying,
Ctrlc,
cutting,
Ctrlx,
or pasting,
Ctrlx,
all work. The dialog uses filename matching to guess
file names based on the files already in the parent
folder.
B - The folder
selection area.
This area provides a drop down list of previously
selected folders including the standard folders and
the folders which have been bookmarked by the
user. The area will be disabled if area D has been selected to expand
the dialog.
The desired folder can be selected by moving the mouse
pointer over the button, clicking and holding the
primary mouse button, dragging the mouse pointer onto
the name of the desired folder and releasing the mouse
button. The new folder name will appear on as the name
on the button.
C - The file format type
selection area.
This area provides a drop down list of all the file
formats provided by the &gnum; program itself and by
all the currently active plugins.
If the file format type named "Text export
(configurable)" is opened, this will start the text
export procedure. explains this
procedure in complete detail.
D - The dialog
expansion area.
This area will alter the dialog to expand or collapse
it. When expanded the dialog provides a way to select
any folder accessible on the system, to create new
folders and to add and remove bookmark folders from
the user's bookmark folder list. When the dialog is
expanded, the small arrow will point downward, the
areas showing in
will appear and area B will be disabled.
E - The button area.
This area provides two buttons, the
Cancel and the
Save buttons. Clicking the
Cancel button will dismiss the dialog
and return the user to the worksheet. Clicking the
Save button will cause a file to
be created with the currently selected name, parent folder
and format. If the selected file already exists, &gnum;
will open a confirmation dialog since the command will
obliterate the previously existing file.
The procedure to save a file using this dialog in its compact
form is present next, in . The
components of the dialog in its expanded layout, converted by
clicking in area D when the
File Save dialog is in its compact
form, will be explained further on, in ,
followed by sections explaining the use of the dialog in this
expanded layout.
The basic file saving procedure.
Saving a workbook to a new file requires providing name the
file, selecting a folder in which the file will be placed, and
selecting a file format type.
The default action, if a user simply opens the File
Save dialog and clicks on the
Save button, is to name the file
Book1.gnumeric incrementing the number
for each new file created, to save the file in the user's home
folder, and to create a file in the &gnum; file format.
If the user provides a name for the file to be saved which
is the same as the name of a file that already exists,
&gnum; will open up a confirmation dialog asking the user if
they really want to overwrite the existing file. If the user
then clicks on the Yes button, the
existing file will be destroyed and the new file created in
its place.
The procedure to save a file.
Open the <interface>File Save</interface> dialog.
First, the dialog must be opened using either of the two
following methods:
Two alternative ways to open the <interface>File
Save</interface> dialog.
Using the Menus
Select, in the File
menu, the
Save as...
menu item.
Using a Keyboard Shortcut
Type the combination
ShiftCtrls,
typing all three keys simultaneously.
Both methods will launch the File
Save dialog to allow the user to name the
file, select a folder (also called a directory) for the
file and choose a file format type. This dialog will also
open automatically the first time a new workbook is saved.
Select a name for the file.
Next, a name must be given for the file. &gnum; provides a
default name but, when the dialog is first opened this
name is highlighted indicating that it is already
selected. Therefore, a user can simply start typing a new
name and the first character entered will delete the name
given by default. The file name field is presented as area
A in .
If typing a name does not have any effect, the 'focus'
was probably inadvertently changed from the text entry
area. Focus can be returned to the area by placing the
mouse pointer over the box and clicking the primary
mouse button. All the standard keyboard editing commands
work in this text area and the mouse can be used to
select text or to move the cursor location.
Select a folder in which to save the file.
Then, the folder in which to save the file can be chosen
from the drop down list shown as area B in .
Using this list requires placing the mouse pointer above
the list button and clicking with the primary mouse button
to open the list. The desired folder can then be selected
by moving the pointer down the list and clicking again
with the primary mouse button. The second click will close
the drop down list and change the selected folder. Instead
of the two mouse clicks, the entire operation can be
replaced by a click-hold, drag and release, where the
first mouse click is replaced by the click-and-hold and
the second mouse click is replaced by the release.
This list only provides a limited number of choices
including several standard folders and any bookmark
folders the user has previously added to the file
selector. Other folders can be chosen, new folders can be
created, and the list of bookmark folders available can
be changed, by clicking in area D to change to the expanded dialog,
as will be explained further below, in , and .
Select a file type.
Next, the desired file type must be selected. Area
C in
provides a drop down list of file types. The process for
using this list is the same as was described in the
previous step. The file types are listed below in and explained in
detail in .
If the file format type named "Text export
(configurable)" is opened, this will start the text
export procedure. explains this
procedure in complete detail.
Click the <guibutton>Save</guibutton> button.
Finally, the Save button must be
pressed by placing the mouse pointer over the button and
clicking with the primary mouse button.
This basic procedure does not allow a user to save the file
into folder other than one already provided. An expanded
procedure is needed to explain how to save a file into other
folders in the file system. The next section explains the
extra elements provided when the File
Save dialog is expanded and that section is
followed by a step-by-step procedure explaining how to use
this expanded dialog.
The extra components in the expanded <interface>File Save</interface>
dialog.
In order to select folders other than those provided in the
drop down list shown as area B in ,
the File Save dialog must be expanded
by clicking in the area labeled D. In the expanded form, the
File Save dialog allows a user to
select a new folder in which to save a file, to create new
folders, and to add bookmark folders to the list
provided in the area labeled C.
This section will explain the extra components of the
File Save dialog which are provided
when the dialog is expanded.
shows these different areas and adds a label to each.
The different parts of each panel of the File
Save dialog after it has been expanded have been
shaded with boxes of different colors and labeled with a
letter in . Five of the labeled areas are the same as the areas in the
dialog when it is in a compact form; these areas were
explained above. The remaining areas are explained below:
The extra components in the expanded version of the
<interface>File Save</interface> dialogF - The 'relative root'
selection area.
This area allows the user to select the starting
folder from which to navigate the folder
hierarchy. The navigation system only allows users to
select sub-folders of the currently selected 'relative
root' folder so the root folder selected in area
F must contain the
desired folder as a sub-folder.
The folders listed in this area include the standard
folders provided by the system and a number of folders
added, as bookmark folders, by the user. The standard folders
provided by the system will vary for different
machines and system administrators may have disabled
access to certain areas. By default, the standard
folders provided include the user's 'Home' folder, the
user's 'Desktop' folder, a folder pointing to the root
of the filesystem tree and folders for each of the
removable storage devices attached to the
computer. The user's home folder, on GNU and other
UNIX like systems, this
folder is usually known as ~ or
~user_account_name where the
phrase user_account_name
represents the account name used by the current
user. This folder is often located at
/home/user_account_name/ in the
filesystem. The 'Desktop' folder is the folder which
holds the files which are displayed in the background
of the user's window. The 'Filesystem' folder is the
top of the filesystem tree, which on GNU systems is
also known as /. The list also
presents peripheral or external devices. Below the
standard folders, area F has a separator and the
bookmark folders selected by the user. In the folder currentWork is a
folder named by the user and added to the list of
bookmark folders.
G - The folder hierarchy area.
This area displays the folder hierarchy starting from
the starting folder selected in area F and ending in the current
folder, the folder whose contents are displayed in
area I, while
displaying all the folders between the two. This area
changes dynamically as the user changes to new
folders. In the case shown in ,
the user has selected the 'Home' folder as the
starting folder in area F and has not navigated to any
sub-folders.
H - The Folder Creation button.
This button allows the user to create a folder in the
directory listed in the rightmost part of the file
component area, area G. When this button is clicked,
by placing the mouse pointer over the button and
clicking with the primary mouse button, a new folder
is added to the list in area I with a temporary name of
'Type name of New Folder'
pre-selected and therefore ready to be edited into a
new name.
I - The folder content area.
This area displays the contents of the currently
selected folder which is the rightmost folder shown in
area G.
Not all of the sub-folders and files present in
the folder area are shown.
Firstly, hidden folders and files, those that
start with a leading period, are not displayed by
default. These can be shown by placing the mouse
pointer over area I, clicking with one of the
secondary mouse buttons to raise the context menu,
moving the pointer onto the Show
hidden files menu entry, and
clicking with the primary mouse button. This step
will ensure that all the folders are displayed.
Secondly, the filtering rule defined in
area L
will limit the files displayed based on the
characteristics of these files. By default, a
filtering rule is applied which causes only those
files present that have an extension commonly used
for spreadsheet files. The rule can be changed to
display all the files regardless of their
extension, except possibly for the hidden files.
J - The panel
rearrangement handles.
These triple dots indicate that the mouse can be used
to change the shape and size of the different areas in
the dialog. These handles can be used by placing the
mouse pointer above a handle, clicking and holding
with the primary mouse button, then dragging the
handle to a new position, and then releasing the mouse
button.
K - The bookmark
folder list modification buttons.
These buttons will add or remove folders to or from
the list of bookmark folders in area F. The
Add button will add the folder
currently selected in area G. The
Remove button will remove any
bookmark folder that is selected in area F.
L - The filter
definition area.
This area contains a drop down menu with the different
filters defined by the application. &gnum; currently
defines two filters. The first filters out all files
that do not have an extension used by the spreadsheet
formats supported by gnumeric. The second filter,
labeled "All files", essentially disables any
filtering operation, and lists all the files in the
currently selected folder, except that files starting
with a leading period are not shown.
The uses of the File Save dialog in its
expanded form is explained below.
Changing the currently selected folder.
In order to save a file in a folder other than that provided
by default, it is necessary to change the default folder. The
note below explains briefly the notion of folders and the
procedure further down explains how to change folders.
Understanding the file organization system.
In order to understand how to change folders, it is first
necessary to understand the system by which documents are
stored. This system is called the 'filesystem'.
All documents are stored in a folder. Folders can contain
files but can also contain other folders. Any folder
therefore can contain several sub-folders, each of which may
itself contain several sub-folders; the resulting structure
is called a nested 'tree' with the original folder being the
'relative root' of that tree.
In GNU and UNIX systems, all of the files are stored in
folders organized in a single, unified filesystem tree with
a folder named '/' at the absolute root
of the tree. Every file is accessible from this absolute
root folder and, by default, this folder is provided as the
choice named Filesystem with an icon of
a disk drive in area F in
the File Save dialog.
Navigating the directory tree from the single root folder
would quickly become burdensome and the File
Save dialog provides several other starting
points in area F. These
will be called, in this documentation, the 'relative root'
folders since each of these will act as the root of the
branching structure of sub-folders the relative root folder
contains. Two relative root folders which are commonly
provided are the 'Home' and 'Desktop' folders for the
current user.
In a complex computer system, the absolute root folder may
be hidden from the user and only 'relative roots' will be
present. These should jointly provide some way to access all
the areas where the user can save files.
The 'relative roots' are also necessary when several file
systems are available to the user. This will be the case
when filesystem on other machines are accessible over a
network or when &gnum; is running on operating systems whose
filesystems are not unified, such as the proprietary
operating systems sold by Microsoft in which each disk drive
has its own root named, for example,
C:\ or D:\.
Additional 'relative root' folders can be added as 'bookmark
folders' by the users themselves. These bookmark folders can
be used to access quickly folders which are commonly
used. The bookmark folders are listed, in area F, under the thin horizontal
separator line. The creation and deletion of these bookmark
folders is explained below, in .
Changing folders involves selecting a 'relative root' folder,
then navigating into the appropriate sub-folder. When the
Save button is pressed, the file will be
saved in the folder listed as the right most button in area
G of
which also means that the file will be saved alongside the
folders and files listed in area I.
The procedure to change the currently selected folder.
To select a new folder, one of the 'relative root' folders
which contains the desired folder must first be selected and
then the hierarchy must be navigated to find the desired
folder. As explained below, a user can move around the
hierarchy using as many changes as they need to choose the
folder in which to save their &gnum; file.
Select a 'relative-root' folder in area <emphasis
role="bold">F</emphasis>.
The first step in choosing a new folder requires
selecting, in area F, a
'relative root' folder which contains the desired
folder. The new 'relative root' folder is chosen by placing the
mouse pointer over the folder name and double clicking
(click twice rapidly without moving the mouse) with the
primary mouse button. This will change the leftmost button
in area G and change the
folders and files listed in area I.
Navigate the filesystem to reach the desired
folder using area <emphasis role="bold">I</emphasis>.
The next step involves descending the folder tree to reach
the desired folder. This requires double clicking the
sub-folder of the 'relative root' folder which contains
the desired folder and continuing through the whole
hierarchy until the desired folder is reached. After each
double click, the selected folder is added as the right
most button in area G and
the contents of the selected folder are shown in area
I. Once the desired
folder is reached, it must be opened in the same way, so
that its contents are listed in area I and the file can then be saved
into this folder by clicking on the
Save button.
Navigating back up the folder tree using area <emphasis
role="bold">G</emphasis>.
If the sub-folder selected in area I does not contain the branch of
the folder tree leading to the desired folder, the buttons
in area G can be used to
jump further up the folder tree but only as far as the
'relative root' folder selected in area F. Area G provides a list of buttons with
the names of all the folders between the 'relative root'
listed in area F and the
currently selected folder. By clicking on one of these
buttons, that is by placing the mouse pointer over the
button and clicking with the primary mouse button, the
folder listed on the button will be opened in area
I so that the selection
process can restart from this branch.
The process of exploration of the folder tree can continue as
long as the user wishes. If the user desires it is also
possible to create new folders as is explained next.
Adding a folder.
Often the user wishes to save the &gnum; workbook by creating
a file in a folder which does not yet exist. A new folder can
be added to the folder tree by clicking on the
Create Folder button, which is labeled
as area H of . The button can be clicked by placing the mouse pointer
over the button and pressing the primary mouse button.
When the Create Folder button is
pressed, a folder will be added at the top of the list in area
I, with its name,
Type name of new folder already selected
so that the user can simply start typing to give the folder a
desired name. Once the name has been entered on the keyboard,
typing the Return key (or the
Enter key, depending on the keyboard) will
change the folder name and open that folder. Area I will therefore be empty since the
newly created folder has no contents.
There is no way to delete folders once they have been
created, just as there is no way for &gnum; to delete files
it has created. Folders created by mistake must be deleted
using a file browser such as
Nautilus or using command line
programs such as rm.
Changing the list of bookmark folders.
The list of 'relative root' folders shown in area F of may
contain 'relative root' folders selected by the user. These
folders are called 'bookmark folders' and are listed in area
F below a thin horizontal
separator line. For example, contains
a folder named currentWork which is a
bookmark folder selected by the user.
These bookmark folders can be added in two ways. A folder
which is selected in area I
can be added as a bookmark by clicking on the
Add button in area K.
Alternatively, the folder can be dragged from area I into area K. The folder can be dragged by placing
the mouse pointer over the folder name in area I, clicking and holding the primary
mouse button, moving the mouse pointer to area F and releasing the mouse button. As
the mouse pointer is moved from area I to area F, a small icon of the folder will move
with the mouse pointer.
Any bookmark folder can also be removed from the 'relative
root' folders presented in area F (or in the drop down list labeled
B). A bookmark folder can be
removed by clicking on the folder name in area F and then clicking on the
Remove in area K.
The file formats which Gnumeric can write.
&gnum; can write files in several formats used by other
programs. The details of these formats are provided in and the name of each file type in
the table below skips to the appropriate section of . The creation of files which
consist of structured text is described in . The creation of Postscript
and Portable Document Format (PDF) files is done through the
printing mechanism and is described in .&gnum; can also export text data
or HTML and XHTML tables through the clipboard mechanism, as is
explained in .
Most of these formats are provided by plugins, which are
independent, configurable modules. If a format described below
does not appear in the File Save
dialog, this may be because the appropriate plugin has not
been configured or started. This can be verified by examining
the list of plugins which are currently running in the
Plugin Manager dialog.
The Plugin Manager dialog lists the
plugins which are currently in use and provides a way to start
plugins which are currently disabled. The Plugin
Manager can be started by selecting, in the
Tools menu, the
Plug-ins... menu item; see for more information.
The file formats which &gnum; can create.FormatExtensionGnumeric.gnumeric / .gnmComma Separated Values.csvData Interchange Format.difHTML.html / .htmLaTeX.texMicrosoft Excel
Old Binary.xlsMicrosoft Excel New Binary.xlsMicrosoft Excel
2003 XML.xlsMicrosoft Excel
Office Open XML.xlsxOpenOffice.Org / StarOffice (OASIS ODF/IS26300).ods / .odtOpenOffice.Org / StarOffice
Old Format.sxc / .stcPostscript.ps / .epsPDF.pdfMultiplan (SYLK).sylk / .slkTab Separated Values.tsv / .tabText Formats.txt / .textTROFF.meXHTML.xhtml / .html

./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/data-selections.xml0000644000000000000000000002250711634354176026253 0ustar rootrootSelecting Cells and Cell Ranges
By selecting multiple cells at once, common operations can be
performed on all the cells which have been selected. These
operations include data entry, copying the cells, and multiple
other operations .
Some operations cannot be done on selections of arbitrary
shape. For instance, &gnum; could
not correctly reshape a worksheet following the deletion of a
discontinuous group of cells therefore such an operation is not
allowed. If users attempt an operation which cannot be performed,
a warning dialog will appear.
Simple Selections
The simplest selection involves a single cell. Simply clicking
with the left hand mouse button while the mouse cursor is over a
cell will cause that cell to become selected.
The selected cell is indicated by a dark double line with a small
square in the bottom right corner. The selected cell is the the
one that is currently in focus and will take any input for the
keyboard.
To make a cell become the selected cell, simply move the
white-cross cursor over the cell and press the left mouse
button.
Selecting Multiple Cells
Several cells can be selected at once. When multiple cells are
selected, the selected cells are indicated with a light, "baby"
blue colour. When a single block of cells is selected, a double
black line will surround the selection, and all cells except the
first one to be selected will be shown in light blue.
Continuous selections
To make a continuous selection of cells, move the white cross
mouse cursor pointer to the cell at one corner of the block of
continuous cells, click and hold the primary mouse pointer on
that cell, drag the pointer to the opposite corner of the block
of cells and then release the mouse button. The block of cells
will now be selected.
The arrow keys can also be used to select a continuous block of
cells. To add cells in this manner, first select the cell in one
corner of the cell block with the primary mouse button, then
hold the Shift key and use the arrow keys to expand
the selection block.
Discontinuous selections
A discontinuous group of cells can also be selected, by selecting
cells or block of cells while holding down the
Ctrl key. To select a discontinuous group of
cells, first select a cell or a continuous group of cells as
explained above, then click and hold down the
Ctrl while selecting more cells. All of the
cells which are selected while the Ctrl key is
held down will be added to the selection. All selected cells
will be displayed with a light blue colour. Cells can be added
individually or as continuous blocks. This selection process is
additive with each selected cell added only once so selecting
cells twice or more simply adds those cells once to the selection.
Advanced methods of Selection
There are several ways to make selections using the keyboard
keys directly. These may be quicker than using the mouse
pointer. As explained above, the simplest of these uses the
Shift and arrow keys to make a
new selection.
To select an entire row of cells, press the combination of
Shiftspace
keys. This is equivalent to pressing the row label button on the
left side of the sheet.
To select an entire column of cells, press the combination of
CtrlSpace
keys. This is equivalent to pressing the column label button on
the top of the sheet.
To select the entire sheet, press the combination of
CtrlA keys. This
is equivalent to pressing the button in the top left corner of
the sheet.
The following list summaries keyboard shortcuts which can be
used to select large cell blocks.
ShiftArrow
: Define selection with cursor keys.
CtrlArrow
: Jump to the end of the current region.
AltSpace
: Select current row.
CtrlSpace
: Select current column.
CtrlA
: Select the entire sheet.
Ctrl/
: Select the array formula around the current edit position.
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/data-delete.xml0000644000000000000000000000054711634354176025345 0ustar rootrootDeleting Data
This section has not yet been written...
Para...
Para...
./gnumeric_DOC-1.10.17-i486-spup/usr/share/gnome/help/gnumeric/C/data-types.xml0000644000000000000000000006715311634354176025255 0ustar rootrootThe Types of Cell Elements
Each cell in a &gnum; worksheet can
contain only a single data element. These elements will have one
of five basic types: text, numbers, booleans, formulas, or
errors. During data entry, &gnum;
assigns a default data type to the cell based on an analysis of
the cell contents. This assignment can be changed later if
&gnum; makes the wrong
assignment. For information on how to change the data type of a
cell, see .
The five basic types of data which can be stored in a spreadsheet
cell are:
Text
A text element can contain a series of letters, numbers
or other contents. For example, the first cell in a
worksheet might contain the characters —This
worksheet describes the company's income — which
&gnum; would interpret to
be text. In order to distinguish text elements from
number or formula elements, the text element may start
with a single quote. For instance, if a cell contained
only the three digits 345,
&gnum; would consider that
to be the number three hundred and forty five. If this
cell is intended to be a string,
&gnum; will store the cell
as '345. The newline character cannot be entered
directly but must be entered as AltEnter. For more information
on entering and formatting text elements, see .
Numbers
A number element can contain a series of digits (425)
but may include specific text and formatting characters
to indicate negative numbers (-345), decimal separator
(34.0567), thousand separators (12,342), currency ($23),
dates (21-10-1998), times (10:23) or scientific notation
(2.3e12). Dates may include the names of months or their
abbreviation. The currency, decimal separator and
thousands separator symbols vary depending on the locale
(the language and other location specific behaviour) to
which &gnum; has been
set. See to understand how to change the locale. If you want a
number to be displayed as a plain string without any
number formatting, you can put a single quote (') before
it. For more information on entering and formatting,
numeric elements see .
Boolean
A boolean element can contain one of two values: TRUE
and FALSE. These are useful as inputs or outputs from
formulas and for boolean algebra. More information on
boolean data elements is presented in .
Formulas
A formula is an instruction to
&gnum; which describes a
calculation which should be performed
automatically. These formulas can contain standard
arithmetic elements but can also contain references to
other cells. Calculations which depend on other cells are
usually recalculated when the values of another cell
changes. Formulas always begin with a special character
— the equals sign (=). The commercial at symbol (@)
can be used instead of the equals sign during data entry
but &gnum; will convert this
to an equals sign. Alternatively, an entry which
describes a calculation and which starts with either the
plus (+) or minus symbol (-) will be converted to a
formula starting with an equals sign. For a more complete
explanation of formulas, see .
A cell reference is the part of a formula which refers to
another cell. For example, in the formula to add two cells
=(A4+A1), both A4 and A1 are cell references. These
references can be quite complex referring to cells in
different worksheets or even in different files. See for a complete
explanation of references.
Error
An error element describes the failure to calculate the
result of a formula. These values are rarely entered
directly by a user but usually are the display given
when a formula cannot be correctly calculated. See
for a complete list
of error values and their explanation.
A cell may display a series of hash marks (######). This
indicates that the result is too wide to display in the cell
given the current font setting and the current column
width. When this occurs, the value in the cell can be seen in
two ways. If the cell is selected, the value will appear in the
data entry area (to the right of the equals button directly
above the cell grid). Alternatively, the column containing the
cell can be widened until the data contents become visible:
select the whole column (by clicking on the column header)
and choose
FormatColumnAuto fit selection.
Text Data Elements
Text elements consist of an arbitrary sequence of characters or
numbers entered into a cell. Because
&gnum; automatically recognizes
certain sequences as numbers or formulas, certain sequences of
characters (such as sequences containing only digits or a text
element which starts with an equals sign) must be treated
specially to have them considered text. In order to force any
sequence to be considered text, the sequence can be started with
an apostrophe symbol ('). Alternatively, the
'number' format of the cell can be specified to be 'text' before
entering the characters, as explained in . Text elements are the
simplest elements to enter into spreadsheet cells.
An example of a spreadsheet cell grid with cells containing
text is given in .
Valid text entries include simple words, whole sentences and even
paragraphs.
To include a newline in a cell, a special key combination is
required. A newline symbol can be inserted with the key
combination of
AltEnter.
Number Data Elements
Number data elements include a variety of data all of which are
stored and manipulated by &gnum; as
numbers. This includes integers, decimal fractions, general
fractions, numbers in scientific notation, dates, times, and
currency values.
Data are recognized as numbers when they are entered, dependent on
the format of the sequence of characters
entered. &gnum; attempts to
intelligently guess the subtype of the data and match the data to
an existing format for numbered data. If it matches a data format,
&gnum; will automatically assign the
datum to a data type and associate an appropriate display format
with the cell. The format recognition of
&gnum; includes a wide variety of
data formats which are discussed in detail in .
Because &gnum; automatically guesses
the data type of a number being entered into a cell, this process
may have to be over-ridden for certain types of data. For
example, postal codes in the United States consist of a sequence
of numbers which &gnum; interprets as
an integer. However, U.S. postal codes can start with a leading
zero which &gnum; discards by
default. In order to override the default format, the number
format of the cell must be specified before the entry of the
data. This is explained in , below.
Boolean Data Elements
Cells can contain boolean data elements. These elements arise from
Boolean logic which is a branch of mathematics. These elements are
useful for manipulation of formulas.
Boolean values can be either "TRUE" or "FALSE". If these strings
are entered into a cell, &gnum; will
recognize these as boolean values. These values can then be used
in formulas. Certain formulas will also return boolean values.
Formula Elements
Formulas are the key to making a powerful spreadsheet. A formula
instructs &gnum; to perform
calculations and display the results. These calculations are
defined as a formula data elements. The power of these formulas
arises because these formulas can include the contents of other
cells and the results of the formulas are updated automatically
when the contents of any cell included in the formula change. The
contents of other cells are included using "cell references" which
are explained below.
Any formula entered into a cell must follow a specific syntax so
that &gnum; can interpret the formula
correctly. This syntax closely follows mathematical notation but
also includes spreadsheet formulas, object names and cell
references.
Syntax
Formulas are distinguished from regular data by starting with an
equals sign (=) as the first character. Everything following
this equals sign is evaluated as a formula.
Alternate Beginnings for Formulas
To accommodate those more familiar with Lotus spreadsheets,
Gnumeric recognizes the commercial at symbol (@) as the
beginning of a formula and substitutes an equals sign. The
plus and minus characters (+ and -) may also start formulas
that involve calculation, but when used in front of a single
number only indicate the sign of the number.
The simplest formulas just use the standard math operator and
symbols. Addition, subtraction, multiplication, and division
are represented by +, -, *, and /, just as you would expect.
+,- can be placed in front of numbers to indicate sign, as well.
Examples of standard operators
=5+5 returns 10.
=5-4 returns 1.
=-5 returns -5.
=5*5 returns 25.
=(5*5)+11 returns 36.
=(5*5)+(49/7) returns 32.
Formulas can result in error values in several instances. If a
formula is entered incorrectly,
&gnum; will display a warning and
allow either the formula to be corrected or will save the
formula as text for editing later. If a syntactically correct
formula results in a nonsensical calculation (for instance, a
division by zero), then an error value will be displayed
indicating the error.
Using Functions
Formulas can also contain functions which denote the use of
standard mathematical, business, statistical, and scientific
calculations. These functions take the place of any data element
in a formula and can therefore be combined with the standard
arithmetic operators described above.
These functions have the form:
Basic Function syntax
FUNCTIONNAME(ARGUMENTS)
where FUNCTIONNAME indicates the name of a function and
ARGUMENTS indicates one or more arguments to the function. The
function arguments are separated by commas (,).
While the documentation generally refers to functions and to
cells in capital letters, their use is not actually case
sensitive.
Some examples of the use of functions are:
Some examples of function syntax
=SUM(A1,A2,A4,B5)
=AVERAGE(A1:A16)
=EXP(1)
=PI()
=3+4*MIN(A1,A2,B6)
The arguments of the functions vary in number from none, as in
the PI() function, to an unlimited number, as in the SUM()
function, depending on the type of function.
Cell Referencing
Formulas can include the displayed data from other cells. These
contents are described as `cell references' which are names
indicating that the contents of other cells should be used in
the calculation.
Each cell in a spreadsheet is named by its column and row
labels. The column labels are letters and the row labels are
numbers. The first cell, therefore, is called A1. One column
over and two rows down from cell A1 is the cell B3. The right
most and bottom most cell is cell IV65536 which is the cell in
column IV and in row 65536.
The value of a cell can be used in a formula simply by entering
its name where a number value would otherwise occur. For
example, to have the data in cell B1 appear in another cell,
enter =B1 into that cell. Other more complex examples include:
Some examples of simple cell reference syntax
=A1+EXP(B1)-(C3/C4)
=COS(A2)*SIN(A2)
Absolute cell referencing
Cells can be referenced in the default way (relative
referencing), or by using absolute referencing. Absolute
referencing means that when the cell is copied, the cell
reference does not change. Normally, auto-filling a cell range
or moving cell will change its cell reference to so that it
maintains a relation to the original cell. Absolute
referencing prevents these changes.
When Does Relative Referencing Make a Difference?
The difference between absolute and relative cell references
only matters if you are copying or moving cells that contain
cell references. For cells that are going to remain in
place, both the relative and absolute references have the
same result.
Relative References
For example, if =A1 is the formula entered into cell B2,
cell B2 will display the data in cell A1, which is one row
up and one column left. Then, if you copy the contents of
B2 to cell F6, cell F6 will contain the value from E5,
which is also one row up and one column left.
For the copied cell to still refer to A1, specify absolute
references using the $ character: $A$1 refers to cell A1,
no matter where it is copied.
The format for absolute cell referencing is to use a '$' in
front of the cell coordinate that the you want to stay
constant. The column, row, sheet, or any combination of these
can be held constant.
Absolute cell referencing examples
What happens when a given formula is entered into cell B2,
then copied to other cells?
=A1
=A1 is a normal, or relative, cell reference
function. When =A1 is entered into cell B2, it refers
to the value of data one cell up and one cell left
from the cell with the reference. Therefore, if this
formula were copied from cell B2 to cell C2, the value
displayed in cell C2 will be the value of data in cell
B1. Copied to cell R19, the formula will display the
data in cell Q18.
=$A1
In this case, the column value is absolute, but the
row value is relative. Therefore, if =$A1 is entered
into cell B2, the formula refers to the data in column
A that is one row up from the current location.
Copied to cell C2, the formula will refer to the data
in cell A1. Copied to cell R19, it will refer to the
data in A18.
=A$1
This formula uses a relative column value and an
absolute row value. In cell B2, it refers to cell A1
as the data in the cell one column left and in row
1. Copied to cell C3, the formula will display the
data in cell B1.
=$A$1
No matter where this formula is copied, it will always
refer to the data in cell A1.
Referencing multiple cells
Many functions can take multiple cells as arguments. This can
either be a comma separated list, an array, or any combination
thereof.
Multiple individual cells
A comma separated list of cell references can be used to
indicate cells that are discontinuous.
Some examples of function syntax
=SUM(A1,B2,C4)
=MIN