func.defs 145 KB
Newer Older
1 2 3
@FUNCTION=LCM
@SYNTAX=LCM(number1,number2,...)
@DESCRIPTION=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. 
Jody Goldberg's avatar
Jody Goldberg committed
4 5 6 7 8
If any of the arguments is less than one, LCM returns #NUM! error. This function is Excel compatible. 
@EXAMPLES=
LCM(2,13) equlas to 26.
LCM(4,7,5) equals to 140.

9
@SEEALSO=GCD
10

11
@FUNCTION=PRICEDISC
12 13
@SYNTAX=PRICEDISC(settlement,maturity,discount,redemption[,basis])
@DESCRIPTION=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:
14 15 16 17 18 19 20

0  US 30/360
1  actual days/actual days
2  actual days/360
3  actual days/365
4  European 30/360

Jody Goldberg's avatar
Jody Goldberg committed
21
If @basis is omitted, US 30/360 is applied. If @settlement date or @maturity date is not valid, PRICEDISC returns #NUM! error. If @basis < 0 or @basis > 4, PRICEDISC returns #NUM! error. If @settlement date is after @maturity date or they are the same, PRICEDISC returns #NUM! error. 
22 23
@EXAMPLES=

24 25
@SEEALSO=PRICEMAT

26 27
@FUNCTION=IMARGUMENT
@SYNTAX=IMARGUMENT(inumber)
Jody Goldberg's avatar
Jody Goldberg committed
28 29 30 31
@DESCRIPTION=IMARGUMENT returns the argument theta of a complex number. This function is Excel compatible. 
@EXAMPLES=
IMARGUMENT("2-j") equals -0.463647609.

32 33 34 35 36 37
@SEEALSO=

@FUNCTION=RANDBETWEEN
@SYNTAX=RANDBETWEEN(bottom,top)
@DESCRIPTION=RANDBETWEEN function returns a random integer number between @bottom and @top.
If @bottom or @top is non-integer, they are truncated. If @bottom > @top, RANDBETWEEN returns #NUM! error.
Jody Goldberg's avatar
Jody Goldberg committed
38 39 40 41
This function is Excel compatible. 
@EXAMPLES=
RANDBETWEEN(3,7).

42 43 44 45
@SEEALSO=RAND

@FUNCTION=COSH
@SYNTAX=COSH(x)
Jody Goldberg's avatar
Jody Goldberg committed
46 47
@DESCRIPTION=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. 
@EXAMPLES=
Jody Goldberg's avatar
update  
Jody Goldberg committed
48 49 50
COSH(0.5) equals 1.127626.
COSH(1) equals 1.543081.

51
@SEEALSO=COS, SIN, SINH, TAN, TANH, RADIANS, DEGREES, EXP
52

Jody Goldberg's avatar
Jody Goldberg committed
53 54 55 56 57 58 59
@FUNCTION=YIELDDISC
@SYNTAX=YIELDDISC(settlement,maturity,pr,redemption,basis)
@DESCRIPTION=
@EXAMPLES=

@SEEALSO=

60 61
@FUNCTION=REPT
@SYNTAX=REPT(string,num)
Jody Goldberg's avatar
Jody Goldberg committed
62 63 64 65
@DESCRIPTION=REPT returns @num repetitions of @string.
@EXAMPLES=
REPT(".",3) equals "...".

66 67 68 69
@SEEALSO=CONCATENATE

@FUNCTION=DEGREES
@SYNTAX=DEGREES(x)
Jody Goldberg's avatar
Jody Goldberg committed
70 71 72 73
@DESCRIPTION=DEGREES computes the number of degrees equivalent to @x radians. This function is Excel compatible. 
@EXAMPLES=
DEGREES(2.5) equals 143.2394.

74 75 76
@SEEALSO=RADIANS, PI

@FUNCTION=NOMINAL
77
@SYNTAX=NOMINAL(r,nper)
Jody Goldberg's avatar
Jody Goldberg committed
78
@DESCRIPTION=NOMINAL calculates the nominal interest rate from a given effective rate.
79 80
Nominal interest rate is given by a formula:

Jody Goldberg's avatar
Jody Goldberg committed
81
@nper * (( 1 + @r ) ^ (1 / @nper) - 1 )
82 83
where:

Jody Goldberg's avatar
Jody Goldberg committed
84 85
@r = effective interest rate
@nper = number of periods used for compounding
Jody Goldberg's avatar
Jody Goldberg committed
86 87
@EXAMPLES=

88 89 90
@SEEALSO=EFFECT

@FUNCTION=ISODD
Jody Goldberg's avatar
Jody Goldberg committed
91
@SYNTAX=ISODD(value)
Jody Goldberg's avatar
Jody Goldberg committed
92 93 94
@DESCRIPTION=ISODD returns TRUE if the number is odd. This function is Excel compatible. 
@EXAMPLES=

95
@SEEALSO=ISEVEN
96 97 98

@FUNCTION=RSQ
@SYNTAX=RSQ(array1,array2)
Jody Goldberg's avatar
Jody Goldberg committed
99
@DESCRIPTION=RSQ returns the square of the Pearson correlation coefficient of two data sets.
Jody Goldberg's avatar
Jody Goldberg committed
100 101 102
Strings and empty cells are simply ignored. This function is Excel compatible. 
@EXAMPLES=

103
@SEEALSO=CORREL,COVAR,INTERCEPT,LINEST,LOGEST,PEARSON,SLOPE,STEYX,TREND
Arturo Espinosa's avatar
Arturo Espinosa committed
104

Jody Goldberg's avatar
Jody Goldberg committed
105 106 107 108 109 110 111
@FUNCTION=ODDLYIELD
@SYNTAX=ODDLYIELD(settlement,maturity,last_interest,rate,pr,redemption,frequency,basis)
@DESCRIPTION=
@EXAMPLES=

@SEEALSO=

112 113 114
@FUNCTION=COLUMN
@SYNTAX=COLUMN([reference])
@DESCRIPTION=The COLUMN function returns an array of the column numbers taking a default argument of the containing cell position.
115
If @reference is neither an array nor a reference nor a range returns #VALUE!.
Jody Goldberg's avatar
Jody Goldberg committed
116 117
@EXAMPLES=

118 119 120 121
@SEEALSO=COLUMNS,ROW,ROWS

@FUNCTION=RATE
@SYNTAX=RATE(nper,pmt,pv[,fv,type,guess])
Jody Goldberg's avatar
Jody Goldberg committed
122 123 124
@DESCRIPTION=RATE calculates rate of an investment.
@EXAMPLES=

125
@SEEALSO=PV,FV
126 127 128 129 130

@FUNCTION=DPRODUCT
@SYNTAX=DPRODUCT(database,field,criteria)
@DESCRIPTION=DPRODUCT function returns the product of numbers in a column that match conditions specified. 
@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. 
Jody Goldberg's avatar
Jody Goldberg committed
131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149
@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. 
@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, ``>3'' or ``<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). 
@EXAMPLES=
Let us assume that the range A1:C7 contain the following values:
Name    Age     Salary
John    34      54342
Bill    35      22343
Clark   29      34323
Bob     43      47242
Susan   37      42932
Jill    45      45324

In addition, the cells A9:B11 contain the following values:
Age     Salary
<30
>40     >46000

DPRODUCT(A1:C7, "Age", A9:B11) equals 1247.

150 151 152 153 154
@SEEALSO=DSUM

@FUNCTION=FDIST
@SYNTAX=FDIST(x,dof1,dof2)
@DESCRIPTION=FDIST function returns the F probability distribution. @dof1 is the numerator degrees of freedom and @dof2 is the denominator degrees of freedom.
Jody Goldberg's avatar
Jody Goldberg committed
155 156 157 158
If @x < 0 FDIST returns #NUM! error. If @dof1 < 1 or @dof2 < 1, FDIST returns #NUM! error. This function is Excel compatible. 
@EXAMPLES=
FDIST(2,5,5) equals 0.232511319.

159 160 161
@SEEALSO=FINV

@FUNCTION=ISEVEN
Jody Goldberg's avatar
Jody Goldberg committed
162
@SYNTAX=ISEVEN(value)
Jody Goldberg's avatar
Jody Goldberg committed
163 164 165
@DESCRIPTION=ISEVEN returns TRUE if the number is even. This function is Excel compatible. 
@EXAMPLES=

166
@SEEALSO=ISODD
Arturo Espinosa's avatar
Arturo Espinosa committed
167

168 169 170 171
@FUNCTION=ZTEST
@SYNTAX=ZTEST(ref,x)
@DESCRIPTION=ZTEST returns the two-tailed probability of a z-test.
@ref is the data set and @x is the value to be tested.
Jody Goldberg's avatar
Jody Goldberg committed
172 173 174 175 176
If @ref contains less than two data items ZTEST returns #DIV/0! error. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then
ZTEST(A1:A5,20) equals 0.254717826.

177 178 179 180 181 182
@SEEALSO=CONFIDENCE,NORMDIST,NORMINV,NORMSDIST,NORMSINV,STANDARDIZE

@FUNCTION=DMIN
@SYNTAX=DMIN(database,field,criteria)
@DESCRIPTION=DMIN function returns the smallest number in a column that match conditions specified. 
@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. 
Jody Goldberg's avatar
Jody Goldberg committed
183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202
@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. 
@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, ``>3'' or ``<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). 
@EXAMPLES=
Let us assume that the range A1:C7 contain the following values:
Name    Age     Salary
John    34      54342
Bill    35      22343
Clark   29      34323
Bob     43      47242
Susan   37      42932
Jill    45      45324

In addition, the cells A9:B11 contain the following values:
Age     Salary
<30
>40     >46000

DMIN(A1:C7, "Salary", A9:B11) equals 34323.
DMIN(A1:C7, "Age", A9:B11) equals 29.

203 204
@SEEALSO=DMAX

205 206
@FUNCTION=TEXT
@SYNTAX=TEXT(value,format_text)
Jody Goldberg's avatar
Jody Goldberg committed
207 208 209 210 211
@DESCRIPTION=TEXT returns @value as a string with the specified format.
@EXAMPLES=
TEXT(3.223,"$0.00") equals "$3.22".
TEXT(date(1999,4,15),"mmmm, dd, yy") equals "April, 15, 99".

212 213
@SEEALSO=DOLLAR

Jody Goldberg's avatar
Jody Goldberg committed
214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231
@FUNCTION=RandBinom
@SYNTAX=RandBinom(p,trials)
@DESCRIPTION=RandBinom returns a binomialy distributed random number. 
If @p < 0 or @p > 1 RandBinom returns #NUM! error. If @trials < 0 RandBinom returns #NUM! error. 
@EXAMPLES=
RandBinom(0.5,2).

@SEEALSO=RAND,RANDBETWEEN

@FUNCTION=RandBernoulli
@SYNTAX=RandBernoulli(p)
@DESCRIPTION=RandBernoulli returns a Bernoulli distributed random number. 
If @p < 0 or @p > 1 RandBernoulli returns #NUM! error. 
@EXAMPLES=
RandBernoulli(0.5).

@SEEALSO=RAND,RANDBETWEEN

232 233
@FUNCTION=WEEKDAY
@SYNTAX=WEEKDAY (serial_number)
Jody Goldberg's avatar
Jody Goldberg committed
234 235 236 237
@DESCRIPTION=Converts a serial number to a weekday.

This function returns an integer in the range 0-6, where Saturday is 0, Sunday is 1, etc.

238
Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.
Jody Goldberg's avatar
Jody Goldberg committed
239
@EXAMPLES=
Jody Goldberg's avatar
Jody Goldberg committed
240
WEEKDAY("10/24/1968") equals 5 (Thursday).
Jody Goldberg's avatar
Jody Goldberg committed
241

Jody Goldberg's avatar
Jody Goldberg committed
242
@SEEALSO=DAY, MONTH, TIME, NOW, YEAR
243 244 245

@FUNCTION=PRODUCT
@SYNTAX=PRODUCT(value1, value2, ...)
Jody Goldberg's avatar
Jody Goldberg committed
246 247 248 249 250 251 252 253 254 255 256 257 258
@DESCRIPTION=PRODUCT returns the product of all the values and cells referenced in the argument list. This function is Excel compatible.  In particular, this means that if all cells are empty, the result will be 0.
@EXAMPLES=
PRODUCT(2,5,9) equals 90.

@SEEALSO=SUM, COUNT, G_PRODUCT

@FUNCTION=RandPoisson
@SYNTAX=RandPoisson(lambda)
@DESCRIPTION=RandPoisson returns a poisson distributed random number. 
@EXAMPLES=
RandPoisson(3).

@SEEALSO=RAND,RANDBETWEEN
259 260 261

@FUNCTION=MULTINOMIAL
@SYNTAX=MULTINOMIAL(value1, value2, ...)
Jody Goldberg's avatar
Jody Goldberg committed
262 263 264 265
@DESCRIPTION=MULTINOMIAL returns the ratio of the factorial of a sum of values to the product of factorials. This function is Excel compatible. 
@EXAMPLES=
MULTINOMIAL(2,3,4) equals 1260.

266 267 268 269
@SEEALSO=SUM

@FUNCTION=IMSIN
@SYNTAX=IMSIN(inumber)
Jody Goldberg's avatar
Jody Goldberg committed
270 271 272 273
@DESCRIPTION=IMSIN returns the sine of a complex number. This function is Excel compatible. 
@EXAMPLES=
IMSIN("1+j") equals 1.29846+0.63496j.

274
@SEEALSO=IMCOS,IMTAN
275 276 277

@FUNCTION=COS
@SYNTAX=COS(x)
Jody Goldberg's avatar
Jody Goldberg committed
278 279 280 281 282
@DESCRIPTION=COS function returns the cosine of @x, where @x is given in radians. This function is Excel compatible. 
@EXAMPLES=
COS(0.5) equals 0.877583.
COS(1) equals 0.540302.

283 284 285 286
@SEEALSO=COSH, SIN, SINH, TAN, TANH, RADIANS, DEGREES

@FUNCTION=EXP
@SYNTAX=EXP(x)
Jody Goldberg's avatar
Jody Goldberg committed
287 288 289 290
@DESCRIPTION=EXP computes the value of e (the base of natural logarithmns) raised to the power of @x. This function is Excel compatible. 
@EXAMPLES=
EXP(2) equals 7.389056.

291 292 293 294
@SEEALSO=LOG, LOG2, LOG10

@FUNCTION=ASIN
@SYNTAX=ASIN(x)
Jody Goldberg's avatar
Jody Goldberg committed
295 296 297 298 299
@DESCRIPTION=ASIN function calculates the arc sine of @x; that is the value whose sine is @x. If @x falls outside  the  range -1 to 1, ASIN fails and returns the NUM! error. This function is Excel compatible. 
@EXAMPLES=
ASIN(0.5) equals 0.523599.
ASIN(1) equals 1.570797.

300 301
@SEEALSO=SIN, COS, ASINH, DEGREES, RADIANS

Jody Goldberg's avatar
Jody Goldberg committed
302 303
@FUNCTION=PERCENTILE
@SYNTAX=PERCENTILE(array,k)
Jody Goldberg's avatar
Jody Goldberg committed
304
@DESCRIPTION=PERCENTILE function returns the 100*@k-th percentile of the given data points (that is, a number x such that a fraction @k of the data points are less than x).  
Jody Goldberg's avatar
Jody Goldberg committed
305 306 307 308 309 310 311
If @array is empty, PERCENTILE returns #NUM! error. If @k < 0 or @k > 1, PERCENTILE returns #NUM! error. This function is Excel compatible.
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then
PERCENTILE(A1:A5,0.42) equals 20.02.

@SEEALSO=QUARTILE

312
@FUNCTION=TRIMMEAN
Jody Goldberg's avatar
Jody Goldberg committed
313 314
@SYNTAX=TRIMMEAN(ref,fraction)
@DESCRIPTION=TRIMMEAN returns the mean of the interior of a data set. @ref is the list of numbers whose mean you want to calculate and @fraction is the fraction of the data set excluded from the mean. For example, if @fraction=0.2 and the data set contains 40 numbers, 8 numbers are trimmed from the data set (40 x 0.2), 4 from the top and 4 from the bottom of the set. This function is Excel compatible. 
Jody Goldberg's avatar
Jody Goldberg committed
315 316
@EXAMPLES=

317 318
@SEEALSO=AVERAGE,GEOMEAN,HARMEAN,MEDIAN,MODE

Jody Goldberg's avatar
Jody Goldberg committed
319 320 321 322 323 324 325 326
@FUNCTION=TRUE
@SYNTAX=TRUE()
@DESCRIPTION=TRUE returns boolean value true.  This function is Excel compatible. 
@EXAMPLES=
TRUE() equals TRUE.

@SEEALSO=FALSE

327 328
@FUNCTION=FLOOR
@SYNTAX=FLOOR(x,significance)
Jody Goldberg's avatar
Jody Goldberg committed
329 330 331 332
@DESCRIPTION=FLOOR function rounds @x down to the next nearest multiple of @significance.  @significance defaults to 1. This function is Excel compatible. 
@EXAMPLES=
FLOOR(0.5) equals 0.
FLOOR(5,2) equals 4.
Jody Goldberg's avatar
Jody Goldberg committed
333 334
FLOOR(-5,-2) equals -4.
FLOOR(-5,2) equals #NUM!.
Jody Goldberg's avatar
Jody Goldberg committed
335

336 337 338 339 340
@SEEALSO=CEIL, ABS, INT

@FUNCTION=GCD
@SYNTAX=GCD(number1,number2,...)
@DESCRIPTION=GCD returns the greatest common divisor of given numbers. 
Jody Goldberg's avatar
Jody Goldberg committed
341 342 343 344 345
If any of the arguments is less than zero, GCD returns #NUM! error. If any of the arguments is non-integer, it is truncated. This function is Excel compatible. 
@EXAMPLES=
GCD(470,770) equals to 10.
GCD(470,770,1495) equals to 5.

346
@SEEALSO=LCM
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
347

Jody Goldberg's avatar
Jody Goldberg committed
348 349 350 351 352 353 354
@FUNCTION=ODDLPRICE
@SYNTAX=ODDLPRICE(settlement,maturity,last_interest,rate,yld,redemption,frequency,basis)
@DESCRIPTION=
@EXAMPLES=

@SEEALSO=

Arturo Espinosa's avatar
Arturo Espinosa committed
355 356
@FUNCTION=CHOOSE
@SYNTAX=CHOOSE(index[,value1][,value2]...)
357 358
@DESCRIPTION=CHOOSE returns the value of index @index. @index is rounded to an integer if it is not.
If @index < 1 or @index > number of values: returns #VAL!.
Jody Goldberg's avatar
Jody Goldberg committed
359 360
@EXAMPLES=

Arturo Espinosa's avatar
Arturo Espinosa committed
361
@SEEALSO=IF
Arturo Espinosa's avatar
Arturo Espinosa committed
362

363 364
@FUNCTION=POISSON
@SYNTAX=POISSON(x,mean,cumulative)
Jody Goldberg's avatar
Jody Goldberg committed
365
@DESCRIPTION=POISSON function returns the Poisson distribution. @x is the number of events, @mean is the expected numeric value @cumulative describes whether to return the sum of the poisson function from 0 to @x.
Jody Goldberg's avatar
Jody Goldberg committed
366 367 368 369
If @x is a non-integer it is truncated. If @x <= 0 POISSON returns #NUM! error. If @mean <= 0 POISSON returns the #NUM! error. This function is Excel compatible. 
@EXAMPLES=
POISSON(3,6,0) equals 0.089235078.

370
@SEEALSO=NORMDIST, WEIBULL
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
371

372
@FUNCTION=SYD
373
@SYNTAX=SYD(cost,salvage_value,life,period)
Jody Goldberg's avatar
Jody Goldberg committed
374 375
@DESCRIPTION=The SYD function calculates the sum-of-years digits depriciation for an asset based on its cost, salvage value, anticipated life and a particular period. This method accelerates the rate of the depreciation, so that more depreciation expense occurs in earlier periods than in later ones. The depreciable cost is the actual cost minus the salvage value. The useful life is the number of periods (typically years) over with the asset is depreciated.
The Formula used for sum-of-years digits depriciation is:
Jody Goldberg's avatar
Jody Goldberg committed
376
Depriciation expense = ( @cost - @salvage_value ) * (@life - @period + 1) * 2 / @life * (@life + 1).
Jody Goldberg's avatar
Jody Goldberg committed
377 378 379 380
	@cost = cost of an asset when acquired (market value).	@salvage_value = amount you get when asset sold at the end of its useful life.	@life = anticipated life of an asset.	@period = period for which we need the expense.
@EXAMPLES=
For example say a company purchases a new computer for $5000 which has a salvage value of $200, and a useful life of three years. We would use the following to calculate the second year's depreciation using the SYD method:
=SYD(5000, 200, 5, 2) which returns 1,280.00.
381
@SEEALSO=SLN
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
382

383 384
@FUNCTION=MID
@SYNTAX=MID(string, position, length)
Jody Goldberg's avatar
Jody Goldberg committed
385 386 387 388
@DESCRIPTION=MID returns a substring from @string starting at @position for @length characters.
@EXAMPLES=
MID("testing",2,3) equals "est".

389
@SEEALSO=LEFT, RIGHT
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
390

391 392
@FUNCTION=ASINH
@SYNTAX=ASINH(x)
Jody Goldberg's avatar
Jody Goldberg committed
393 394
@DESCRIPTION=ASINH function calculates the inverse hyperbolic sine of @x; that is the value whose hyperbolic sine is @x. This function is Excel compatible. 
@EXAMPLES=
Jody Goldberg's avatar
update  
Jody Goldberg committed
395 396 397
ASINH(0.5) equals 0.481212.
ASINH(1.0) equals 0.881374.

398
@SEEALSO=ASIN, ACOSH, SIN, COS, DEGREES, RADIANS
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
399

400 401
@FUNCTION=EXPONDIST
@SYNTAX=EXPONDIST(x,y,cumulative)
Jody Goldberg's avatar
Jody Goldberg committed
402 403 404 405 406
@DESCRIPTION=EXPONDIST function returns the exponential distribution. If the @cumulative boolean is false it will return: @y * exp (-@y*@x), otherwise it will return 1 - exp (-@y*@x).
If @x < 0 or @y <= 0 this will return an error.  This function is Excel compatible. 
@EXAMPLES=
EXPONDIST(2,4,0) equals 0.001341851.

407
@SEEALSO=POISSON
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
408

Jody Goldberg's avatar
update  
Jody Goldberg committed
409 410 411 412 413 414 415
@FUNCTION=COUPDAYBS
@SYNTAX=COUPDAYBS(settlement,maturity,frequency[,basis])
@DESCRIPTION=Returns the number of days from the beginning of the coupon period to the settlement date.
@EXAMPLES=

@SEEALSO=

416 417
@FUNCTION=UPPER
@SYNTAX=UPPER(text)
Jody Goldberg's avatar
Jody Goldberg committed
418 419 420 421
@DESCRIPTION=UPPER returns a upper-case version of the string in @text.
@EXAMPLES=
UPPER("canceled") equals "CANCELED".

422
@SEEALSO=LOWER
Arturo Espinosa's avatar
Arturo Espinosa committed
423

424 425
@FUNCTION=HARMEAN
@SYNTAX=HARMEAN(b1, b2, ...)
Jody Goldberg's avatar
Jody Goldberg committed
426
@DESCRIPTION=HARMEAN returns the harmonic mean of the N data points (that is, N divided by the sum of the inverses of the data points). This function is Excel compatible. 
Jody Goldberg's avatar
Jody Goldberg committed
427 428 429 430 431
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then
HARMEAN(A1:A5) equals 19.529814427.

@SEEALSO=AVERAGE,GEOMEAN,MEDIAN,MODE,TRIMMEAN
Arturo Espinosa's avatar
Arturo Espinosa committed
432

433 434 435
@FUNCTION=TBILLYIELD
@SYNTAX=TBILLYIELD(settlement,maturity,pr)
@DESCRIPTION=TBILLYIELD function returns the yield for a treasury bill. @settlement is the settlement date and @maturity is the maturity date of the bill.  @discount is the treasury bill's discount rate. 
Jody Goldberg's avatar
Jody Goldberg committed
436
If @settlement is after @maturity or the @maturity is set to over one year later than the @settlement, TBILLYIELD returns #NUM! error. If @pr is negative, TBILLYIELD returns #NUM! error. 
Jody Goldberg's avatar
Jody Goldberg committed
437 438
@EXAMPLES=

439 440
@SEEALSO=TBILLEQ,TBILLPRICE

Jody Goldberg's avatar
Jody Goldberg committed
441 442 443 444 445 446 447
@FUNCTION=ODDFYIELD
@SYNTAX=ODDFYIELD(settlement,maturity,issue,first_coupon,rate,pr,redemption,frequency,basis)
@DESCRIPTION=
@EXAMPLES=

@SEEALSO=

Arturo Espinosa's avatar
Arturo Espinosa committed
448 449
@FUNCTION=CONVERT
@SYNTAX=CONVERT(number,from_unit,to_unit)
450
@DESCRIPTION=CONVERT returns a conversion from one measurement system to another.  For example, you can convert a weight in pounds to a weight in grams.  @number is the value you want to convert, @from_unit specifies the unit of the @number, and @to_unit is the unit for the result.
Arturo Espinosa's avatar
Arturo Espinosa committed
451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537
@from_unit and @to_unit can be any of the following:

Weight and mass:
'g'    Gram
'sg'   Slug
'lbm'  Pound
'u'    U (atomic mass)
'ozm'  Ounce

Distance:
'm'    Meter
'mi'   Statute mile
'Nmi'  Nautical mile
'in'   Inch
'ft'   Foot
'yd'   Yard
'ang'  Angstrom
'Pica' Pica

Time:
'yr'   Year
'day'  Day
'hr'   Hour
'mn'   Minute
'sec'  Second

Pressure:
'Pa'   Pascal
'atm'  Atmosphere
'mmHg' mm of Mercury

Force:
'N'    Newton
'dyn'  Dyne
'lbf'  Pound force

Energy:
'J'    Joule
'e'    Erg
'c'    Thermodynamic calorie
'cal'  IT calorie
'eV'   Electron volt
'HPh'  Horsepower-hour
'Wh'   Watt-hour
'flb'  Foot-pound
'BTU'  BTU

Power:
'HP'   Horsepower
'W'    Watt
Magnetism:
'T'    Tesla
'ga'   Gauss

Temperature:
'C'    Degree Celsius
'F'    Degree Fahrenheit
'K'    Degree Kelvin

Liquid measure:
'tsp'  Teaspoon
'tbs'  Tablespoon
'oz'   Fluid ounce
'cup'  Cup
'pt'   Pint
'qt'   Quart
'gal'  Gallon
'l'    Liter

For metric units any of the following prefixes can be used:
'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'  dekao  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

Jody Goldberg's avatar
Jody Goldberg committed
538 539 540 541 542 543
If @from_unit and @to_unit are different types, CONVERT returns #NUM! error. This function is Excel compatible. 
@EXAMPLES=
CONVERT(3,"lbm","g") equals 1360.7769.
CONVERT(5.8,"m","in") equals 228.3465.
CONVERT(7.9,"cal","J") equals 33.07567.

544
@SEEALSO=
Arturo Espinosa's avatar
Arturo Espinosa committed
545

546 547
@FUNCTION=LOG
@SYNTAX=LOG(x[,base])
Jody Goldberg's avatar
Jody Goldberg committed
548 549 550 551 552
@DESCRIPTION=LOG computes the logarithm of @x in the given base @base.  If no @base is given LOG returns the logarithm in base 10. This function is Excel compatible. 
@EXAMPLES=
LOG(2) equals 0.30103.
LOG(8192,2) equals 13.

553
@SEEALSO=LN, LOG2, LOG10
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
554

555 556
@FUNCTION=HYPGEOMDIST
@SYNTAX=HYPGEOMDIST(x,n,M,N)
Jody Goldberg's avatar
Jody Goldberg committed
557
@DESCRIPTION=HYPGEOMDIST function returns the hypergeometric distribution. @x is the number of successes in the sample, @n is the number of trials, @M is the number of successes overall, and @N is thepopulation size.
Jody Goldberg's avatar
Jody Goldberg committed
558 559 560 561
If @x,@n,@M or @N is a non-integer it is truncated. If @x,@n,@M or @N < 0 HYPGEOMDIST returns #NUM! error. If @x > @M or @n > @N HYPGEOMDIST returns #NUM! error. This function is Excel compatible. 
@EXAMPLES=
HYPGEOMDIST(1,2,3,10) equals 0.4666667.

562
@SEEALSO=BINOMDIST,POISSON
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
563

564 565
@FUNCTION=IMABS
@SYNTAX=IMABS(inumber)
Jody Goldberg's avatar
Jody Goldberg committed
566 567 568 569
@DESCRIPTION=IMABS returns the absolute value of a complex number. This function is Excel compatible. 
@EXAMPLES=
IMABS("2-j") equals 2.23606798.

570
@SEEALSO=IMAGINARY,IMREAL
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
571

572 573
@FUNCTION=SINH
@SYNTAX=SINH(x)
Jody Goldberg's avatar
Jody Goldberg committed
574 575 576 577
@DESCRIPTION=SINH function returns the hyperbolic sine of @x, which is defined mathematically as (exp(@x) - exp(-@x)) / 2. This function is Excel compatible. 
@EXAMPLES=
SINH(0.5) equals 0.521095.

578 579
@SEEALSO=SIN, COS, COSH, TAN, TANH, DEGREES, RADIANS, EXP

580 581
@FUNCTION=AVEDEV
@SYNTAX=AVEDEV(n1, n2, ...)
Jody Goldberg's avatar
Jody Goldberg committed
582 583 584 585 586
@DESCRIPTION=AVEDEV returns the average of the absolute deviations of a data set from their mean. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then
AVEDEV(A1:A5) equals 7.84.

587
@SEEALSO=STDEV
Arturo Espinosa's avatar
Arturo Espinosa committed
588

589 590
@FUNCTION=NORMDIST
@SYNTAX=NORMDIST(x,mean,stdev,cumulative)
Jody Goldberg's avatar
Jody Goldberg committed
591 592 593 594 595
@DESCRIPTION=NORMDIST function returns the normal cumulative distribution. @x is the value for which you want the distribution, @mean is the mean of the distribution, @stdev is the standard deviation. 
If @stdev is 0 NORMDIST returns #DIV/0! error. This function is Excel compatible. 
@EXAMPLES=
NORMDIST(2,1,2,0) equals 0.176032663.

596
@SEEALSO=POISSON
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
597

598 599
@FUNCTION=GEOMEAN
@SYNTAX=GEOMEAN(b1, b2, ...)
Jody Goldberg's avatar
Jody Goldberg committed
600 601 602 603 604 605
@DESCRIPTION=GEOMEAN returns the geometric mean of the given arguments. This is equal to the Nth root of the product of the terms. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then
GEOMEAN(A1:A5) equals 21.279182482.

@SEEALSO=AVERAGE,HARMEAN,MEDIAN,MODE,TRIMMEAN
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
606

607 608 609
@FUNCTION=TIME
@SYNTAX=TIME (hours,minutes,seconds)
@DESCRIPTION=Returns a fraction representing the time of day.
Jody Goldberg's avatar
Jody Goldberg committed
610 611
@EXAMPLES=

612
@SEEALSO=HOUR
Arturo Espinosa's avatar
Arturo Espinosa committed
613

614 615
@FUNCTION=MIN
@SYNTAX=MIN(b1, b2, ...)
Jody Goldberg's avatar
Jody Goldberg committed
616 617 618 619 620
@DESCRIPTION=MIN returns the value of the element of the values passed that has the smallest value. With negative numbers considered smaller than positive numbers. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then
MIN(A1:A5) equals 11.4.

621 622 623 624 625
@SEEALSO=MAX,ABS

@FUNCTION=MEDIAN
@SYNTAX=MEDIAN(n1, n2, ...)
@DESCRIPTION=MEDIAN returns the median of the given data set.
Jody Goldberg's avatar
Jody Goldberg committed
626 627 628 629 630
Strings and empty cells are simply ignored. If even numbers are given MEDIAN returns the average of the two numbers in the middle. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then
MEDIAN(A1:A5) equals 21.3.

631 632
@SEEALSO=AVERAGE,COUNT,COUNTA,DAVERAGE,MODE,SUM

633 634 635
@FUNCTION=FREQUENCY
@SYNTAX=FREQUENCY(data_array,bins_array)
@DESCRIPTION=FREQUENCY function counts how often given values occur within a range of values.  The results are given as an array. 
Jody Goldberg's avatar
Jody Goldberg committed
636 637 638
@data_array is a data array for which you want to count the frequencies.  @bin_array is an array containing the intervals into which you want to group the values in data_array.  If the @bin_array is empty, FREQUENCY returns the number of data points in @data_array. This function is Excel compatible. 
@EXAMPLES=

639 640
@SEEALSO=

641 642
@FUNCTION=GAMMAINV
@SYNTAX=GAMMAINV(p,alpha,beta)
Jody Goldberg's avatar
Jody Goldberg committed
643 644 645 646 647
@DESCRIPTION=GAMMAINV function returns the inverse of the cumulative gamma distribution.
If @p < 0 or @p > 1 GAMMAINV returns #NUM! error. If @alpha <= 0 or @beta <= 0 GAMMAINV returns #NUM! error. This function is Excel compatible. 
@EXAMPLES=
GAMMAINV(0.34,2,4) equals 4.829093908.

648 649 650 651
@SEEALSO=GAMMADIST

@FUNCTION=IMSUB
@SYNTAX=IMSUB(inumber,inumber)
Jody Goldberg's avatar
Jody Goldberg committed
652 653 654 655
@DESCRIPTION=IMSUB returns the difference of two complex numbers. This function is Excel compatible. 
@EXAMPLES=
IMSUB("3-j","2+j") equals 1-2j.

656 657 658
@SEEALSO=IMSUM

@FUNCTION=ISTEXT
Jody Goldberg's avatar
Jody Goldberg committed
659
@SYNTAX=ISTEXT(value)
Jody Goldberg's avatar
Jody Goldberg committed
660 661 662
@DESCRIPTION=ISTEXT returns TRUE if the value is text. This function is Excel compatible. 
@EXAMPLES=

663
@SEEALSO=ISNONTEXT
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
664

665 666
@FUNCTION=SQRT
@SYNTAX=SQRT(x)
Jody Goldberg's avatar
Jody Goldberg committed
667 668 669 670 671
@DESCRIPTION=SQRT function returns the square root of @x. This function is Excel compatible. 
If @x is negative, SQRT returns #NUM! error. 
@EXAMPLES=
SQRT(2) equals 1.4142136.

672
@SEEALSO=POWER
673

Jody Goldberg's avatar
update  
Jody Goldberg committed
674 675 676 677 678 679 680
@FUNCTION=COUPDAYSNC
@SYNTAX=COUPDAYSNC(settlement,maturity,frequency[,basis])
@DESCRIPTION=Returns the number of days from the settlement date to the next coupon date.
@EXAMPLES=

@SEEALSO=

681 682 683
@FUNCTION=INTERCEPT
@SYNTAX=INTERCEPT(known_y's,known_x's)
@DESCRIPTION=INTERCEPT function calculates the point where the linear regression line intersects the y-axis.  
Jody Goldberg's avatar
Jody Goldberg committed
684 685 686 687 688
If @known_x or @known_y contains no data entries or different number of data entries, INTERCEPT returns #N/A! error. If the variance of the @known_x is zero, INTERCEPT returns #DIV/0 error. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7.  Then
INTERCEPT(A1:A5,B1:B5) equals -20.785117212.

689 690 691 692
@SEEALSO=FORECAST,TREND

@FUNCTION=LEN
@SYNTAX=LEN(string)
Jody Goldberg's avatar
Jody Goldberg committed
693 694 695 696
@DESCRIPTION=LEN returns the length in characters of the string @string.
@EXAMPLES=
len("Helsinki") equals 8.

697 698 699 700
@SEEALSO=CHAR, CODE

@FUNCTION=RIGHT
@SYNTAX=RIGHT(text[,num_chars])
Jody Goldberg's avatar
Jody Goldberg committed
701 702 703 704 705
@DESCRIPTION=RIGHT returns the rightmost @num_chars characters or the right character if @num_chars is not specified.
@EXAMPLES=
RIGHT("end") equals "d".
RIGHT("end",2) equals "nd".

706
@SEEALSO=MID, LEFT
707

Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
708 709
@FUNCTION=PERMUT
@SYNTAX=PERMUT(n,k)
Jody Goldberg's avatar
Jody Goldberg committed
710 711 712 713 714
@DESCRIPTION=PERMUT function returns the number of permutations. @n is the number of objects, @k is the number of objects in each permutation.
If @n = 0 PERMUT returns #NUM! error. If @n < @k PERMUT returns #NUM! error. This function is Excel compatible. 
@EXAMPLES=
PERMUT(7,3) equals 210.

Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
715 716
@SEEALSO=COMBIN

Jody Goldberg's avatar
Jody Goldberg committed
717 718 719 720 721 722 723
@FUNCTION=ODDFPRICE
@SYNTAX=ODDFPRICE(settlement,maturity,issue,first_coupon,rate,yld,redemption,frequency,basis)
@DESCRIPTION=
@EXAMPLES=

@SEEALSO=

724 725
@FUNCTION=AVERAGEA
@SYNTAX=AVERAGEA(number1,number2,...)
Jody Goldberg's avatar
Jody Goldberg committed
726 727 728 729 730
@DESCRIPTION=AVERAGEA returns the average of the given arguments.  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. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1.  Then
AVERAGEA(A1:A5) equals 18.94.

731
@SEEALSO=AVERAGE
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
732

733 734 735 736
@FUNCTION=PERCENTRANK
@SYNTAX=PERCENTRANK(array,x[,significance])
@DESCRIPTION=PERCENTRANK function returns the rank of a data point in a data set.  @array is the range of numeric values, @x is the data point which you want to rank, and the optional @significance indentifies the number of significant digits for the returned value.  If @significance is omitted, PERCENTRANK uses three digits.
If @array contains not data points, PERCENTRANK returns #NUM! error. If @significance is less than one, PERCENTRANK returns #NUM! error. If @x does not match any of the values in @array or @x matches more than once, PERCENTRANK interpolates the returned value.
Jody Goldberg's avatar
Jody Goldberg committed
737 738
@EXAMPLES=

739
@SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,QUARTILE,SMALL
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
740

Jody Goldberg's avatar
Jody Goldberg committed
741 742 743 744
@FUNCTION=RANDNEGBINOM
@SYNTAX=RANDNEGBINOM(p,failures)
@DESCRIPTION=RANDNEGBINOM returns a negitive binomialy distributed random number. 
If @p < 0 or @p > 1, RANDNEGBINOM returns #NUM! error. If @failures RANDNEGBINOM returns #NUM! error. 
Jody Goldberg's avatar
Jody Goldberg committed
745
@EXAMPLES=
Jody Goldberg's avatar
Jody Goldberg committed
746
RANDNEGBINOM(0.5,2).
Jody Goldberg's avatar
Jody Goldberg committed
747 748 749

@SEEALSO=RAND,RANDBETWEEN

Jody Goldberg's avatar
update  
Jody Goldberg committed
750 751 752 753 754 755 756
@FUNCTION=COUPDAYS
@SYNTAX=COUPDAYS(settlement,maturity,frequency[,basis])
@DESCRIPTION=Returns the number of days in the coupon period of the settlement date.
@EXAMPLES=

@SEEALSO=

757 758 759
@FUNCTION=DATE
@SYNTAX=DATE (year,month,day)
@DESCRIPTION=Computes the number of days since the 1st of january of 1900(the date serial number) for the given year, month and day.
760
The @day might be negative (to count backwards) and it is relative to the previous @month.  The @years should be at least 1900.
Jody Goldberg's avatar
Jody Goldberg committed
761 762
@EXAMPLES=

763
@SEEALSO=TODAY, NOW
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
764

765 766 767
@FUNCTION=STEYX
@SYNTAX=STEYX(known_y's,known_x's)
@DESCRIPTION=STEYX function returns the standard error of the predicted y-value for each x in the regression.
Jody Goldberg's avatar
Jody Goldberg committed
768 769 770 771 772
If @known_y's and @known_x's are empty or have a different number of arguments then STEYX returns #N/A! error. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7.  Then
STEYX(A1:A5,B1:B5) equals 1.101509979.

773
@SEEALSO=PEARSON,RSQ,SLOPE
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
774

775 776
@FUNCTION=OCT2BIN
@SYNTAX=OCT2BIN(number[,places])
Jody Goldberg's avatar
Jody Goldberg committed
777
@DESCRIPTION=The OCT2BIN function converts an octal number to a binary number.  @places is an optional field, specifying to zero pad to that number of spaces. This function is Excel compatible. 
778
If @places is too small or negative #NUM! error is returned.
Jody Goldberg's avatar
Jody Goldberg committed
779 780 781
@EXAMPLES=
OCT2BIN("213") equals 10001011.

782
@SEEALSO=BIN2OCT, OCT2DEC, OCT2HEX
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
783

784
@FUNCTION=PRICEMAT
785 786
@SYNTAX=PRICEMAT(settlement,maturity,issue,rate,yield[,basis])
@DESCRIPTION=PRICEMAT calculates and returns the price per $100 face value of a security.  The security pays interest at maturity. @basis is the type of day counting system you want to use:
787 788 789 790 791 792 793

0  US 30/360
1  actual days/actual days
2  actual days/360
3  actual days/365
4  European 30/360

Jody Goldberg's avatar
Jody Goldberg committed
794
If @basis is omitted, US 30/360 is applied. If @settlement date or @maturity date is not valid, PRICEMAT returns #NUM! error. If @basis < 0 or @basis > 4, PRICEMAT returns #NUM! error. If @settlement date is after @maturity date or they are the same, PRICEMAT returns #NUM! error. 
795 796
@EXAMPLES=

797 798
@SEEALSO=PRICEDISC

Arturo Espinosa's avatar
Arturo Espinosa committed
799 800
@FUNCTION=IMCONJUGATE
@SYNTAX=IMCONJUGATE(inumber)
Jody Goldberg's avatar
Jody Goldberg committed
801 802 803 804
@DESCRIPTION=IMCONJUGATE returns the complex conjugate of a complex number. This function is Excel compatible. 
@EXAMPLES=
IMCONJUGATE("1-j") equals 1+j.

Arturo Espinosa's avatar
Arturo Espinosa committed
805 806
@SEEALSO=IMAGINARY,IMREAL

807 808
@FUNCTION=SUMIF
@SYNTAX=SUMIF(range,criteria[,actual_range])
Jody Goldberg's avatar
Jody Goldberg committed
809 810 811 812 813 814 815 816
@DESCRIPTION=SUMIF function sums the values in the given @range that meet the given @criteria.  If @actual_range is given, SUMIF sums the values in the @actual_range whose corresponding components in @range meet the given @criteria. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 23, 27, 28, 33, and 39.  Then
SUMIF(A1:A5,"<=28") equals 78.
SUMIF(A1:A5,"<28") equals 50.
In addition, if the cells B1, B2, ..., B5 hold numbers 5, 3, 2, 6, and 7 then:
SUMIF(A1:A5,"<=27",B1:B5) equals 8.

817 818 819
@SEEALSO=COUNTIF, SUM

@FUNCTION=LINEST
Jody Goldberg's avatar
Jody Goldberg committed
820 821 822 823 824 825 826 827 828
@SYNTAX=LINEST(known_y's[,known_x's[,const[,stat]]])
@DESCRIPTION=LINEST function calculates the ``least squares'' line that best fit to your data in @known_y's.  @known_x's contains the corresponding x's where y=mx+b.
If @known_x's is omitted, an array {1, 2, 3, ...} is used. LINEST returns an array having two columns and one row.  The slope (m) of the regression line y=mx+b is given in the first column and the y-intercept (b) in the second.
If @known_y's and @known_x's have unequal number of data points, LINEST returns #NUM! error.
If @const is FALSE, the line will be forced to go through the origin, i.e., b will be zero. The default is TRUE.
If @stat is TRUE, extra statistical information will be returned. Extra statistical information is written bellow 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. 
The default of @stat is FALSE.
@EXAMPLES=

829
@SEEALSO=LOGEST,TREND
Arturo Espinosa's avatar
Arturo Espinosa committed
830

831
@FUNCTION=IMREAL
Arturo Espinosa's avatar
Arturo Espinosa committed
832
@SYNTAX=IMREAL(inumber)
Jody Goldberg's avatar
Jody Goldberg committed
833 834 835 836
@DESCRIPTION=IMREAL returns the real coefficient of a complex number. This function is Excel compatible. 
@EXAMPLES=
imreal("132-j") equals 132.

Arturo Espinosa's avatar
Arturo Espinosa committed
837 838
@SEEALSO=IMAGINARY

839 840
@FUNCTION=IMSUM
@SYNTAX=IMSUM(inumber,inumber)
Jody Goldberg's avatar
Jody Goldberg committed
841 842 843 844
@DESCRIPTION=IMSUM returns the sum of two complex numbers. This function is Excel compatible. 
@EXAMPLES=
IMSUM("2-4j","9-j") equals 11-5j.

845
@SEEALSO=IMSUB
Arturo Espinosa's avatar
Arturo Espinosa committed
846

847 848
@FUNCTION=SERIESSUM
@SYNTAX=SERIESSUM(x,n,m,coefficients)
Jody Goldberg's avatar
Jody Goldberg committed
849 850 851 852 853
@DESCRIPTION=SERIESSUM function returns the sum of a power series.  @x is the base of the power serie, @n is the initial power to raise @x, @m is the increment to the power for each term in the series, and @coefficients is the coefficents by which each successive power of @x is multiplied. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 1.23, 2.32, 2.98, 3.42, and 4.33.  Then
SERIESSUM(3,1,2.23,A1:A5) equals 251416.43018.

854
@SEEALSO=COUNT,SUM
Arturo Espinosa's avatar
Arturo Espinosa committed
855

Jody Goldberg's avatar
Jody Goldberg committed
856 857 858 859 860 861
@FUNCTION=XIRR
@SYNTAX=XIRR(values,dates[,guess])
@DESCRIPTION=XIRR calculates and returns the internal rate of return of an investment that has not necessarily periodic payments.  This function is closely related to the net present value function (NPV and XNPV).  The XIRR is the interest rate for a serie of cash flow where the XNPV is zero. 
@values contains the serie of cash flow generated by the investment.  @dates contains the dates of the payments.  The first date describes the payment day of the initial payment and thus all the other dates should be after this date. The optional @guess is the initial value used in calculating the XIRR.  You do not have to use that, it is only provided for the Excel compatibility. 
This function is Excel compatible. 
@EXAMPLES=
Jody Goldberg's avatar
Jody Goldberg committed
862 863
Let us assume that the cells A1:A5 contain the numbers -6000, 2134, 1422, 1933, and 1422, and the cells B1:B5 contain the dates "1999-01-15", "1999-04-04", "1999-05-09", "2000-03-12", and "2000-05-1". Then
XIRR(A1:A5,B1:B5) returns 0.224838. 
Jody Goldberg's avatar
Jody Goldberg committed
864 865
@SEEALSO=IRR,XNPV

866 867
@FUNCTION=LEFT
@SYNTAX=LEFT(text[,num_chars])
Jody Goldberg's avatar
Jody Goldberg committed
868 869 870 871
@DESCRIPTION=LEFT returns the leftmost @num_chars characters or the left character if @num_chars is not specified.
@EXAMPLES=
LEFT("Directory",3) equals "Dir".

872
@SEEALSO=MID, RIGHT
Arturo Espinosa's avatar
Arturo Espinosa committed
873

874 875
@FUNCTION=DURATION
@SYNTAX=DURATION(rate,pv,fv)
Jody Goldberg's avatar
Jody Goldberg committed
876 877 878
@DESCRIPTION=DURATION calculates number of periods needed for an investment to attain a desired value. This function is similar to FV and PV with a difference that we do not need give the direction of cash flows e.g. -100 for a cash outflow and +100 for a cash inflow.
@EXAMPLES=

879
@SEEALSO=PPMT,PV,FV
880

881 882 883
@FUNCTION=COMPLEX
@SYNTAX=COMPLEX(real,im[,suffix])
@DESCRIPTION=COMPLEX returns a complex number of the form x + yi. @real is the real and @im is the imaginary coefficient of the complex number.  @suffix is the suffix for the imaginary coefficient.  If it is omitted, COMPLEX uses 'i' by default.
Jody Goldberg's avatar
Jody Goldberg committed
884 885 886 887 888
If @suffix is neither 'i' nor 'j', COMPLEX returns #VALUE! error. This function is Excel compatible. 
@EXAMPLES=
COMPLEX(1,-1) equals 1-i.

@SEEALSO=
889

890 891
@FUNCTION=DEC2HEX
@SYNTAX=DEC2HEX(number[,places])
Jody Goldberg's avatar
Jody Goldberg committed
892 893 894 895 896
@DESCRIPTION=DEC2HEX function converts a decimal number to a hexadecimal number. @places is an optional field, specifying to zero pad to that number of spaces.
If @places is too small or negative #NUM! error is returned. This function is Excel compatible. 
@EXAMPLES=
DEC2HEX(42) equals 2A.

897
@SEEALSO=HEX2DEC, DEC2BIN, DEC2OCT
Arturo Espinosa's avatar
Arturo Espinosa committed
898

899 900 901
@FUNCTION=COLUMNS
@SYNTAX=COLUMNS(reference)
@DESCRIPTION=The COLUMNS function returns the number of columns in area or array reference.
902
If @reference is neither an array nor a reference nor a range returns #VALUE!.
Jody Goldberg's avatar
Jody Goldberg committed
903 904
@EXAMPLES=

905 906 907 908
@SEEALSO=COLUMN,ROW,ROWS

@FUNCTION=LN
@SYNTAX=LN(x)
Jody Goldberg's avatar
Jody Goldberg committed
909 910 911 912
@DESCRIPTION=LN returns the natural logarithm of @x. If @x <= 0, LN returns #NUM! error. This function is Excel compatible. 
@EXAMPLES=
LN(7) equals 1.94591.

913 914 915 916 917 918
@SEEALSO=EXP, LOG2, LOG10

@FUNCTION=DGET
@SYNTAX=DGET(database,field,criteria)
@DESCRIPTION=DGET function returns a single value from a column that match conditions specified. 
@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. 
Jody Goldberg's avatar
Jody Goldberg committed
919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938
@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. 
@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, ``>3'' or ``<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). 
@EXAMPLES=
Let us assume that the range A1:C7 contain the following values:
Name    Age     Salary
John    34      54342
Bill    35      22343
Clark   29      34323
Bob     43      47242
Susan   37      42932
Jill    45      45324

In addition, the cells A9:B11 contain the following values:
Age     Salary
<30
>40     >46000

DGET(A1:C7, "Salary", A9:A10) equals 34323.
DGET(A1:C7, "Name", A9:A10) equals "Clark".

939 940 941
If none of the items match the conditions, DGET returns #VALUE! error. If more than one items match the conditions, DGET returns #NUM! error. 
@SEEALSO=DCOUNT

Jody Goldberg's avatar
Jody Goldberg committed
942 943 944 945 946 947 948 949
@FUNCTION=FALSE
@SYNTAX=FALSE()
@DESCRIPTION=FALSE returns boolean value false.  This function is Excel compatible. 
@EXAMPLES=
FALSE() equals FALSE.

@SEEALSO=TRUE

950 951 952
@FUNCTION=DATEVALUE
@SYNTAX=DATEVALUE(date_str)
@DESCRIPTION=DATEVALUE returns the serial number of the date.  @date_str is the string that contains the date.  For example, DATEVALUE("1/1/1999") equals to 36160. 
Jody Goldberg's avatar
Jody Goldberg committed
953 954
@EXAMPLES=

955
@SEEALSO=DATE
Arturo Espinosa's avatar
Arturo Espinosa committed
956 957 958

@FUNCTION=COUNTBLANK
@SYNTAX=COUNTBLANK(range)
Jody Goldberg's avatar
Jody Goldberg committed
959 960 961
@DESCRIPTION=COUNTBLANK returns the number of blank cells in a @range. This function is Excel compatible. 
@EXAMPLES=

Arturo Espinosa's avatar
Arturo Espinosa committed
962 963
@SEEALSO=COUNT

964 965
@FUNCTION=AVERAGE
@SYNTAX=AVERAGE(value1, value2,...)
Jody Goldberg's avatar
Jody Goldberg committed
966 967 968 969 970
@DESCRIPTION=AVERAGE computes the average of all the values and cells referenced in the argument list.  This is equivalent to the sum of the arguments divided by the count of the arguments. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.  Then
AVERAGE(A1:A5) equals 23.2.

971
@SEEALSO=SUM, COUNT
972

Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
973 974
@FUNCTION=CORREL
@SYNTAX=CORREL(array1,array2)
Jody Goldberg's avatar
Jody Goldberg committed
975
@DESCRIPTION=CORREL returns the correlation coefficient of two data sets.
Jody Goldberg's avatar
Jody Goldberg committed
976 977 978 979 980
Strings and empty cells are simply ignored. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1, and the cells B1, B2, ... B5 23.2, 25.8, 29.9, 33.5, and 42.7.  Then
CORREL(A1:A5,B1:B5) equals 0.996124788.

Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
981 982
@SEEALSO=COVAR,FISHER,FISHERINV

Jody Goldberg's avatar
update  
Jody Goldberg committed
983 984 985 986 987 988 989
@FUNCTION=CUMIPMT
@SYNTAX=CUMIPMT(rate,nper,pv,start_period,end_period,type)
@DESCRIPTION=Returns the cumulative interest paid on a loan between @start_period and @end_period.
@EXAMPLES=

@SEEALSO=

990 991
@FUNCTION=SUMSQ
@SYNTAX=SUMSQ(value1, value2, ...)
Jody Goldberg's avatar
Jody Goldberg committed
992 993 994 995 996
@DESCRIPTION=SUMSQ returns the sum of the squares of all the values and cells referenced in the argument list. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11, 15, 17, 21, and 43.  Then
SUMSQ(A1:A5) equals 2925.

997
@SEEALSO=SUM, COUNT
Arturo Espinosa's avatar
Arturo Espinosa committed
998

999 1000
@FUNCTION=IMPRODUCT
@SYNTAX=IMPRODUCT(inumber1[,inumber2,...])
Jody Goldberg's avatar
Jody Goldberg committed
1001 1002 1003 1004
@DESCRIPTION=IMPRODUCT returns the product of given complex numbers. This function is Excel compatible. 
@EXAMPLES=
IMPRODUCT("2-j","4-2j") equals 6-8j.

1005
@SEEALSO=IMDIV
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
1006

1007 1008
@FUNCTION=CHAR
@SYNTAX=CHAR(x)
Jody Goldberg's avatar
Jody Goldberg committed
1009 1010 1011 1012
@DESCRIPTION=CHAR returns the ASCII character represented by the number @x.
@EXAMPLES=
CHAR(65) equals A.

1013
@SEEALSO=CODE
Arturo Espinosa's avatar
Arturo Espinosa committed
1014

1015
@FUNCTION=PMT
1016
@SYNTAX=PMT(rate,nper,pv[,fv,type])
Jody Goldberg's avatar
Jody Goldberg committed
1017
@DESCRIPTION=FIXME: Below is a PV function description!PMT calculates the present value of an investment.
Jody Goldberg's avatar
Jody Goldberg committed
1018 1019
@EXAMPLES=

1020
@SEEALSO=PPMT,PV,FV
1021

1022 1023
@FUNCTION=DAY
@SYNTAX=DAY (serial_number)
Jody Goldberg's avatar
Jody Goldberg committed
1024
@DESCRIPTION=Converts a serial number to a day of month.
1025
Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.
Jody Goldberg's avatar
Jody Goldberg committed
1026
@EXAMPLES=
Jody Goldberg's avatar
Jody Goldberg committed
1027
day ("10/24/1968") equals 24.
Jody Goldberg's avatar
Jody Goldberg committed
1028

1029
@SEEALSO=MONTH, TIME, NOW, YEAR
Arturo Espinosa's avatar
Arturo Espinosa committed
1030

Jody Goldberg's avatar
Jody Goldberg committed
1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042
@FUNCTION=GROWTH
@SYNTAX=GROWTH(known_y's[,known_x's,new_x's,const])
@DESCRIPTION=GROWTH function applies the ``least squares'' method to fit an exponential curve to your data and predicts the exponential growth by using this curve. 
If @known_x's is omitted, an array {1, 2, 3, ...} is used. If @new_x's is omitted, it is assumed to be the same as @known_x's. 
GROWTH returns an array having one column and a row for each data point in @new_x.
If @known_y's and @known_x's have unequal number of data points, GROWTH returns #NUM! error.
If @const is FALSE, the line will be forced to go through the origin, i.e., b will be zero. The default is TRUE.
@EXAMPLES=

@SEEALSO=LOGEST,GROWTH,TREND

@FUNCTION=INDEX
Jody Goldberg's avatar
Jody Goldberg committed
1043
@SYNTAX=INDEX(reference,[row, col, area])
Jody Goldberg's avatar
Jody Goldberg committed
1044 1045 1046 1047 1048 1049
@DESCRIPTION=The INDEX function returns a reference to the cell at a offset into the reference specified by row, col.
If things go wrong returns #REF! 
@EXAMPLES=

@SEEALSO=

Arturo Espinosa's avatar
Arturo Espinosa committed
1050 1051
@FUNCTION=SQRTPI
@SYNTAX=SQRTPI(number)
Jody Goldberg's avatar
Jody Goldberg committed
1052 1053 1054 1055
@DESCRIPTION=SQRTPI function returns the square root of a @number multiplied by pi. This function is Excel compatible. 
@EXAMPLES=
SQRTPI(2) equals 2.506628275.

Arturo Espinosa's avatar
Arturo Espinosa committed
1056
@SEEALSO=PI
1057

Arturo Espinosa's avatar
Arturo Espinosa committed
1058 1059
@FUNCTION=FISHER
@SYNTAX=FISHER(x)
Jody Goldberg's avatar
Jody Goldberg committed
1060 1061 1062 1063 1064
@DESCRIPTION=FISHER function returns the Fisher transformation at @x.
If @x is not-number FISHER returns #VALUE! error. If @x <= -1 or @x >= 1 FISHER returns #NUM! error. This function is Excel compatible. 
@EXAMPLES=
FISHER(0.332) equals 0.345074339.

Arturo Espinosa's avatar
Arturo Espinosa committed
1065 1066
@SEEALSO=SKEW

1067 1068
@FUNCTION=VARA
@SYNTAX=VARA(number1,number2,...)
Jody Goldberg's avatar
Jody Goldberg committed
1069 1070 1071 1072 1073
@DESCRIPTION=VARA returns the variance based on a sample.  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. This function is Excel compatible. 
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1.  Then
VARA(A1:A5) equals 228.613.

1074
@SEEALSO=VAR,VARPA
Arturo Espinosa's avatar
Arturo Espinosa committed
1075

1076 1077 1078 1079
@FUNCTION=DMAX
@SYNTAX=DMAX(database,field,criteria)
@DESCRIPTION=DMAX function returns the largest number in a column that match conditions specified. 
@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. 
Jody Goldberg's avatar
Jody Goldberg committed
1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100
@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. 
@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, ``>3'' or ``<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). 
@EXAMPLES=
Let us assume that the range A1:C7 contain the following values:
Name    Age     Salary
John    34      54342
Bill    35      22343
Clark   29      34323
Bob     43      47242
Susan   37      42932
Jill    45      45324

In addition, the cells A9:B11 contain the following values:
Age     Salary
<30
>40     >46000

DMAX(A1:C7, "Salary", A9:A11) equals 47242.
DMAX(A1:C7, "Age", A9:A11) equals 45.
DMAX(A1:C7, "Age", A9:B11) equals 43.

1101
@SEEALSO=DMIN
1102

1103
@FUNCTION=ISLOGICAL
Jody Goldberg's avatar
Jody Goldberg committed
1104
@SYNTAX=ISLOGICAL(value)
Jody Goldberg's avatar
Jody Goldberg committed
1105 1106 1107
@DESCRIPTION=ISLOGICAL returns TRUE if the value is a logical value. This function is Excel compatible. 
@EXAMPLES=

1108
@SEEALSO=
1109

1110 1111
@FUNCTION=ATAN2
@SYNTAX=ATAN2(b1,b2)
Jody Goldberg's avatar
Jody Goldberg committed
1112 1113
@DESCRIPTION=ATAN2 function calculates the arc tangent of the two variables @b1 and @b2.  It is similar to calculating the arc tangent of @b2 / @b1, except that the signs of both arguments are used to determine the quadrant of the result. The result is in radians. This function is Excel compatible. 
@EXAMPLES=
Jody Goldberg's avatar
update  
Jody Goldberg committed
1114 1115 1116
ATAN2(0.5,1.0) equals 1.107149.
ATAN2(-0.5,2.0) equals 1.815775.

1117 1118 1119 1120
@SEEALSO=ATAN, ATANH, COS, SIN, DEGREES, RADIANS

@FUNCTION=MINA
@SYNTAX=MINA(number1,number2,...)
Jody Goldberg's avatar
Jody Goldberg committed
1121
@DESCRIPTION=MINA returns the smallest value of the given arguments.  Numbers, text and logical values are included in the calculation, blank cells are not.  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. This function is Excel compatible. 
Jody Goldberg's avatar
Jody Goldberg committed
1122 1123 1124 1125
@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers and strings 11.4, 17.3, "missing", 25.9, and 40.1.  Then
MAXA(A1:A5) equals 40.1.

1126
@SEEALSO=MIN,MAXA
Arturo Espinosa's avatar
Arturo Espinosa committed
1127 1128 1129

@FUNCTION=LOOKUP
@SYNTAX=LOOKUP(value,vector1,vector2)
1130 1131 1132
@DESCRIPTION=The LOOKUP function finds the row index of 'value' in @vector1 and returns the contents of value2 at that row index. If the area is longer than it is wide then the sense of the search is rotated. Alternatively a single array can be used.
If LOOKUP can't find @value it uses the next largest value less than value. The data must be sorted. 
If @value is smaller than the first value it returns #N/A
Jody Goldberg's avatar
Jody Goldberg committed
1133 1134
@EXAMPLES=

Arturo Espinosa's avatar
Arturo Espinosa committed
1135 1136
@SEEALSO=VLOOKUP,HLOOKUP

1137 1138
@FUNCTION=CEIL
@SYNTAX=CEIL(x)
Jody Goldberg's avatar
Jody Goldberg committed
1139 1140 1141
@DESCRIPTION=CEIL function rounds @x up to the next nearest integer.
This function is Excel compatible. 
@EXAMPLES=
Jody Goldberg's avatar
update  
Jody Goldberg committed
1142 1143 1144 1145
CEIL(0.4) equals 1.
CEIL(-1.1) equals -1.
CEIL(-2.9) equals -2.

1146
@SEEALSO=ABS, FLOOR, INT
1147

1148
@FUNCTION=MDETERM
Jody Goldberg's avatar
update  
Jody Goldberg committed
1149
@SYNTAX=MDETERM(matrix)
1150
@DESCRIPTION=MDETERM function returns the determinant of a given matrix. 
Jody Goldberg's avatar
update  
Jody Goldberg committed
1151
If the @matrix does not contain equal number of columns and rows, MDETERM returns #VALUE! error. This function is Excel compatible. 
Jody Goldberg's avatar
Jody Goldberg committed
1152
@EXAMPLES=
Jody Goldberg's avatar
Jody Goldberg committed
1153
Let us assume that A1, ..., A4 contain numbers 2, 3, 7, and 3, B1, ..., B4 4, 2, 4, and 1, C1, ..., C4 9, 4, 3, and 2, and D1, ..., D4 7, 3, 6, and 5. Then
Jody Goldberg's avatar
Jody Goldberg committed
1154 1155
MDETERM(A1:D4) equals 148.

1156 1157
@SEEALSO=MMULT, MINVERSE

Jody Goldberg's avatar
update  
Jody Goldberg committed
1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171
@FUNCTION=COUPNCD
@SYNTAX=COUPNCD(settlement,maturity,frequency[,basis])
@DESCRIPTION=Returns the coupon date following settlement.
@EXAMPLES=

@SEEALSO=

@FUNCTION=MDURATION
@SYNTAX=MDURATION(settlement,maturity,coupon,yield,frequency[,basis])
@DESCRIPTION=Returns the Macauley duration for a security with par value 100.
@EXAMPLES=

@SEEALSO=

1172 1173
@FUNCTION=HEX2DEC
@SYNTAX=HEX2DEC(x)
Jody Goldberg's avatar
Jody Goldberg committed
1174 1175 1176
@DESCRIPTION=The HEX2DEC function converts a hexadecimal number to its decimal equivalent. This function is Excel compatible. 
@EXAMPLES=
HEX2DEC("2A") equals 42.
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
1177

1178
@SEEALSO=DEC2HEX, HEX2BIN, HEX2OCT
Arturo Espinosa's avatar
0.19  
Arturo Espinosa committed
1179 1180 1181

@FUNCTION=MINUTE
@SYNTAX=MINUTE (serial_number)
1182
@DESCRIPTION=Converts a serial number to a minute.  The minute is returned as an integer in the range 0 to 59.
1183
Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.
Jody Goldberg's avatar
Jody Goldberg committed
1184 1185
@EXAMPLES=

Arturo Espinosa's avatar