- abs
- acos
- acosh
- address
- and
- ash
- asin
- asinh
- atan
- atan2
- atan_2
- atanh
- avedev
- average
- averagea
- base64decode
- base64encode
- besseli
- besselj
- besselk
- bessely
- betadist
- betainv
- bin2dec
- bin2hex
- bin2oct
- binomdist
- cbrt
- cc_solv
- ceil
- ceiling
- char
- chidist
- chiinv
- choose
- code
- columns
- combin
- complex
- concatenate
- confidence
- convert
- cos
- cosh
- count
- counta
- countblank
- countif
- critbinom
- crypt
- currency_rate
- datevalue
- daverage
- day
- dcount
- dcounta
- dec2bin
- dec2hex
- dec2oct
- define
- degrees
- delta
- devsq
- dget
- dmax
- dmin
- dollar
- dproduct
- drem
- dstdev
- dstdevp
- dsum
- duration
- dvar
- dvarp
- effect
- erf
- erfc
- euro
- even
- exact
- exp
- expm_1
- expondist
- fabs
- fact
- factdouble
- fdist
- finv
- fisher
- fisherinv
- fixed
- floor
- fmod
- fv
- g_product
- gammadist
- gammainv
- gammaln
- gcd
- geomean
- gestep
- get_cell
- getcwd
- getenv
- getgid
- gethostid
- gethostname
- getpgrp
- getpid
- getppid
- getuid
- hex2bin
- hex2dec
- hex2oct
- hlookup
- hour
- href
- hyperlink
- hypgeomdist
- hypot
- imabs
- imaginary
- imargument
- imconjugate
- imcos
- imdiv
- imexp
- imln
- imlog_10
- imlog_2
- impower
- improduct
- imreal
- imsin
- imsqrt
- imsub
- imsum
- imtan
- inet_addr
- info
- int
- isblank
- iseven
- islogical
- isna
- isnontext
- isnumber
- isodd
- ispmt
- istext
- j_0
- j_1
- jn
- kurt
- kurtp
- large
- lcm
- left
- len
- length
- lgamma
- ln
- log
- log1p
- log_10
- log_2
- loginv
- lognormdist
- lower
- max
- maxa
- median
- min
- mina
- minute
- mmult
- mod
- month
- mpf_abs
- mpf_add
- mpf_ceil
- mpf_cmp
- mpf_div
- mpf_div_2exp
- mpf_eq
- mpf_floor
- mpf_mul
- mpf_mul_2exp
- mpf_neg
- mpf_pow_ui
- mpf_reldiff
- mpf_sgn
- mpf_sqrt
- mpf_sub
- mpf_trunc
- mpz_abs
- mpz_add
- mpz_and
- mpz_bin_ui
- mpz_cdiv_q
- mpz_cdiv_r
- mpz_clrbit
- mpz_cmp
- mpz_cmpabs
- mpz_com
- mpz_divexact
- mpz_fac_ui
- mpz_fdiv_q
- mpz_fdiv_q_2exp
- mpz_fdiv_r
- mpz_fdiv_r_2exp
- mpz_fib_ui
- mpz_gcd
- mpz_hamdist
- mpz_invert
- mpz_ior
- mpz_jacobi
- mpz_lcm
- mpz_legendre
- mpz_mod
- mpz_mul
- mpz_mul_2exp
- mpz_neg
- mpz_nextprime
- mpz_perfect_power_p
- mpz_perfect_square_p
- mpz_popcount
- mpz_pow_ui
- mpz_powm
- mpz_probab_prime_p
- mpz_remove
- mpz_root
- mpz_scan0
- mpz_scan1
- mpz_setbit
- mpz_sgn
- mpz_sizeinbase
- mpz_sqrt
- mpz_sub
- mpz_tdiv_q
- mpz_tdiv_q_2exp
- mpz_tdiv_r
- mpz_tdiv_r_2exp
- mpz_tstbit
- mpz_xor
- mround
- n
- negbinomdist
- nominal
- normdist
- norminv
- normsdist
- normsinv
- not
- now
- nper
- oct2bin
- oct2dec
- oct2hex
- odd
- or
- permut
- pi
- pmt
- poisson
- pow
- pow_10
- pow_2
- power
- ppmt
- product
- pv
- pwr
- quotient
- r_avg
- r_max
- r_min
- r_sum
- radians
- rand
- randbernoulli
- randbetween
- randbinom
- randexp
- randnegbinom
- random
- randpoisson
- realtime
- rept
- roman
- round
- rounddown
- roundup
- rows
- second
- siag_colsum
- siag_rowsum
- sign
- sin
- sinh
- siod
- skew
- skewp
- sln
- small
- sqrt
- sqrtpi
- standardize
- stdev
- stdeva
- stdevp
- stdevpa
- stock_max
- stock_min
- stock_open
- stock_percent
- stock_price
- stock_var
- stock_volume
- stock_yesterday
- strcmp
- strcspn
- strspn
- substring
- sum
- suma
- sumif
- sumproduct
- sumsq
- sumx2my2
- sumx2py2
- sumxmy_2
- sxhash
- syd
- tan
- tanh
- tbilleq
- tbillprice
- tbillyield
- tdist
- time
- timevalue
- tinv
- totalheight
- totalwidth
- transpose
- trunc
- upper
- var
- vara
- varp
- varpa
- vref
- weekday
- weibull
- y_0
- y_1
- year
- yn

ACOSH(5.3) equals 2.35183.

If abs_num is 1 or omitted, address returns absolute reference. If abs_num is 2, address returns absolute row and relative column. If abs_num is 3, address returns relative row and absolute column. If abs_num is 4, address returns relative reference. If abs_num is greater than 4, address returns error.

a1 is a logical value that specifies the reference style. If a1 is TRUE or omitted, address returns an A1-style reference, i.e. $D$4. Otherwise address returns an R1C1-style reference, i.e. R4C4.

text specifies the name of the worksheet to be used as the external reference.

If row_num or col_num is less than one, address returns error.

b1, trough bN are expressions that should evaluate to TRUE or FALSE. If an integer or floating point value is provided zero is considered FALSE and anything else is TRUE.

If the values contain strings or empty cells those values are ignored. If no logical values are provided, then error is returned. Excel compatible. The name of the function is @and, since and is used by Scheme.

and(TRUE,FALSE) equals FALSE.

Let us assume that A1 holds number five and A2 number one. Then

and(A1>3,A2<2) equals TRUE.

ASINH(1.0) equals 0.881374.

ATANH(0.8) equals 1.098612.

avedev(A1..A5) equals 7.84.

average(A1..A5) equals 23.2.

averagea(A1..A5) equals 18.94.

If x or order are not numeric an error is returned. If order < 0 a error is returned. Excel compatible.

If x or order are not numeric an error is returned. If order < 0 a error is returned. Excel compatible.

If x or order are not numeric an error is returned. If order < 0 a error is returned. Excel compatible.

If x < a or x > b betadist returns error. If alpha <= 0 or beta <= 0, betadist returns error. If a >= b betadist returns error. Excel compatible.

If p < 0 or p > 1, betainv returns error. If alpha <= 0 or beta <= 0, betainv returns error. If a >= b, betainv returns error. Excel compatible.

If places is too small or negative error is returned. This function is Excel compatible.

If places is too small or negative error is returned. This function is Excel compatible.

If n or trials are non-integer they are truncated. If n < 0 or trials < 0 binomdist returns error. If n > trials binomdist returns error. If p < 0 or p > 1 binomdist returns error. Excel compatible.

int solv(double a[],double b[],int n)

a = array containing system matrix A in row order (altered to L-U factored form by computation)

b = array containing system vector b at entry and solution vector x at exit

n = dimension of system

Excel compatible.

CEIL(-1.1) equals -1.

CEIL(-2.9) equals -2.

If x or significance is non-numeric ceiling returns error. If x and significance have different signs ceiling returns error. Excel compatible.

ceiling(123.123,3) equals 126.

If dof is non-integer it is truncated. If dof < 1, chidist returns error. Excel compatible.

If p < 0 or p > 1 or dof < 1, chiinv returns error. This function is Excel compatible.

If index < 1 or index > number of values: returns error.

If reference is neither an array nor a range returns error.

Performing this function on a non-integer or a negative number returns an error. Also if n is less than k returns an error. This function is Excel compatible.

combin(6,2) equals 15.

If suffix is neither 'i' nor 'j', complex returns error. This function is Excel compatible.

If size is non-integer it is truncated. If size < 0, confidence returns error. If size is 0, confidence returns error. Excel compatible.

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

If from_unit and to_unit are different types, CONVERT returns error. Excel compatible.

convert(5.8,"m","in") equals 228.3465.

convert(7.9,"cal","J") equals 33.07567.

COSH(1) equals 1.543081.

count(A1..A5) equals 5.

counta(A1..A5) equals 5.

countif(A1..A5,"<=28") equals 3.

countif(A1..A5,"<28") equals 2.

countif(A1..A5,"28") equals 1.

countif(A1..A5,">28") equals 2.

If trials is a non-integer it is truncated. If trials < 0, critbinom returns error. If p < 0 or p > 1, critbinom returns error. If alpha < 0 or alpha > 1, critbinom returns error. This function is Excel compatible.

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.

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

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

daverage(A1..C7, "Salary", A9..A11) equals 42296.3333.

daverage(A1..C7, "Age", A9..A11) equals 39.

daverage(A1..C7, "Salary", A9..B11) equals 40782.5.

daverage(A1..C7, "Age", A9..B11) equals 36.

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.

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

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

dcount(A1..C7, "Salary", A9..A11) equals 3.

dcount(A1..C7, "Salary", A9..B11) equals 2.

dcount(A1..C7, "Name", A9..B11) equals 0.

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.

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

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

dcounta(A1..C7, "Salary", A9..A11) equals 3.

dcounta(A1..C7, "Salary", A9..B11) equals 2.

dcounta(A1..C7, "Name", A9..B11) equals 2.

If places is too small or negative error is returned. This function is Excel compatible.

If places is too small or negative error is returned. This function is Excel compatible.

If places is too small or negative error is returned. This function is Excel compatible.

define(variable, value)

The variable can then be used in other places in the sheet.

define(foo, a1*b1) returns 6 and also defines the variable foo.

foo returns 6 after the definition above.

If either argument is non-numeric returns a error. This function is Excel compatible.

Strings and empty cells are simply ignored. This function is Excel compatible.

devsq(A1..A5) equals 470.56.

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

If none of the items match the conditions, dget returns error. If more than one items match the conditions, dget returns error.

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.

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.

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.

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

dstdev(A1..C7, "Age", A9..B11) equals 9.89949.

dstdev(A1..C7, "Salary", A9..B11) equals 9135.112506.

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

dstdevp(A1..C7, "Age", A9..B11) equals 7.

dstdevp(A1..C7, "Salary", A9..B11) equals 6459.5.

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

dsum(A1..C7, "Age", A9..B11) equals 72.

dsum(A1..C7, "Salary", A9..B11) equals 81565.

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

dvar(A1..C7, "Age", A9..B11) equals 98.

dvar(A1..C7, "Salary", A9..B11) equals 83450280.5.

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

dvarp(A1..C7, "Age", A9..B11) equals 49.

dvarp(A1..C7, "Salary", A9..B11) equals 41725140.25.

Effective interest rate is calculated using this formulae:

r( 1 + ------ ) ^ nper - 1 nper

where:

r = nominal interest rate (stated in yearly terms)

nper = number of periods used for compounding

For example if you wanted to find out how much you are actually paying interest on your credit card that states an APR of 19% that is compounded monthly you would type in:

effect(.19,12) and you would get .2075 or 20.75%. That is the effective percentage you will pay on your loan.

ATS (Austria)

BEF (Belgium)

DEM (Germany)

ESP (Spain)

FIM (Finland)

FRF (France)

IEP (Ireland)

ITL (Italy)

LUF (Luxemburg)

NLG (Netherlands)

PTE (Portugal)

If the given currency is other than one of the above, EURO returns error.

If x < 0 or y <= 0 this will return an error. This function is Excel compatible.

fabs(-3.14) equals 3.14.

fact(9) equals 362880.

If number is not an integer, it is truncated. If number is negative FACTDOUBLE returns error. Excel compatible.

If x < 0 FDIST returns error. If dof1 < 1 or dof2 < 1, FDIST returns error. Excel compatible.

If p < 0 or p > 1 FINV returns error. If dof1 < 1 or dof2 < 1 FINV returns error. Excel compatible.

If x is not-number FISHER returns error. If x <= -1 or x >= 1 FISHER returns error. Excel compatible.

If x is non-number FISHERINV returns error. This function is Excel compatible.

floor(-3.14) equals -4.

If x < 0 GAMMADIST returns error. If alpha <= 0 or beta <= 0, GAMMADIST returns error. Excel compatible.

If p < 0 or p > 1 GAMMAINV returns error. If alpha <= 0 or beta <= 0 GAMMAINV returns error. This function is Excel compatible.

If x is non-number then gammaln returns error. If x <= 0 then gammaln returns error. Excel compatible.

If any of the arguments is less than zero, gcd returns error. If any of the arguments is a non-integer, it is truncated. This function is Excel compatible.

gcd(470,770,1495) equals 5.

GEOMEAN(A1..A5) equals 21.279182482.

If either argument is non-numeric returns a error. This function is Excel compatible.

get_cell(2, 3, "Sheet 2") returns the value in row 2, column 3 in the sheet named "Sheet 2".

get_cell(2, 3, "1998.siag:") returns the value in row 2, column 3 in the first sheet of buffer "1998.siag".

get_cell(2, 3, "1998.siag:January") returns the value in row 2, column 3 in the sheet named "January" in the buffer "1998.siag".

If places is too small or negative error is returned. This function is Excel compatible.

If places is too small or negative error is returned. This function is Excel compatible.

If x,n,M or N is a non-integer it is truncated. If x,n,M or N < 0 HYPGEOMDIST returns error. If x > M or n > N HYPGEOMDIST returns error. Excel compatible.

INT(-5.5) equals -6.

If per < 1 or per > nper, ISPMT returns error.

Note, that this is only meaningful is the underlying distribution really has a fourth moment. The kurtosis is offset by three such that a normal distribution will have zero kurtosis.

Strings and empty cells are simply ignored.

If fewer than four numbers are given or all of them are equal KURT returns error. Excel compatible.

KURT(A1..A5) equals 1.234546305.

Strings and empty cells are simply ignored.

If fewer than two numbers are given or all of them are equal KURTP returns error.

KURTP(A1..A5) equals -0.691363424.

If data set is empty LARGE returns error. If k <= 0 or k is greater than the number of data items given LARGE returns error. Excel compatible.

LARGE(A1..A5,2) equals 25.9.

LARGE(A1..A5,4) equals 17.3.

If any of the arguments is less than one, LCM returns error. Excel compatible. Requires the GMP library.

LCM(4,7,5) equals 140.

If p < 0 or p > 1 or stdev <= 0 LOGINV returns error. This function is Excel compatible.

If stdev = 0 lognormdist returns error. If x <= 0, mean < 0 or stdev < 0 lognormdist returns error.

MINA(A1..A5) equals 0.

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.

MEDIAN(A1..A5) equals 21.3.

MAXA(A1..A5) equals 40.1.

MOD returns error if divisor is zero.

Since mpz_divexact is much faster than any of the other routines that produce the quotient (*note References:: Jebelean), it is the best choice for instances in which exact division is known to occur, such as reducing a rational to lowest terms.

This operation can also be defined as masking of the D least significant bits.

This function uses a probabilistic algorithm to identify primes, but for for practical purposes it's adequate, since the chance of a composite passing will be extremely small.

The function uses Miller-Rabin's probabilistic test.

If number and multiple have different sign, MROUND returns error. Excel compatible.

MROUND(321.123,0.12) equals 321.12.

If f or t is a non-integer it is truncated. If (f + t -1) <= 0 negbinomdist returns error. If p < 0 or p > 1 negbinomdist returns error. Excel compatible.

Nominal interest rate is given by a formula:

nper * (( 1 + r ) ^ (1 / nper) - 1 )

where:

r = effective interest rate

nper = number of periods used for compounding

If stdev is 0 normdist returns error. This function is Excel compatible.

If p < 0 or p > 1 or stdev <= 0 norminv returns error. This function is Excel compatible.

If p < 0 or p > 1 normsinv returns error.

Excel compatible. The name of this function is @NOT, to avoid clash with Scheme.

NOT(TRUE) equals FALSE.

Serial Numbers in Siag are represented as seconds from 01/01/1970.

=NPER(0.06, 0, -10000, 20000,0)returns 11.895661046 which indicates that you can double your money just before the end of the 12th year.

If places is too small or negative error is returned.

If places is too small or negative error is returned.

b1, trough bN are expressions that should evaluate to TRUE or FALSE. If an integer or floating point value is provided zero is considered FALSE and anything else is TRUE.

If the values contain strings or empty cells those values are ignored. If no logical values are provided, then an error is returned. Excel compatible. The name of the function is @OR.

OR(3>4,4<3) equals FALSE.

If n = 0 PERMUT returns error. If n < k PERMUT returns error. Excel compatible.

This function is called with no arguments. Excel compatible.

If x is a non-integer it is truncated. If x <= 0 poisson returns error. If mean <= 0 poisson returns the error. Excel compatible.

POWER(3,3.141) equals 31.523749.

Formula for it is:

PPMT(per) = PMT - IPMT(per)

where:

PMT = Payment received on annuity

IPMT(per) = amount of interest for period per

If p < 0 or p > 1 RandBernoulli returns error.

If bottom or top is non-integer, they are truncated. If bottom > top, RANDBETWEEN returns error. Excel compatible.

If p < 0 or p > 1 RandBinom returns error. If trials < 0 RandBinom returns error.

If p < 0 or p > 1, RANDNEGBINOM returns error. If failures RANDNEGBINOM returns error.

If digits is greater than zero, number is rounded to the given number of digits. If digits is zero or omitted, number is rounded to the nearest integer. If digits is less than zero, number is rounded to the left of the decimal point. Excel compatible.

ROUND(-3.3) equals -3.

ROUND(1501.15,1) equals 1501.2.

ROUND(1501.15,-2) equals 1500.0.

If digits is greater than zero, number is rounded down to the given number of digits. If digits is zero or omitted, number is rounded down to the nearest integer. If digits is less than zero, number is rounded down to the left of the decimal point. This function is Excel compatible.

ROUNDDOWN(-3.3) equals -4.

ROUNDDOWN(1501.15,1) equals 1501.1.

ROUNDDOWN(1501.15,-2) equals 1500.0.

If digits is greater than zero, number is rounded up to the given number of digits. If digits is zero or omitted, number is rounded up to the nearest integer. If digits is less than zero, number is rounded up to the left of the decimal point. This function is Excel compatible.

ROUNDUP(-3.3) equals -3.

ROUNDUP(1501.15,1) equals 1501.2.

ROUNDUP(1501.15,-2) equals 1600.0.

If reference is not an array nor a range returns error.

SIGN(-3) equals -1.

SIGN(0) equals 0.

Note, that this is only meaningful is the underlying distribution really has a third moment. The skewness of a symmetric (e.g., normal) distribution is zero.

Strings and empty cells are simply ignored.

If less than three numbers are given, SKEW returns error. This function is Excel compatible.

SKEW(A1..A5) equals 0.976798268.

Strings and empty cells are simply ignored.

If less than two numbers are given, SKEWP returns error.

SKEWP(A1..A5) equals 0.655256198.

The formula used for straight line depriciation is:

Depriciation expense = ( cost - salvage_value ) / life

cost = cost of an asset when acquired (market value). salvage_value = amount you get when asset sold at the end of the assets's useful life. life = anticipated life of an asset.

=SLN(10000, 700, 10)

This will return the yearly depreciation figure of $930.

If data set is empty SMALL returns error. If k <= 0 or k is greater than the number of data items given SMALL returns error. Excel compatible.

SMALL(A1..A5,2) equals 17.3.

SMALL(A1..A5,4) equals 25.9.

If stddev is 0 STANDARDIZE returns error. This function is Excel compatible.

STDEV(A1..A5) equals 10.84619749.

STDEVA(A1..A5) equals 15.119953704.

STDEVP(A1..A5) equals 9.701133954.

STDEVPA(A1..A5) equals 13.523697719.

SUM(A1..A5) equals 107.

SUMA(A1..A5) equals 107.

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.

If arrays or range arguments do not have the same dimentions, SUMPRODUCT returns error. Excel compatible.

SUMPRODUCT(A1..A5,B1..B5) equals 3370.

SUMSQ(A1..A5) equals 2925.

Strings and empty cells are simply ignored.

If array1 and array2 have different number of data points, SUMX2MY2 returns error. Excel compatible.

SUMX2MY2(A1..A5,B1..B5) equals -1299.

Strings and empty cells are simply ignored.

If array1 and array2 have different number of data points, SUMX2PY2 returns error. Excel compatible.

SUMX2PY2(A1..A5,B1..B5) equals 7149.

Strings and empty cells are simply ignored.

If array1 and array2 have different number of data points, SUMXMY2 returns error. Excel compatible.

SUMXMY_2(A1..A5,B1..B5) equals 409.

The Formula used for sum-of-years digits depriciation is:

Depriciation expense = ( cost - salvage_value ) * (life - period + 1) * 2 / life * (life + 1).

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.

=SYD(5000, 200, 5, 2) which returns 1,280.00.

If settlement is after maturity or the maturity is set to over one year later than the settlement, TBILLEQ returns error. If discount is negative, TBILLEQ returns error.

If settlement is after maturity or the maturity is set to over one year later than the settlement, TBILLPRICE returns error. If discount is negative, TBILLPRICE returns error.

If settlement is after maturity or the maturity is set to over one year later than the settlement, TBILLYIELD returns error. If pr is negative, TBILLYIELD returns error.

If dof < 1 TDIST returns error. If tails is neither 1 or 2 TDIST returns error. Excel compatible.

If p < 0 or p > 1 or dof < 1 TINV returns error. This function is Excel compatible.

(VAR is also known as the N-1-variance. Under reasonable conditions, it is the maximum-likelihood estimator for the true variance.)This function is Excel compatible.

VAR(A1..A5) equals 117.64.

VARA(A1..A5) equals 228.613.

(VARP is also known as the N-variance.)

VARP(A1..A5) equals 94.112.

VARPA(A1..A5) equals 182.8904.

If x < 0 weibull returns error. If alpha <= 0 or beta <= 0 weibull returns error. Excel compatible.

Ulric Eriksson - November 2000 - ulric@siag.nu