functions.sgml 403 KB
Newer Older
1
<sect1 id="reference">
2 3 4 5 6 7
  <title>Reference</title>


 
<itemizedlist mark="bullet">
<listitem><para><link linkend="gnumeric-ABS">ABS</link></para></listitem>
8 9
<listitem><para><link linkend="gnumeric-ACCRINT">ACCRINT</link></para></listitem>
<listitem><para><link linkend="gnumeric-ACCRINTM">ACCRINTM</link></para></listitem>
10 11
<listitem><para><link linkend="gnumeric-ACOS">ACOS</link></para></listitem>
<listitem><para><link linkend="gnumeric-ACOSH">ACOSH</link></para></listitem>
12
<listitem><para><link linkend="gnumeric-ADDRESS">ADDRESS</link></para></listitem>
Jody Goldberg's avatar
update  
Jody Goldberg committed
13 14
<listitem><para><link linkend="gnumeric-AMORDEGRC">AMORDEGRC</link></para></listitem>
<listitem><para><link linkend="gnumeric-AMORLINC">AMORLINC</link></para></listitem>
15 16 17 18 19 20
<listitem><para><link linkend="gnumeric-AND">AND</link></para></listitem>
<listitem><para><link linkend="gnumeric-ASIN">ASIN</link></para></listitem>
<listitem><para><link linkend="gnumeric-ASINH">ASINH</link></para></listitem>
<listitem><para><link linkend="gnumeric-ATAN">ATAN</link></para></listitem>
<listitem><para><link linkend="gnumeric-ATAN2">ATAN2</link></para></listitem>
<listitem><para><link linkend="gnumeric-ATANH">ATANH</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
21
<listitem><para><link linkend="gnumeric-AVEDEV">AVEDEV</link></para></listitem>
22
<listitem><para><link linkend="gnumeric-AVERAGE">AVERAGE</link></para></listitem>
23
<listitem><para><link linkend="gnumeric-AVERAGEA">AVERAGEA</link></para></listitem>
24
<listitem><para><link linkend="gnumeric-BESSELI">BESSELI</link></para></listitem>
25
<listitem><para><link linkend="gnumeric-BESSELJ">BESSELJ</link></para></listitem>
26
<listitem><para><link linkend="gnumeric-BESSELK">BESSELK</link></para></listitem>
27
<listitem><para><link linkend="gnumeric-BESSELY">BESSELY</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
28
<listitem><para><link linkend="gnumeric-BETADIST">BETADIST</link></para></listitem>
29
<listitem><para><link linkend="gnumeric-BETAINV">BETAINV</link></para></listitem>
30
<listitem><para><link linkend="gnumeric-BIN2DEC">BIN2DEC</link></para></listitem>
31 32
<listitem><para><link linkend="gnumeric-BIN2HEX">BIN2HEX</link></para></listitem>
<listitem><para><link linkend="gnumeric-BIN2OCT">BIN2OCT</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
33
<listitem><para><link linkend="gnumeric-BINOMDIST">BINOMDIST</link></para></listitem>
34
<listitem><para><link linkend="gnumeric-CEIL">CEIL</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
35
<listitem><para><link linkend="gnumeric-CEILING">CEILING</link></para></listitem>
36
<listitem><para><link linkend="gnumeric-CELL">CELL</link></para></listitem>
37
<listitem><para><link linkend="gnumeric-CHAR">CHAR</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
38 39
<listitem><para><link linkend="gnumeric-CHIDIST">CHIDIST</link></para></listitem>
<listitem><para><link linkend="gnumeric-CHIINV">CHIINV</link></para></listitem>
40
<listitem><para><link linkend="gnumeric-CHITEST">CHITEST</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
41
<listitem><para><link linkend="gnumeric-CHOOSE">CHOOSE</link></para></listitem>
42 43
<listitem><para><link linkend="gnumeric-CLEAN">CLEAN</link></para></listitem>
<listitem><para><link linkend="gnumeric-CODE">CODE</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
44
<listitem><para><link linkend="gnumeric-COLUMN">COLUMN</link></para></listitem>
45
<listitem><para><link linkend="gnumeric-COLUMNS">COLUMNS</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
46
<listitem><para><link linkend="gnumeric-COMBIN">COMBIN</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
47
<listitem><para><link linkend="gnumeric-COMPLEX">COMPLEX</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
48 49
<listitem><para><link linkend="gnumeric-CONCATENATE">CONCATENATE</link></para></listitem>
<listitem><para><link linkend="gnumeric-CONFIDENCE">CONFIDENCE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
50
<listitem><para><link linkend="gnumeric-CONVERT">CONVERT</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
51
<listitem><para><link linkend="gnumeric-CORREL">CORREL</link></para></listitem>
52 53 54
<listitem><para><link linkend="gnumeric-COS">COS</link></para></listitem>
<listitem><para><link linkend="gnumeric-COSH">COSH</link></para></listitem>
<listitem><para><link linkend="gnumeric-COUNT">COUNT</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
55 56 57
<listitem><para><link linkend="gnumeric-COUNTA">COUNTA</link></para></listitem>
<listitem><para><link linkend="gnumeric-COUNTBLANK">COUNTBLANK</link></para></listitem>
<listitem><para><link linkend="gnumeric-COUNTIF">COUNTIF</link></para></listitem>
Jody Goldberg's avatar
update  
Jody Goldberg committed
58 59 60 61 62 63
<listitem><para><link linkend="gnumeric-COUPDAYBS">COUPDAYBS</link></para></listitem>
<listitem><para><link linkend="gnumeric-COUPDAYS">COUPDAYS</link></para></listitem>
<listitem><para><link linkend="gnumeric-COUPDAYSNC">COUPDAYSNC</link></para></listitem>
<listitem><para><link linkend="gnumeric-COUPNCD">COUPNCD</link></para></listitem>
<listitem><para><link linkend="gnumeric-COUPNUM">COUPNUM</link></para></listitem>
<listitem><para><link linkend="gnumeric-COUPPCD">COUPPCD</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
64 65
<listitem><para><link linkend="gnumeric-COVAR">COVAR</link></para></listitem>
<listitem><para><link linkend="gnumeric-CRITBINOM">CRITBINOM</link></para></listitem>
Jody Goldberg's avatar
update  
Jody Goldberg committed
66 67
<listitem><para><link linkend="gnumeric-CUMIPMT">CUMIPMT</link></para></listitem>
<listitem><para><link linkend="gnumeric-CUMPRINC">CUMPRINC</link></para></listitem>
68
<listitem><para><link linkend="gnumeric-DATE">DATE</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
69
<listitem><para><link linkend="gnumeric-DATEDIF">DATEDIF</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
70 71
<listitem><para><link linkend="gnumeric-DATEVALUE">DATEVALUE</link></para></listitem>
<listitem><para><link linkend="gnumeric-DAVERAGE">DAVERAGE</link></para></listitem>
72
<listitem><para><link linkend="gnumeric-DAY">DAY</link></para></listitem>
73 74
<listitem><para><link linkend="gnumeric-DAYS360 ">DAYS360 </link></para></listitem>
<listitem><para><link linkend="gnumeric-DB">DB</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
75 76
<listitem><para><link linkend="gnumeric-DCOUNT">DCOUNT</link></para></listitem>
<listitem><para><link linkend="gnumeric-DCOUNTA">DCOUNTA</link></para></listitem>
77
<listitem><para><link linkend="gnumeric-DDB">DDB</link></para></listitem>
78 79 80
<listitem><para><link linkend="gnumeric-DEC2BIN">DEC2BIN</link></para></listitem>
<listitem><para><link linkend="gnumeric-DEC2HEX">DEC2HEX</link></para></listitem>
<listitem><para><link linkend="gnumeric-DEC2OCT">DEC2OCT</link></para></listitem>
81
<listitem><para><link linkend="gnumeric-DEGREES">DEGREES</link></para></listitem>
82
<listitem><para><link linkend="gnumeric-DELTA">DELTA</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
83
<listitem><para><link linkend="gnumeric-DEVSQ">DEVSQ</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
84
<listitem><para><link linkend="gnumeric-DGET">DGET</link></para></listitem>
85
<listitem><para><link linkend="gnumeric-DISC">DISC</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
86 87
<listitem><para><link linkend="gnumeric-DMAX">DMAX</link></para></listitem>
<listitem><para><link linkend="gnumeric-DMIN">DMIN</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
88 89 90
<listitem><para><link linkend="gnumeric-DOLLAR">DOLLAR</link></para></listitem>
<listitem><para><link linkend="gnumeric-DOLLARDE">DOLLARDE</link></para></listitem>
<listitem><para><link linkend="gnumeric-DOLLARFR">DOLLARFR</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
91 92 93 94
<listitem><para><link linkend="gnumeric-DPRODUCT">DPRODUCT</link></para></listitem>
<listitem><para><link linkend="gnumeric-DSTDEV">DSTDEV</link></para></listitem>
<listitem><para><link linkend="gnumeric-DSTDEVP">DSTDEVP</link></para></listitem>
<listitem><para><link linkend="gnumeric-DSUM">DSUM</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
95
<listitem><para><link linkend="gnumeric-DURATION">DURATION</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
96 97 98
<listitem><para><link linkend="gnumeric-DVAR">DVAR</link></para></listitem>
<listitem><para><link linkend="gnumeric-DVARP">DVARP</link></para></listitem>
<listitem><para><link linkend="gnumeric-EDATE">EDATE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
99
<listitem><para><link linkend="gnumeric-EFFECT">EFFECT</link></para></listitem>
100
<listitem><para><link linkend="gnumeric-EOMONTH">EOMONTH</link></para></listitem>
101 102
<listitem><para><link linkend="gnumeric-ERF">ERF</link></para></listitem>
<listitem><para><link linkend="gnumeric-ERFC">ERFC</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
103
<listitem><para><link linkend="gnumeric-ERROR">ERROR</link></para></listitem>
104
<listitem><para><link linkend="gnumeric-ERROR.TYPE">ERROR.TYPE</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
105
<listitem><para><link linkend="gnumeric-EURO">EURO</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
106
<listitem><para><link linkend="gnumeric-EVEN">EVEN</link></para></listitem>
107 108
<listitem><para><link linkend="gnumeric-EXACT">EXACT</link></para></listitem>
<listitem><para><link linkend="gnumeric-EXP">EXP</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
109
<listitem><para><link linkend="gnumeric-EXPONDIST">EXPONDIST</link></para></listitem>
Miguel de Icaza's avatar
Miguel de Icaza committed
110
<listitem><para><link linkend="gnumeric-EXPRESSION">EXPRESSION</link></para></listitem>
111
<listitem><para><link linkend="gnumeric-FACT">FACT</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
112
<listitem><para><link linkend="gnumeric-FACTDOUBLE">FACTDOUBLE</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
113
<listitem><para><link linkend="gnumeric-FALSE">FALSE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
114
<listitem><para><link linkend="gnumeric-FDIST">FDIST</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
115
<listitem><para><link linkend="gnumeric-FIND">FIND</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
116
<listitem><para><link linkend="gnumeric-FINV">FINV</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
117 118 119
<listitem><para><link linkend="gnumeric-FISHER">FISHER</link></para></listitem>
<listitem><para><link linkend="gnumeric-FISHERINV">FISHERINV</link></para></listitem>
<listitem><para><link linkend="gnumeric-FIXED">FIXED</link></para></listitem>
120
<listitem><para><link linkend="gnumeric-FLOOR">FLOOR</link></para></listitem>
121
<listitem><para><link linkend="gnumeric-FORECAST">FORECAST</link></para></listitem>
122
<listitem><para><link linkend="gnumeric-FREQUENCY">FREQUENCY</link></para></listitem>
123
<listitem><para><link linkend="gnumeric-FTEST">FTEST</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
124
<listitem><para><link linkend="gnumeric-FV">FV</link></para></listitem>
125
<listitem><para><link linkend="gnumeric-FVSCHEDULE">FVSCHEDULE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
126 127
<listitem><para><link linkend="gnumeric-GAMMADIST">GAMMADIST</link></para></listitem>
<listitem><para><link linkend="gnumeric-GAMMAINV">GAMMAINV</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
128 129 130
<listitem><para><link linkend="gnumeric-GAMMALN">GAMMALN</link></para></listitem>
<listitem><para><link linkend="gnumeric-GCD">GCD</link></para></listitem>
<listitem><para><link linkend="gnumeric-GEOMEAN">GEOMEAN</link></para></listitem>
131
<listitem><para><link linkend="gnumeric-GESTEP">GESTEP</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
132
<listitem><para><link linkend="gnumeric-GETPIVOTDATA">GETPIVOTDATA</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
133
<listitem><para><link linkend="gnumeric-GNUMERIC_VERSION">GNUMERIC_VERSION</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
134
<listitem><para><link linkend="gnumeric-GROWTH">GROWTH</link></para></listitem>
135
<listitem><para><link linkend="gnumeric-G_PRODUCT">G_PRODUCT</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
136
<listitem><para><link linkend="gnumeric-HARMEAN">HARMEAN</link></para></listitem>
137 138 139
<listitem><para><link linkend="gnumeric-HEX2BIN">HEX2BIN</link></para></listitem>
<listitem><para><link linkend="gnumeric-HEX2DEC">HEX2DEC</link></para></listitem>
<listitem><para><link linkend="gnumeric-HEX2OCT">HEX2OCT</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
140
<listitem><para><link linkend="gnumeric-HLOOKUP">HLOOKUP</link></para></listitem>
141
<listitem><para><link linkend="gnumeric-HOUR">HOUR</link></para></listitem>
142
<listitem><para><link linkend="gnumeric-HYPERLINK">HYPERLINK</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
143
<listitem><para><link linkend="gnumeric-HYPGEOMDIST">HYPGEOMDIST</link></para></listitem>
144
<listitem><para><link linkend="gnumeric-IF">IF</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
145 146 147 148 149 150 151 152 153 154 155 156
<listitem><para><link linkend="gnumeric-IMABS">IMABS</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMAGINARY">IMAGINARY</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMARGUMENT">IMARGUMENT</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMCONJUGATE">IMCONJUGATE</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMCOS">IMCOS</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMDIV">IMDIV</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMEXP">IMEXP</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMLN">IMLN</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMLOG10">IMLOG10</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMLOG2">IMLOG2</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMPOWER">IMPOWER</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMPRODUCT">IMPRODUCT</link></para></listitem>
157
<listitem><para><link linkend="gnumeric-IMREAL">IMREAL</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
158 159 160 161
<listitem><para><link linkend="gnumeric-IMSIN">IMSIN</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMSQRT">IMSQRT</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMSUB">IMSUB</link></para></listitem>
<listitem><para><link linkend="gnumeric-IMSUM">IMSUM</link></para></listitem>
162
<listitem><para><link linkend="gnumeric-IMTAN">IMTAN</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
163
<listitem><para><link linkend="gnumeric-INDEX">INDEX</link></para></listitem>
164
<listitem><para><link linkend="gnumeric-INDIRECT">INDIRECT</link></para></listitem>
165
<listitem><para><link linkend="gnumeric-INFO">INFO</link></para></listitem>
166
<listitem><para><link linkend="gnumeric-INT">INT</link></para></listitem>
167
<listitem><para><link linkend="gnumeric-INTERCEPT">INTERCEPT</link></para></listitem>
168
<listitem><para><link linkend="gnumeric-INTRATE">INTRATE</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
169
<listitem><para><link linkend="gnumeric-IPMT">IPMT</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
170
<listitem><para><link linkend="gnumeric-IRR">IRR</link></para></listitem>
171 172
<listitem><para><link linkend="gnumeric-ISBLANK">ISBLANK</link></para></listitem>
<listitem><para><link linkend="gnumeric-ISERR">ISERR</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
173
<listitem><para><link linkend="gnumeric-ISERROR">ISERROR</link></para></listitem>
174 175 176 177 178 179
<listitem><para><link linkend="gnumeric-ISEVEN">ISEVEN</link></para></listitem>
<listitem><para><link linkend="gnumeric-ISLOGICAL">ISLOGICAL</link></para></listitem>
<listitem><para><link linkend="gnumeric-ISNA">ISNA</link></para></listitem>
<listitem><para><link linkend="gnumeric-ISNONTEXT">ISNONTEXT</link></para></listitem>
<listitem><para><link linkend="gnumeric-ISNUMBER">ISNUMBER</link></para></listitem>
<listitem><para><link linkend="gnumeric-ISODD">ISODD</link></para></listitem>
180
<listitem><para><link linkend="gnumeric-ISPMT">ISPMT</link></para></listitem>
181 182
<listitem><para><link linkend="gnumeric-ISREF">ISREF</link></para></listitem>
<listitem><para><link linkend="gnumeric-ISTEXT">ISTEXT</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
183
<listitem><para><link linkend="gnumeric-KURT">KURT</link></para></listitem>
184
<listitem><para><link linkend="gnumeric-KURTP">KURTP</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
185
<listitem><para><link linkend="gnumeric-LARGE">LARGE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
186
<listitem><para><link linkend="gnumeric-LCM">LCM</link></para></listitem>
187 188
<listitem><para><link linkend="gnumeric-LEFT">LEFT</link></para></listitem>
<listitem><para><link linkend="gnumeric-LEN">LEN</link></para></listitem>
189
<listitem><para><link linkend="gnumeric-LINEST">LINEST</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
190
<listitem><para><link linkend="gnumeric-LN">LN</link></para></listitem>
191 192 193
<listitem><para><link linkend="gnumeric-LOG">LOG</link></para></listitem>
<listitem><para><link linkend="gnumeric-LOG10">LOG10</link></para></listitem>
<listitem><para><link linkend="gnumeric-LOG2">LOG2</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
194
<listitem><para><link linkend="gnumeric-LOGEST">LOGEST</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
195
<listitem><para><link linkend="gnumeric-LOGINV">LOGINV</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
196
<listitem><para><link linkend="gnumeric-LOGNORMDIST">LOGNORMDIST</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
197
<listitem><para><link linkend="gnumeric-LOOKUP">LOOKUP</link></para></listitem>
198
<listitem><para><link linkend="gnumeric-LOWER">LOWER</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
199
<listitem><para><link linkend="gnumeric-MATCH">MATCH</link></para></listitem>
200
<listitem><para><link linkend="gnumeric-MAX">MAX</link></para></listitem>
201
<listitem><para><link linkend="gnumeric-MAXA">MAXA</link></para></listitem>
202
<listitem><para><link linkend="gnumeric-MDETERM">MDETERM</link></para></listitem>
Jody Goldberg's avatar
update  
Jody Goldberg committed
203
<listitem><para><link linkend="gnumeric-MDURATION">MDURATION</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
204
<listitem><para><link linkend="gnumeric-MEDIAN">MEDIAN</link></para></listitem>
205 206
<listitem><para><link linkend="gnumeric-MID">MID</link></para></listitem>
<listitem><para><link linkend="gnumeric-MIN">MIN</link></para></listitem>
207
<listitem><para><link linkend="gnumeric-MINA">MINA</link></para></listitem>
208
<listitem><para><link linkend="gnumeric-MINUTE">MINUTE</link></para></listitem>
209
<listitem><para><link linkend="gnumeric-MINVERSE">MINVERSE</link></para></listitem>
210
<listitem><para><link linkend="gnumeric-MIRR">MIRR</link></para></listitem>
211
<listitem><para><link linkend="gnumeric-MMULT">MMULT</link></para></listitem>
212
<listitem><para><link linkend="gnumeric-MOD">MOD</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
213
<listitem><para><link linkend="gnumeric-MODE">MODE</link></para></listitem>
214
<listitem><para><link linkend="gnumeric-MONTH">MONTH</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
215 216
<listitem><para><link linkend="gnumeric-MROUND">MROUND</link></para></listitem>
<listitem><para><link linkend="gnumeric-MULTINOMIAL">MULTINOMIAL</link></para></listitem>
217 218
<listitem><para><link linkend="gnumeric-N">N</link></para></listitem>
<listitem><para><link linkend="gnumeric-NA">NA</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
219
<listitem><para><link linkend="gnumeric-NEGBINOMDIST">NEGBINOMDIST</link></para></listitem>
220
<listitem><para><link linkend="gnumeric-NETWORKDAYS">NETWORKDAYS</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
221 222
<listitem><para><link linkend="gnumeric-NOMINAL">NOMINAL</link></para></listitem>
<listitem><para><link linkend="gnumeric-NORMDIST">NORMDIST</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
223
<listitem><para><link linkend="gnumeric-NORMINV">NORMINV</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
224
<listitem><para><link linkend="gnumeric-NORMSDIST">NORMSDIST</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
225
<listitem><para><link linkend="gnumeric-NORMSINV">NORMSINV</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
226
<listitem><para><link linkend="gnumeric-NOT">NOT</link></para></listitem>
227
<listitem><para><link linkend="gnumeric-NOW">NOW</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
228 229
<listitem><para><link linkend="gnumeric-NPER">NPER</link></para></listitem>
<listitem><para><link linkend="gnumeric-NPV">NPV</link></para></listitem>
230 231 232
<listitem><para><link linkend="gnumeric-OCT2BIN">OCT2BIN</link></para></listitem>
<listitem><para><link linkend="gnumeric-OCT2DEC">OCT2DEC</link></para></listitem>
<listitem><para><link linkend="gnumeric-OCT2HEX">OCT2HEX</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
233
<listitem><para><link linkend="gnumeric-ODD">ODD</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
234 235 236 237
<listitem><para><link linkend="gnumeric-ODDFPRICE">ODDFPRICE</link></para></listitem>
<listitem><para><link linkend="gnumeric-ODDFYIELD">ODDFYIELD</link></para></listitem>
<listitem><para><link linkend="gnumeric-ODDLPRICE">ODDLPRICE</link></para></listitem>
<listitem><para><link linkend="gnumeric-ODDLYIELD">ODDLYIELD</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
238
<listitem><para><link linkend="gnumeric-OFFSET">OFFSET</link></para></listitem>
239
<listitem><para><link linkend="gnumeric-OR">OR</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
240
<listitem><para><link linkend="gnumeric-PEARSON">PEARSON</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
241
<listitem><para><link linkend="gnumeric-PERCENTILE">PERCENTILE</link></para></listitem>
242
<listitem><para><link linkend="gnumeric-PERCENTRANK">PERCENTRANK</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
243
<listitem><para><link linkend="gnumeric-PERMUT">PERMUT</link></para></listitem>
244
<listitem><para><link linkend="gnumeric-PI">PI</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
245
<listitem><para><link linkend="gnumeric-PMT">PMT</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
246 247
<listitem><para><link linkend="gnumeric-POISSON">POISSON</link></para></listitem>
<listitem><para><link linkend="gnumeric-POWER">POWER</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
248
<listitem><para><link linkend="gnumeric-PPMT">PPMT</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
249
<listitem><para><link linkend="gnumeric-PRICE">PRICE</link></para></listitem>
250 251
<listitem><para><link linkend="gnumeric-PRICEDISC">PRICEDISC</link></para></listitem>
<listitem><para><link linkend="gnumeric-PRICEMAT">PRICEMAT</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
252 253
<listitem><para><link linkend="gnumeric-PROB">PROB</link></para></listitem>
<listitem><para><link linkend="gnumeric-PRODUCT">PRODUCT</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
254 255
<listitem><para><link linkend="gnumeric-PROPER">PROPER</link></para></listitem>
<listitem><para><link linkend="gnumeric-PV">PV</link></para></listitem>
256
<listitem><para><link linkend="gnumeric-QUARTILE">QUARTILE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
257
<listitem><para><link linkend="gnumeric-QUOTIENT">QUOTIENT</link></para></listitem>
258
<listitem><para><link linkend="gnumeric-RADIANS">RADIANS</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
259
<listitem><para><link linkend="gnumeric-RAND">RAND</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
260
<listitem><para><link linkend="gnumeric-RANDBETWEEN">RANDBETWEEN</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
261
<listitem><para><link linkend="gnumeric-RANDNEGBINOM">RANDNEGBINOM</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
262
<listitem><para><link linkend="gnumeric-RANK">RANK</link></para></listitem>
263
<listitem><para><link linkend="gnumeric-RATE">RATE</link></para></listitem>
264
<listitem><para><link linkend="gnumeric-RECEIVED">RECEIVED</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
265 266
<listitem><para><link linkend="gnumeric-REPLACE">REPLACE</link></para></listitem>
<listitem><para><link linkend="gnumeric-REPT">REPT</link></para></listitem>
267
<listitem><para><link linkend="gnumeric-RIGHT">RIGHT</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
268 269 270 271
<listitem><para><link linkend="gnumeric-ROMAN">ROMAN</link></para></listitem>
<listitem><para><link linkend="gnumeric-ROUND">ROUND</link></para></listitem>
<listitem><para><link linkend="gnumeric-ROUNDDOWN">ROUNDDOWN</link></para></listitem>
<listitem><para><link linkend="gnumeric-ROUNDUP">ROUNDUP</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
272 273
<listitem><para><link linkend="gnumeric-ROW">ROW</link></para></listitem>
<listitem><para><link linkend="gnumeric-ROWS">ROWS</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
274
<listitem><para><link linkend="gnumeric-RSQ">RSQ</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
275 276 277 278
<listitem><para><link linkend="gnumeric-RandBernoulli">RandBernoulli</link></para></listitem>
<listitem><para><link linkend="gnumeric-RandBinom">RandBinom</link></para></listitem>
<listitem><para><link linkend="gnumeric-RandExp">RandExp</link></para></listitem>
<listitem><para><link linkend="gnumeric-RandPoisson">RandPoisson</link></para></listitem>
279
<listitem><para><link linkend="gnumeric-SEARCH">SEARCH</link></para></listitem>
280 281
<listitem><para><link linkend="gnumeric-SECOND">SECOND</link></para></listitem>
<listitem><para><link linkend="gnumeric-SELECTION">SELECTION</link></para></listitem>
282
<listitem><para><link linkend="gnumeric-SERIESSUM">SERIESSUM</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
283
<listitem><para><link linkend="gnumeric-SIGN">SIGN</link></para></listitem>
284 285
<listitem><para><link linkend="gnumeric-SIN">SIN</link></para></listitem>
<listitem><para><link linkend="gnumeric-SINH">SINH</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
286
<listitem><para><link linkend="gnumeric-SKEW">SKEW</link></para></listitem>
287
<listitem><para><link linkend="gnumeric-SKEWP">SKEWP</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
288
<listitem><para><link linkend="gnumeric-SLN">SLN</link></para></listitem>
289
<listitem><para><link linkend="gnumeric-SLOPE">SLOPE</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
290
<listitem><para><link linkend="gnumeric-SMALL">SMALL</link></para></listitem>
291 292
<listitem><para><link linkend="gnumeric-SQRT">SQRT</link></para></listitem>
<listitem><para><link linkend="gnumeric-SQRTPI">SQRTPI</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
293
<listitem><para><link linkend="gnumeric-STANDARDIZE">STANDARDIZE</link></para></listitem>
294
<listitem><para><link linkend="gnumeric-STDEV">STDEV</link></para></listitem>
295
<listitem><para><link linkend="gnumeric-STDEVA">STDEVA</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
296
<listitem><para><link linkend="gnumeric-STDEVP">STDEVP</link></para></listitem>
297 298
<listitem><para><link linkend="gnumeric-STDEVPA">STDEVPA</link></para></listitem>
<listitem><para><link linkend="gnumeric-STEYX">STEYX</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
299
<listitem><para><link linkend="gnumeric-SUBSTITUTE">SUBSTITUTE</link></para></listitem>
300
<listitem><para><link linkend="gnumeric-SUBTOTAL">SUBTOTAL</link></para></listitem>
301
<listitem><para><link linkend="gnumeric-SUM">SUM</link></para></listitem>
302
<listitem><para><link linkend="gnumeric-SUMA">SUMA</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
303
<listitem><para><link linkend="gnumeric-SUMIF">SUMIF</link></para></listitem>
304
<listitem><para><link linkend="gnumeric-SUMPRODUCT">SUMPRODUCT</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
305 306 307 308
<listitem><para><link linkend="gnumeric-SUMSQ">SUMSQ</link></para></listitem>
<listitem><para><link linkend="gnumeric-SUMX2MY2">SUMX2MY2</link></para></listitem>
<listitem><para><link linkend="gnumeric-SUMX2PY2">SUMX2PY2</link></para></listitem>
<listitem><para><link linkend="gnumeric-SUMXMY2">SUMXMY2</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
309
<listitem><para><link linkend="gnumeric-SYD">SYD</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
310
<listitem><para><link linkend="gnumeric-T">T</link></para></listitem>
311 312
<listitem><para><link linkend="gnumeric-TAN">TAN</link></para></listitem>
<listitem><para><link linkend="gnumeric-TANH">TANH</link></para></listitem>
313 314 315
<listitem><para><link linkend="gnumeric-TBILLEQ">TBILLEQ</link></para></listitem>
<listitem><para><link linkend="gnumeric-TBILLPRICE">TBILLPRICE</link></para></listitem>
<listitem><para><link linkend="gnumeric-TBILLYIELD">TBILLYIELD</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
316
<listitem><para><link linkend="gnumeric-TDIST">TDIST</link></para></listitem>
317
<listitem><para><link linkend="gnumeric-TEXT">TEXT</link></para></listitem>
318
<listitem><para><link linkend="gnumeric-TIME">TIME</link></para></listitem>
319
<listitem><para><link linkend="gnumeric-TIMEVALUE">TIMEVALUE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
320
<listitem><para><link linkend="gnumeric-TINV">TINV</link></para></listitem>
321
<listitem><para><link linkend="gnumeric-TODAY">TODAY</link></para></listitem>
322 323
<listitem><para><link linkend="gnumeric-TRANSPOSE">TRANSPOSE</link></para></listitem>
<listitem><para><link linkend="gnumeric-TREND">TREND</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
324 325
<listitem><para><link linkend="gnumeric-TRIM">TRIM</link></para></listitem>
<listitem><para><link linkend="gnumeric-TRIMMEAN">TRIMMEAN</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
326
<listitem><para><link linkend="gnumeric-TRUE">TRUE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
327
<listitem><para><link linkend="gnumeric-TRUNC">TRUNC</link></para></listitem>
328 329
<listitem><para><link linkend="gnumeric-TTEST">TTEST</link></para></listitem>
<listitem><para><link linkend="gnumeric-TYPE">TYPE</link></para></listitem>
330
<listitem><para><link linkend="gnumeric-UPPER">UPPER</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
331
<listitem><para><link linkend="gnumeric-VALUE">VALUE</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
332
<listitem><para><link linkend="gnumeric-VAR">VAR</link></para></listitem>
333
<listitem><para><link linkend="gnumeric-VARA">VARA</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
334
<listitem><para><link linkend="gnumeric-VARP">VARP</link></para></listitem>
335
<listitem><para><link linkend="gnumeric-VARPA">VARPA</link></para></listitem>
Jody Goldberg's avatar
update  
Jody Goldberg committed
336
<listitem><para><link linkend="gnumeric-VDB">VDB</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
337
<listitem><para><link linkend="gnumeric-VLOOKUP">VLOOKUP</link></para></listitem>
338
<listitem><para><link linkend="gnumeric-WEEKDAY">WEEKDAY</link></para></listitem>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
339
<listitem><para><link linkend="gnumeric-WEIBULL">WEIBULL</link></para></listitem>
340
<listitem><para><link linkend="gnumeric-WORKDAY">WORKDAY</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
341
<listitem><para><link linkend="gnumeric-XIRR">XIRR</link></para></listitem>
342
<listitem><para><link linkend="gnumeric-XNPV">XNPV</link></para></listitem>
343
<listitem><para><link linkend="gnumeric-YEAR">YEAR</link></para></listitem>
Jody Goldberg's avatar
Jody Goldberg committed
344 345 346
<listitem><para><link linkend="gnumeric-YIELD">YIELD</link></para></listitem>
<listitem><para><link linkend="gnumeric-YIELDDISC">YIELDDISC</link></para></listitem>
<listitem><para><link linkend="gnumeric-YIELDMAT">YIELDMAT</link></para></listitem>
Arturo Espinosa's avatar
Arturo Espinosa committed
347
<listitem><para><link linkend="gnumeric-ZTEST">ZTEST</link></para></listitem>
348 349 350 351 352
</itemizedlist>


  <refentry>
    <refmeta>
353
      <refentrytitle><anchor id="gnumeric-LCM">LCM</refentrytitle><refmiscinfo></refmiscinfo>
354 355
    </refmeta>
    <refnamediv>
356
      <refname>LCM</refname>
357 358 359
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
360
      <synopsis>LCM(number1,number2,...)</synopsis>
361 362 363
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
364 365
        <para>LCM returns the least common multiple of integers.  The least common multiple is the smallest positive number that is a multiple of all integer arguments given.</para>
        <para>If any of the arguments is less than one, LCM returns #NUM! error. This function is Excel compatible.</para>
366 367 368 369
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para>LCM(2,13) equlas to 26.</para>        <para>LCM(4,7,5) equals to 140.</para>        <para></para>
370 371
    </refsect1>
    <refsect1><title>See also</title>
372
      <para>        <link linkend="gnumeric-GCD">GCD</link>.
373 374 375 376 377 378
      </para>
    </refsect1>
  </refentry>



379 380 381 382 383 384 385 386 387
  <refentry>
    <refmeta>
      <refentrytitle><anchor id="gnumeric-PRICEDISC">PRICEDISC</refentrytitle><refmiscinfo></refmiscinfo>
    </refmeta>
    <refnamediv>
      <refname>PRICEDISC</refname>
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
388
      <synopsis>PRICEDISC(settlement,maturity,discount,redemption[,basis])</synopsis>
389
    </refsynopsisdiv>
390 391 392
      <refsect1>
        <title>Description</title>
        <para>PRICEDISC calculates and returns the price per $100 face value of a security bond.  The security does not pay interest at maturity.  @discount is the rate for which the security is discounted.  @redemption is the amount to be received on @maturity date.  @basis is the type of day counting system you want to use:</para>
393
        <para></para>        <para>0  US 30/360</para>        <para>1  actual days/actual days</para>        <para>2  actual days/360</para>        <para>3  actual days/365</para>        <para>4  European 30/360</para>        <para></para>        <para>If @basis is omitted, US 30/360 is applied. If @settlement date or @maturity date is not valid, PRICEDISC returns #NUM! error. If @basis &lt; 0 or @basis &gt; 4, PRICEDISC returns #NUM! error. If @settlement date is after @maturity date or they are the same, PRICEDISC returns #NUM! error.</para>
394 395 396 397
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
398 399
    </refsect1>
    <refsect1><title>See also</title>
400
      <para>        <link linkend="gnumeric-PRICEMAT">PRICEMAT</link>.
401 402 403 404 405 406
      </para>
    </refsect1>
  </refentry>



407 408
  <refentry>
    <refmeta>
409
      <refentrytitle><anchor id="gnumeric-IMARGUMENT">IMARGUMENT</refentrytitle><refmiscinfo></refmiscinfo>
410 411
    </refmeta>
    <refnamediv>
412
      <refname>IMARGUMENT</refname>
413 414 415
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
416
      <synopsis>IMARGUMENT(inumber)</synopsis>
417 418 419
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
420
        <para>IMARGUMENT returns the argument theta of a complex number. This function is Excel compatible.</para>
421 422 423 424 425

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para>IMARGUMENT("2-j") equals -0.463647609.</para>        <para></para>
426 427
    </refsect1>
    <refsect1><title>See also</title>
428
      <para>      </para>
429 430 431 432 433
    </refsect1>
  </refentry>



Arturo Espinosa's avatar
Arturo Espinosa committed
434 435
  <refentry>
    <refmeta>
436
      <refentrytitle><anchor id="gnumeric-RANDBETWEEN">RANDBETWEEN</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
437 438
    </refmeta>
    <refnamediv>
439
      <refname>RANDBETWEEN</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
440 441 442
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
443
      <synopsis>RANDBETWEEN(bottom,top)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
444 445 446
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
447
        <para>RANDBETWEEN function returns a random integer number between @bottom and @top.</para>
448
        <para>If @bottom or @top is non-integer, they are truncated. If @bottom &gt; @top, RANDBETWEEN returns #NUM! error.</para>        <para>This function is Excel compatible.</para>
449 450 451 452
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para>RANDBETWEEN(3,7).</para>        <para></para>
Arturo Espinosa's avatar
Arturo Espinosa committed
453 454
    </refsect1>
    <refsect1><title>See also</title>
455
      <para>        <link linkend="gnumeric-RAND">RAND</link>.
Arturo Espinosa's avatar
Arturo Espinosa committed
456 457 458 459 460 461 462 463
      </para>
    </refsect1>
  </refentry>



  <refentry>
    <refmeta>
464
      <refentrytitle><anchor id="gnumeric-COSH">COSH</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
465 466
    </refmeta>
    <refnamediv>
467
      <refname>COSH</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
468 469 470
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
471
      <synopsis>COSH(x)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
472 473 474
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
475
        <para>COSH function returns the hyperbolic cosine of @x, which is defined mathematically as (exp(@x) + exp(-@x)) / 2.   @x is in radians. This function is Excel compatible.</para>
476 477 478 479

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
Jody Goldberg's avatar
update  
Jody Goldberg committed
480
        <para>COSH(0.5) equals 1.127626.</para>        <para>COSH(1) equals 1.543081.</para>        <para></para>
Arturo Espinosa's avatar
Arturo Espinosa committed
481 482
    </refsect1>
    <refsect1><title>See also</title>
483 484 485 486 487 488 489 490
      <para>        <link linkend="gnumeric-COS">COS</link>,
        <link linkend="gnumeric-SIN">SIN</link>,
        <link linkend="gnumeric-SINH">SINH</link>,
        <link linkend="gnumeric-TAN">TAN</link>,
        <link linkend="gnumeric-TANH">TANH</link>,
        <link linkend="gnumeric-RADIANS">RADIANS</link>,
        <link linkend="gnumeric-DEGREES">DEGREES</link>,
        <link linkend="gnumeric-EXP">EXP</link>.
491
      </para>
Arturo Espinosa's avatar
Arturo Espinosa committed
492 493 494 495 496
    </refsect1>
  </refentry>



Jody Goldberg's avatar
Jody Goldberg committed
497 498 499 500 501 502 503 504 505 506 507 508 509 510
  <refentry>
    <refmeta>
      <refentrytitle><anchor id="gnumeric-YIELDDISC">YIELDDISC</refentrytitle><refmiscinfo></refmiscinfo>
    </refmeta>
    <refnamediv>
      <refname>YIELDDISC</refname>
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
      <synopsis>YIELDDISC(settlement,maturity,pr,redemption,basis)</synopsis>
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
        <para></para>
511 512 513 514 515

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
Jody Goldberg's avatar
Jody Goldberg committed
516 517 518 519 520 521 522 523
    </refsect1>
    <refsect1><title>See also</title>
      <para>      </para>
    </refsect1>
  </refentry>



Arturo Espinosa's avatar
Arturo Espinosa committed
524 525
  <refentry>
    <refmeta>
526
      <refentrytitle><anchor id="gnumeric-REPT">REPT</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
527 528
    </refmeta>
    <refnamediv>
529
      <refname>REPT</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
530 531 532
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
533
      <synopsis>REPT(string,num)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
534 535 536
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
Jody Goldberg's avatar
Jody Goldberg committed
537
        <para>REPT returns @num repetitions of @string.</para>
538 539 540 541 542

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para>REPT(".",3) equals "...".</para>        <para></para>
Arturo Espinosa's avatar
Arturo Espinosa committed
543 544
    </refsect1>
    <refsect1><title>See also</title>
545
      <para>        <link linkend="gnumeric-CONCATENATE">CONCATENATE</link>.
Arturo Espinosa's avatar
Arturo Espinosa committed
546 547 548 549 550 551
      </para>
    </refsect1>
  </refentry>



Arturo Espinosa's avatar
Arturo Espinosa committed
552 553
  <refentry>
    <refmeta>
554
      <refentrytitle><anchor id="gnumeric-DEGREES">DEGREES</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
555 556
    </refmeta>
    <refnamediv>
557
      <refname>DEGREES</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
558 559 560
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
561
      <synopsis>DEGREES(x)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
562 563 564
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
565
        <para>DEGREES computes the number of degrees equivalent to @x radians. This function is Excel compatible.</para>
566 567 568 569 570

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para>DEGREES(2.5) equals 143.2394.</para>        <para></para>
Arturo Espinosa's avatar
Arturo Espinosa committed
571 572
    </refsect1>
    <refsect1><title>See also</title>
573 574
      <para>        <link linkend="gnumeric-RADIANS">RADIANS</link>,
        <link linkend="gnumeric-PI">PI</link>.
Arturo Espinosa's avatar
Arturo Espinosa committed
575 576 577 578 579 580 581 582
      </para>
    </refsect1>
  </refentry>



  <refentry>
    <refmeta>
583
      <refentrytitle><anchor id="gnumeric-NOMINAL">NOMINAL</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
584 585
    </refmeta>
    <refnamediv>
586
      <refname>NOMINAL</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
587 588 589
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
590
      <synopsis>NOMINAL(r,nper)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
591 592 593
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
Jody Goldberg's avatar
Jody Goldberg committed
594
        <para>NOMINAL calculates the nominal interest rate from a given effective rate.</para>
Jody Goldberg's avatar
Jody Goldberg committed
595
        <para>Nominal interest rate is given by a formula:</para>        <para></para>        <para>@nper * (( 1 + @r ) ^ (1 / @nper) - 1 )</para>        <para>where:</para>        <para></para>        <para>@r = effective interest rate</para>        <para>@nper = number of periods used for compounding</para>
596 597 598 599
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
Arturo Espinosa's avatar
Arturo Espinosa committed
600 601
    </refsect1>
    <refsect1><title>See also</title>
602
      <para>        <link linkend="gnumeric-EFFECT">EFFECT</link>.
Arturo Espinosa's avatar
Arturo Espinosa committed
603 604 605 606 607 608
      </para>
    </refsect1>
  </refentry>



609 610
  <refentry>
    <refmeta>
611
      <refentrytitle><anchor id="gnumeric-ISODD">ISODD</refentrytitle><refmiscinfo></refmiscinfo>
612 613
    </refmeta>
    <refnamediv>
614
      <refname>ISODD</refname>
615 616
      <refpurpose></refpurpose>
    </refnamediv>
Arturo Espinosa's avatar
Arturo Espinosa committed
617
    <refsynopsisdiv>
Jody Goldberg's avatar
Jody Goldberg committed
618
      <synopsis>ISODD(value)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
619 620 621
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
622
        <para>ISODD returns TRUE if the number is odd. This function is Excel compatible.</para>
623 624 625 626 627

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
628 629
    </refsect1>
    <refsect1><title>See also</title>
630
      <para>        <link linkend="gnumeric-ISEVEN">ISEVEN</link>.
631
      </para>
632 633 634 635 636
    </refsect1>
  </refentry>



637 638
  <refentry>
    <refmeta>
639
      <refentrytitle><anchor id="gnumeric-RSQ">RSQ</refentrytitle><refmiscinfo></refmiscinfo>
640 641
    </refmeta>
    <refnamediv>
642
      <refname>RSQ</refname>
643 644 645
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
646
      <synopsis>RSQ(array1,array2)</synopsis>
647 648 649
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
Jody Goldberg's avatar
Jody Goldberg committed
650
        <para>RSQ returns the square of the Pearson correlation coefficient of two data sets.</para>
651
        <para>Strings and empty cells are simply ignored. This function is Excel compatible.</para>
652 653 654 655
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
656 657
    </refsect1>
    <refsect1><title>See also</title>
658 659 660 661 662 663 664 665 666
      <para>        <link linkend="gnumeric-CORREL">CORREL</link>,
        <link linkend="gnumeric-COVAR">COVAR</link>,
        <link linkend="gnumeric-INTERCEPT">INTERCEPT</link>,
        <link linkend="gnumeric-LINEST">LINEST</link>,
        <link linkend="gnumeric-LOGEST">LOGEST</link>,
        <link linkend="gnumeric-PEARSON">PEARSON</link>,
        <link linkend="gnumeric-SLOPE">SLOPE</link>,
        <link linkend="gnumeric-STEYX">STEYX</link>,
        <link linkend="gnumeric-TREND">TREND</link>.
667 668 669 670 671 672
      </para>
    </refsect1>
  </refentry>



Jody Goldberg's avatar
Jody Goldberg committed
673 674 675 676 677 678 679 680 681 682 683 684 685 686
  <refentry>
    <refmeta>
      <refentrytitle><anchor id="gnumeric-ODDLYIELD">ODDLYIELD</refentrytitle><refmiscinfo></refmiscinfo>
    </refmeta>
    <refnamediv>
      <refname>ODDLYIELD</refname>
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
      <synopsis>ODDLYIELD(settlement,maturity,last_interest,rate,pr,redemption,frequency,basis)</synopsis>
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
        <para></para>
687 688 689 690 691

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
Jody Goldberg's avatar
Jody Goldberg committed
692 693 694 695 696 697 698 699
    </refsect1>
    <refsect1><title>See also</title>
      <para>      </para>
    </refsect1>
  </refentry>



700 701
  <refentry>
    <refmeta>
702
      <refentrytitle><anchor id="gnumeric-COLUMN">COLUMN</refentrytitle><refmiscinfo></refmiscinfo>
703 704
    </refmeta>
    <refnamediv>
705
      <refname>COLUMN</refname>
706 707 708
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
709
      <synopsis>COLUMN([reference])</synopsis>
710 711 712
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
713
        <para>The COLUMN function returns an array of the column numbers taking a default argument of the containing cell position.</para>
714 715 716 717 718
        <para>If @reference is neither an array nor a reference nor a range returns #VALUE!.</para>
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
719 720
    </refsect1>
    <refsect1><title>See also</title>
721 722 723
      <para>        <link linkend="gnumeric-COLUMNS">COLUMNS</link>,
        <link linkend="gnumeric-ROW">ROW</link>,
        <link linkend="gnumeric-ROWS">ROWS</link>.
724 725 726 727 728 729
      </para>
    </refsect1>
  </refentry>



Arturo Espinosa's avatar
Arturo Espinosa committed
730 731
  <refentry>
    <refmeta>
732
      <refentrytitle><anchor id="gnumeric-RATE">RATE</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
733 734
    </refmeta>
    <refnamediv>
735
      <refname>RATE</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
736 737 738
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
739
      <synopsis>RATE(nper,pmt,pv[,fv,type,guess])</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
740 741 742
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
Jody Goldberg's avatar
Jody Goldberg committed
743
        <para>RATE calculates rate of an investment.</para>
744 745 746 747 748

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
749 750
    </refsect1>
    <refsect1><title>See also</title>
751 752
      <para>        <link linkend="gnumeric-PV">PV</link>,
        <link linkend="gnumeric-FV">FV</link>.
753 754 755
      </para>
    </refsect1>
  </refentry>
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
756 757


Arturo Espinosa's avatar
Arturo Espinosa committed
758

759 760
  <refentry>
    <refmeta>
761
      <refentrytitle><anchor id="gnumeric-DPRODUCT">DPRODUCT</refentrytitle><refmiscinfo></refmiscinfo>
762 763
    </refmeta>
    <refnamediv>
764
      <refname>DPRODUCT</refname>
765 766 767
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
768
      <synopsis>DPRODUCT(database,field,criteria)</synopsis>
769 770 771
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
772 773
        <para>DPRODUCT function returns the product of numbers in a column that match conditions specified.</para>
        <para>@database is a range of cells 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.</para>        <para>@field specifies which column is used in the function.  If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column.  For example, ``Age'' refers to the column with the label ``Age'' in @database range.</para>        <para>@criteria is the range of cells which contains the specified conditions.  The first row of a @criteria should contain the labels of the fields for which the criterias are for.  Cells below the labels specify conditions, for example, ``&gt;3'' or ``&lt;9''.  Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''.  Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria).  If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria).</para>
774 775 776
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
777
        <para>Let us assume that the range A1:C7 contain the following values:</para>        <para>Name    Age     Salary</para>        <para>John    34      54342</para>        <para>Bill    35      22343</para>        <para>Clark   29      34323</para>        <para>Bob     43      47242</para>        <para>Susan   37      42932</para>        <para>Jill    45      45324</para>        <para></para>        <para>In addition, the cells A9:B11 contain the following values:</para>        <para>Age     Salary</para>        <para>&lt;30</para>        <para>&gt;40     &gt;46000</para>        <para></para>        <para>DPRODUCT(A1:C7, "Age", A9:B11) equals 1247.</para>        <para></para>
778 779
    </refsect1>
    <refsect1><title>See also</title>
780
      <para>        <link linkend="gnumeric-DSUM">DSUM</link>.
781 782 783 784 785 786
      </para>
    </refsect1>
  </refentry>



Arturo Espinosa's avatar
Arturo Espinosa committed
787 788
  <refentry>
    <refmeta>
789
      <refentrytitle><anchor id="gnumeric-FDIST">FDIST</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
790 791
    </refmeta>
    <refnamediv>
792
      <refname>FDIST</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
793 794 795
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
796
      <synopsis>FDIST(x,dof1,dof2)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
797 798 799
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
800
        <para>FDIST function returns the F probability distribution. @dof1 is the numerator degrees of freedom and @dof2 is the denominator degrees of freedom.</para>
801
        <para>If @x &lt; 0 FDIST returns #NUM! error. If @dof1 &lt; 1 or @dof2 &lt; 1, FDIST returns #NUM! error. This function is Excel compatible.</para>
802 803 804 805
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para>FDIST(2,5,5) equals 0.232511319.</para>        <para></para>
Arturo Espinosa's avatar
Arturo Espinosa committed
806 807
    </refsect1>
    <refsect1><title>See also</title>
808
      <para>        <link linkend="gnumeric-FINV">FINV</link>.
Arturo Espinosa's avatar
Arturo Espinosa committed
809 810 811 812 813 814
      </para>
    </refsect1>
  </refentry>



Arturo Espinosa's avatar
Arturo Espinosa committed
815 816
  <refentry>
    <refmeta>
817
      <refentrytitle><anchor id="gnumeric-ISEVEN">ISEVEN</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
818 819
    </refmeta>
    <refnamediv>
820
      <refname>ISEVEN</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
821 822 823
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
Jody Goldberg's avatar
Jody Goldberg committed
824
      <synopsis>ISEVEN(value)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
825 826 827
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
828
        <para>ISEVEN returns TRUE if the number is even. This function is Excel compatible.</para>
829 830 831 832 833

    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para></para>
Arturo Espinosa's avatar
Arturo Espinosa committed
834 835
    </refsect1>
    <refsect1><title>See also</title>
836
      <para>        <link linkend="gnumeric-ISODD">ISODD</link>.
837
      </para>
Arturo Espinosa's avatar
Arturo Espinosa committed
838 839 840 841 842
    </refsect1>
  </refentry>



Arturo Espinosa's avatar
Arturo Espinosa committed
843 844
  <refentry>
    <refmeta>
845
      <refentrytitle><anchor id="gnumeric-ZTEST">ZTEST</refentrytitle><refmiscinfo></refmiscinfo>
Arturo Espinosa's avatar
Arturo Espinosa committed
846 847
    </refmeta>
    <refnamediv>
848
      <refname>ZTEST</refname>
Arturo Espinosa's avatar
Arturo Espinosa committed
849 850 851
      <refpurpose></refpurpose>
    </refnamediv>
    <refsynopsisdiv>
852
      <synopsis>ZTEST(ref,x)</synopsis>
Arturo Espinosa's avatar
Arturo Espinosa committed
853 854 855
    </refsynopsisdiv>
      <refsect1>
        <title>Description</title>
856
        <para>ZTEST returns the two-tailed probability of a z-test.</para>
857
        <para>@ref is the data set and @x is the value to be tested.</para>        <para>If @ref contains less than two data items ZTEST returns #DIV/0! error. This function is Excel compatible.</para>
858 859 860 861
    </refsect1>      <refsect1>
        <title>Examples</title>
        <para></para>
        <para>Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then</para>        <para>ZTEST(A1:A5,20) equals 0.254717826.</para>        <para></para>
862 863
    </refsect1>
    <refsect1><title>See also</title>
864 865 866 867 868 869
      <para>        <link linkend="gnumeric-CONFIDENCE">CONFIDENCE</link>,
        <link linkend="gnumeric-NORMDIST">NORMDIST</link>,
        <link linkend="gnumeric-NORMINV">NORMINV</link>,
        <link linkend="gnumeric-NORMSDIST">NORMSDIST</link>,
        <link linkend="gnumeric-NORMSINV">NORMSINV</link>,
        <link linkend="gnumeric-STANDARDIZE">STANDARDIZE</link>.
870 871 872
      </para>
    </refsect1>
  </refentry>
Arturo Espinosa's avatar
Arturo Espinosa committed
873 874 875



876 <