- 4.11.1 Mathematical Functions
- 4.11.2 Statistical Functions
- 4.11.3 Conditional Statistical Functions
- 4.11.4 String Functions
- 4.11.5 Logic Functions
- 4.11.6 Digital Logic Functions
- 4.11.7 Financial Functions
- 4.11.8 Date and Time Functions
- 4.11.9 Miscellaneous Functions
- 4.11.10 Embedded Tools

4.11 Quick-Reference Guide to Built-in Functions

4.11.1 Mathematical Functions

**ABS(***X*) -- The absolute value of
*X*.*This function is compatible with Excel.* **ACOS(***X*) -- The arc cosine of
*X*.*This function is compatible with Excel.* **ACOSH(***X*) -- The hyperbolic arc cosine of
*X*.*This function is compatible with Excel.* **ASIN(***X*) -- The arc sine of
*X*.*This function is compatible with Excel.* **ASINH(***X*) -- The hyperbolic arc sine of
*X*.*This function is compatible with Excel.* **ATAN(***X*) -- The 2-quadrant arc tangent of
*X*.*This function is compatible with Excel.* **ATAN2(***X, Y*) -- The 4-quadrant arc tangent of
*Y/X*.*This function is compatible with Excel.* **ATANH(***X*) -- The hyperbolic arc tangent of
*X*.*This function is compatible with Excel.* **CEILING(***X[, S]*) -- The smallest integer greater than or equal
to
*X*, with optional significance parameter*S*. **CEIL(***X[, S]*) -- A synonym for function ``CEILING.''
**XLCEILING(***X, S*) -- The smallest integer greater than or equal
to
*X*, with required significance parameter*S*.*This function is compatible with the Excel function ``CEILING.''* **COS(***X*) -- The cosine of
*X*.*This function is compatible with Excel.* **COSH(***X*) -- The hyperbolic cosine of
*X*.*This function is compatible with Excel.* **DEGREES(***X*) -- Converts the angle expressed in radians to
degrees (
).
**DET(***M*) -- The determinant of the matrix range
*M*, which must be a square matrix. **DOT(***R1, R2*) -- The dot product of the vectors
*R1*and*R2*. **EXP(***X*) -*e*raised to the*X*power.*This function is compatible with Excel.***FACT(***N*) -- The value of
*N!*.*This function is compatible with Excel.* **FLOOR(***X[, S]*) -- The largest integer less than or equal to
*X*, with optional significance parameter*S*. **XLFLOOR(***X, S*) -- The largest integer less than or equal to
*X*, with required significance parameter*S*.*This function is compatible with the Excel function ``FLOOR.''* **FRAC(***X*) -- The fractional portion of
*X*. **GAMMA(***X*) -- The value of the gamma function evaluated at
*X*. **GRAND() -**- A 12th-degree binomial approximation to a Gaussian
random number with zero mean and unit variance.
**INT(***X*) -- The integer portion of
*X*. (Rounded towards zero for positive and negative numbers.) **XLINT(***X*) -- The integer portion of
*X*. (Rounded towards zero for positive numbers and away from zero for negative numbers.)*This function is compatible with the Excel function ``INT.''* **LN(***X*) -- The natural log (base
*e*) of*X*.*This function is compatible with Excel.* **LNGAMMA(***X*) -- The log base
*e*of the gamma function evaluated at*X*. **LOG(***X[, B]*) -- The log base
*B*of*X*. If*B*is omitted, it is assumed to be 10.*This function is compatible with Excel.* **LOG10(***X*) -- The log base 10 of
*X*.*This function is compatible with Excel.* **LOG2(***X*) -- The log base 2 of
*X*. **MOD(***X, Y*) -- The remainder of
*X/Y*. **XLMOD(***X, Y*) -- The modulus of
*X/Y*.*This function is compatible with the Excel.* **MODULUS(***X, Y*) -- The modulus of
*X/Y*. **PI() -**- The value of pi ().
*This function is compatible with Excel.* **POLY(***X, ...*) -- The value of an
*N*th-degree polynomial in*X*. **PRODUCT(***X, ...*) -- The product of all the numeric values
in the argument list.
*This function is compatible with Excel.* **RADIANS(***X*) -- Converts the angle expressed in degrees to
radians (
).
**RAND() -**- A uniform random number on the interval [0,1).
*This function is compatible with Excel.* **ROUND(***X, n*) -*X*rounded to n number of decimal places (0 to 15).*This function is compatible with Excel.***SIGMOID(***X*) -- The value of the sigmoid function
.
**SIN(***X*) -- The sine of
*X*.*This function is compatible with Excel.* **SINH(***X*) -- The hyperbolic sine of
*X*.*This function is compatible with Excel.* **SQRT(***X*) -- The positive square root of
*X*.*This function is compatible with Excel.* **SUMPRODUCT(***R1, R2*) -- The dot product of the vectors
*R1*and*R2*, where*R1*and*R2*are of equal dimension.*This function is compatible with Excel.* **TAN(***X*) -- The tangent of
*X*.*This function is compatible with Excel.* **TANH(***X*) -- The hyperbolic tangent of
*X*.*This function is compatible with Excel.* **TRANSPOSE(***M*) -- The transpose of matrix
*M*. **TRUNC(***X[, N]*) -- The value of
*X*truncated to*N*digits. If*N*is omitted, it is assumed to be zero.*This function is compatible with Excel.* **VECLEN(***...*) -- The square root of the sum of squares of
its arguments.

4.11.2 Statistical Functions

**AVG(***...*) -- The average (arithmetic mean) of its arguments.
**AVGERAGE(***...*) -- The average (arithmetic mean) of its arguments
(functionally equivalent to AVG).
*This function is compatible with the Excel function ``AVERAGE.''* **NOW(***Alpha, SDev, N*) -- Returns the two-sided
``
*Alpha*-level'' confidence interval for a population of size*N*with a standard deviation of*SDev*.*This function is compatible with Excel.* **CORR(***R1, R2*) -- Pearson's product-moment correlation
coefficient for the paired data in ranges
*R1*and*R2*. **CORREL(***R1, R2*) -- A synonym for function ``CORR.''
*This function is compatible with Excel.* **COUNT(***...*) -- A count of its non-blank arguments.
*This function is compatible with Excel.* **F(***M, N, F*) -- The integral of Snedecor's
*F*-distribution with*M*and*N*degrees of freedom from minus infinity to*F*. **ERF(***L[, U]*) -- Error function integrated between 0 and
*L*; if*U*specified, between*L*and*U*. **ERFC(***L*) -- Complementary error function integrated between
*L*and infinity. **FORECAST(***...*) -- Predicted
*Y*values for given*X*. **FTEST(***R1, R2*) -- The significance level () of the
two-sided
*F*-test on the variances of the data specified by ranges*R1*and*R2*. **GMEAN(***...*) -- The geometric mean of its arguments.
**GEOMEAN(***...*) -- A synonym for function ``GMEAN.''
*This function is compatible with Excel.* **HMEAN(***...*) -- The harmonic mean of its arguments.
**HARMEAN(***...*) -- A synonym for function ``HMEAN.''
*This function is compatible with Excel.* **LARGE(***R, N*) -- The
*N*th largest value in range*R*.*This function is compatible with Excel.* **MAX(***...*) -- The maximum of its arguments.
*This function is compatible with Excel.* **MEDIAN(***...*) -- The median (middle value) of the range
*R1*.*This function is compatible with Excel.* **MIN(***...*) -- The minimum of its arguments.
*This function is compatible with Excel.* **MODE(***...*) -- The mode, or most frequently occurring value.
*This function is compatible with Excel.* **MSQ(***...*) -- The mean of the squares of its arguments.
**NORMDIST(***X, M, S, C*) --
The cumulative normal distribution from minus infinity to
*X*for mean*M*and standard deviation*S.*If*C*is True (non-zero), the cumulative distribution is returned; otherwise, the probability mass function is returned.*This function is compatible with Excel.* **NORMSDIST(***X*) --
The cumulative standard normal distribution from minus infinity
to
*X*.*This function is compatible with Excel.* **NORMINV(***P, M, S*) --
Returns the inverse of the cumulative normal distribution
function with mean
*M*and standard deviation*S*for probability*P*.*This function is compatible with Excel.* **NORMSINV(***P*) --
Returns the inverse of the cumulative standard normal distribution
function for probability
*P*.*This function is compatible with Excel.* **PERCENTILE(***R, N*) -- The value from the range
*R*which is at the*N*th percentile in*R*.*This function is compatible with Excel.* **PERCENTRANK(***R, N*) -- The percentile rank of the number
*N*among the values in range*R*.*This function is compatible with Excel.* **PERMUT(***S, T*) -- The number of
*T*objects that can be chosen from the set*S*, where order is significant.*This function is compatible with Excel.* **PTTEST(***R1, R2*) -- The significance level () of
the two-sided
*T*-test for the paired samples contained in ranges*R1*and*R2*. **QUARTILE(***R, Q*) -- The quartile
*Q*of the data in range*R*.*This function is compatible with Excel.* **RANK(***E, R[, O]*) -- The rank of a numeric argument
*E*in the range*R*.*This function is compatible with Excel.* **RMS(***...*) -- The root of the mean of squares of its
arguments.
**SMALL(***R, N*) -- The
*N*th smallest number in range*R*.*This function is compatible with Excel.* **SSE(***...*) -- The sum squared error of its arguments. It is
equivalent to VAR(...) COUNT(...).
**SSQ(***...*) -- The sum of squares of its arguments.
**STANDARDIZE(***X, M, S*) --
Returns the standardized value of
*X*for a distribution with the given mean*M*and standard deviation*S*.*This function is compatible with Excel.* **STDEVP(***...*) -- The population standard deviation (N
weighting) of its arguments.
*This function is compatible with Excel.* **STD(***...*) -- A synonym for function ``STDEVP.''
**STDEV(***...*) -- The sample standard deviation (N-1 weighting)
of its arguments.
*This function is compatible with Excel.* **STDS(***...*) -- A synonym for function ``STDEV.''
**SUM(***...*) -- The sum of its arguments.
*This function is compatible with Excel.* **T(***N, T*) -- The integral of Student's
*T*-distribution with*N*degrees of freedom from minus infinity to*T*. **TTEST(***R, X*) -- The significance level () of the
two-sided single population
*T*-test for the population samples contained in range*R*. **TTEST2EV(***R1, R2*) -- The significance level () of
the two-sided dual population
*T*-test for ranges*R1*and*R2*, where the population variances are equal. **TTEST2UV(***R1, R2*) -- The significance level () of
the two-sided dual population
*T*-test for ranges*R1*and*R2*, where the population variances are not equal. **VAR(***...*) -- The population variance (N weighting) of its
arguments.
**VARP(***...*) -- A synonym for function ``VAR.''
*This function is compatible with Excel.* **VARS(***...*) -- The sample variance (N-1 weighting) of its
arguments.
**XLVAR(***...*) -- A synonym for ``VARS.''
*This function is compatible with the Excel function ``VAR.''* **VSUM(***...*) -- The ``visual sum'' of its arguments, using
precision and rounding of formatted cell values.
**ZTEST(***Range, X[, S]*) --
Returns the
*p*-value for a two-tailed Z-test for*X*over the sample set*Range*. If the population standard deviation*S*is omitted, the calculated sample standard deviation is used instead.*This function is compatible with Excel.*

4.11.3 Conditional Statistical Functions

[CAVG(*..., C*) -] Conditional average.

[CCOUNT(*..., C*) -]Conditional count.

[CMAX(*..., C*) -] Conditional maximum.

[CMIN(*..., C*) -] Conditional minimum.

[CSTD(*..., C*) -] Conditional sample standard deviation (N
weighting).

[CSTDS(*..., C*) -] Conditional sample standard deviation
(N-1 weighting).

[CSUM(*..., C*) -] Conditional sum.

[CVAR(*..., C*) -] Conditional population variance (N
weighting).

[CVARS(*..., C*) -] Conditional population variance (N-1
weighting).

4.11.4 String Functions

**CHAR(***N*) -- The character represented by the code
*N*.*This function is compatible with Excel.* **CLEAN(***S*) -- The string formed by removing all non-printing
characters from the string
*S*.*This function is compatible with Excel.* **CODE(***S*) -- The ASCII code for the first character in
string
*S*.*This function is compatible with Excel.* **CONCATENATE(***...*) -- The concatenation of all its arguments.
(Functionally equivalent to ``STRCAT.'')
*This function is compatible with Excel.* **EXACT(***S1, S2*) -- Returns true (1) if string
*S1*exactly matches string*S2*, otherwise returns 0.*This function is compatible with Excel.* **FIND(***S1, S2, N*) -- The index of the first occurrence of
*S1*in*S2*. **FORMAT(***F, N, X*) -- The string formed by formatting the
value
*X*using format code*F*and precision*N*. **HEXTONUM(***S*) -- The numeric value for the hexadecimal
interpretation of
*S*. **LEFT(***S[, N]*) -- The string composed of the leftmost
*N*characters of*S*. The default value of*N*is one.*This function is compatible with Excel.* **LEN(***S*) -- The number of characters in
*S*.*This function is compatible with Excel.* **LENGTH(***S*) -- A synonym for function ``LEN.''
**LOWER(***S*) -*S*converted to lower case.*This function is compatible with Excel.***MID(***S, N1, N2*) --
The string of length
*N2*that starts at position*N1*in*S*, assuming the index of the first character of the string is 0 (zero-based indexing). **XLMID(***S, N1, N2*) --
The string of length
*N2*that starts at position*N1*in*S*, assuming the index of the first character of the string is 1 (one-based indexing).*This function is compatible with Excel.* **NUMTOHEX(***X*) -- The hexadecimal representation of the
integer portion of
*X*. **PROPER(***S*) -- The string
*S*with the first letter of each word capitalized.*This function is compatible with Excel.* **REGEX(***S1, S2*) -- Returns true (1) if string
*S1*exactly matches string*S2*; otherwise returns false (0). Allows ``wildcard'' comparisons by interpreting*S1*as a regular expression. **REPEAT(***S, N*) -- The string
*S*repeated*N*times. **REPT(***S, N*) -- A synonym for function ``REPEAT.''
*This function is compatible with Excel.* **REPLACE(***S1, N1, N2, S2*) -- The string formed by replacing the
*N2*characters starting at position*N1*in*S1*with string*S2*, assuming the index of the first character of the string is 0 (zero-based indexing). **XLREPLACE(***S1, N1, N2, S2*) -- The string formed by replacing the
*N2*characters starting at position*N1*in*S1*with string*S2*, assuming the index of the first character of the string is 1 (one-based indexing).*This function is compatible with Excel.* **RIGHT(***S[, N]*) -- The string composed of the rightmost
*N*characters of*S*. The default value of*N*is one.*This function is compatible with Excel.* **STRCAT(***...*) -- The concatenation of all its arguments.
**STRING(***X, N*) -- The string representing the numeric value
of
*X*, to*N*decimal places. **STRLEN(***...*) -- The total length of all strings in its
arguments.
**TRIM(***S*) -- The string formed by removing spaces from the
string
*S*.*This function is compatible with Excel.* **UPPER(***S*) -- The string
*S*converted to upper case.*This function is compatible with Excel.* **VALUE(***S*) -- The numeric value represented by the string
*S*; otherwise 0 if*S*does not represent a number.*This function is compatible with Excel.*

4.11.5 Logic Functions

**FALSE() -**- The logical value 0.
*This function is compatible with Excel.* **FILEEXISTS(***S*) -- 1 if file
*S*can be opened for reading; otherwise 0. **IF(***X, T, F*) -- The value of
*T*if*X*evaluates to on-zero, or*F*if*X*evaluates to zero.*This function is compatible with Excel.* **ISERR(***X*) -- Returns 1 if
*X*references an error, otherwise 0.*This function is compatible with Excel.* **ISERROR(***X*) -- Returns 1 if
*X*references an error or the value "N/A", otherwise 0.*This function is compatible with Excel.* **ISNUMBER(***X*) -- 1 if
*X*is a numeric value; otherwise 0.*This function is compatible with Excel.* **ISSTRING(***X*) -- 1 if
*X*is a string value; otherwise 0. **ISTEXT(***X*) -- A synonym for function ``ISSTRING.''
*This function is compatible with Excel.* **TRUE() -**- The logical value 1.
*This function is compatible with Excel.*

4.11.6 Digital Logic Functions

**AND(***...*) -- 0 if any arguments are 0; 1 if all arguments
are 1; otherwise -1 (``unknown'').
**XLAND(***...*) -- 1 if all of its arguments are non-zero;
0 otherwise.
*This function is compatible with the Excel function ``AND.''* **NAND(***...*) -- 0 if all arguments are 1; 1 if any arguments
are 0; otherwise -1 (``unknown'').
**NOR(***...*) -- 0 if any arguments are 1; 1 if all arguments
are 0; otherwise -1 (``unknown'').
**NOT(***X*) -- 0 if
*X*=1; 1 if*X*=0; otherwise -1 (``unknown''). **XLNOT(***X*) -- 1 if
*X*=0; 0 otherwise.*This function is compatible with the Excel function ``NOT.''* **OR(***...*) -- 0 if all arguments are 0; 1 if any arguments
are 1; otherwise -1 (``unknown'').
*This function is partially compatible with Excel. The Excel OR function does not support the notion of ``unknown'' values.* **XLOR(***...*) -- 1 if any of its arguments are non-zero;
0 otherwise.
*This function is compatible with the Excel function ``OR.''* **XOR(***...*) -- -1 (``unknown'') if any of the arguments are
not 0 or 1;
otherwise 0 if the total number of arguments with the
value 1 is even; 1 if the total number of arguments
with the value 1 is odd.

4.11.7 Financial Functions

**ACCRINT(***I, Ft, S, R, P, F[, B]*) -- Accrued interest for a
security that pays periodic interest.
**ACCRINTM(***I, S, R, P[, B]*) -- Accrued interest for a security
that pays interest at maturity.
**COUPDAYBS(***S, M, F[, B]*) -- The number of days between the
beginning of the coupon period to the settlement date.
**COUPDAYS(***S, M, F[, B]*) -- The number of days in the coupon
period that the settlement date is in.
**COUPDAYSNC(***S, M, F[, B]*) -- The number of days between the
settlement date and the next coupon date.
**COUPNCD(***S, M, F[, B]*) -- The next coupon date after the
settlement date.
**COUPNUM(***S, M, F[, B]*) -- The number of coupon payments
between the settlement date and maturity date.
**COUPPCD(***S, M, F[, B]*) -- The previous (most recent) coupon
date before the settlement date.
**CTERM(***R, FV, PV*) -- The number of compounding periods for
an investment.
**CUMIPMT(***R, NP, PV, S, E, T*) -- The cumulative interest on a
loan between start period
*S*and end period*E*. **CUMPRINC(***R, NP, PV, S, E, T*) -- The cumulative principal paid
on a a loan between start period
*S*and end period*E*. **DB(***C, S, L, P[, M]*) -- Fixed-declining depreciation
allowance.
**DDB(***C, S, L, N*) -- Double-declining depreciation
allowance.
**DISC(***S, M, P, R[, B]*) -- The discount rate for a security.
**DOLLARDE(***FD, F*) -- Converts a dollar amount expressed as a
fraction form into a decimal form.
**DOLLARFR(***DD, F*) -- Converts a dollar amount expressed as a
decimal form into a fraction form.
**DURATION(***S, M, R, Y, F[, B]*) -- The Macauley duration of a
security assuming $100 face value.
**EFFECT(***NR, NP*) -- Returns the effective annual interest
rate.
**FV(***P, R, N*) -- Future value of an annuity.
**FVSCHEDULE(***P, S*) -- The future value of an initial investment
after compounding a series of interest rates.
**INTRATE(***S, M, I, R[, B]*) -- The interest rate for a fully
invested security.
**IPMT(***R, P, NP, PV[, FV, T]*) -- The interest payment for a
specific period for an investment based on periodic,
constant payments and a constant interest rate.
**XLIPMT(***R, P, NP, PV[, FV, T]*) -- The interest payment for a
specific period for an investment based on periodic,
constant payments and a constant interest rate,
returned as a negative value.
*This function is compatible with Excel.* **IRR(***G, F*) -- The internal rate of return on an investment.
(See also XIRR and MIRR.)
**MDURATION(***S, M, R, Y, F[, B]*) -- The modified Macauley
duration of a security assuming $100 face value.
**MIRR(***CF, FR, RR*) -- The modified internal rate of return
for a series of periodic cash flows.
*This function is compatible with Excel.* **NOMINAL(***ER, NP*) -- The nominal annual interest rate.
**NPV(***R, CF*) -- The present value of a series of future cash
flows at given the rate
*R*and the cash flow*CF*range. **ODDFPRICE(***S, M, I, FC, R, Y, RD, F[, B]*) -- The price per
$100 face value of a security with an odd (short or
long) first period.
**ODDFYIELD(***S, M, I, FC, R, PR, RD, F[, B]*) -- The yield per of
a security with an odd (short or long) first period.
**ODDLPRICE(***S, M, LC, R, Y, RD, F[, B]*) -- The price per $100
face value of a security with an odd (short or long)
last period.
**ODDLYIELD(***S, M, LC, R, PR, RD, F[, B]*) -- The yield per of a
security with an odd (short or long) first period.
**PMT(***PV, R, N*) -- The periodic payment for a loan.
**PPMT(***R, P, NP, PV, FV, T*) -- The payment on the principal for
a specific period for an investment based on periodic,
constant payments and a constant interest rate.
**PRICE(***S, M, R, Y, RD, F[, B]*) -- The price per $100 face
value of a security that pays periodic interest.
**PRICEDISC(***S, M, D, RD[, B]*) -- The price per $100 face value
of a discounted security.
**PRICEMAT(***S, M, I, R, Y[, B]*) -- The price per $100 face
value of a security that pays interest at maturity.
**PV(***P, R, N*) -- The present value of an annuity.
**RATE(***FV, PV, N*) -- The interest rate required to reach
future value
*FV*. **RECEIVED(***S, M, I, D, [, B]*) -- The amount received at
maturity for a fully vested security.
**SLN(***C, S, L*) -- The straight-line depreciation allowance.
*This function is compatible with Excel.* **SYD(***C, S, L, N*) -- The ``sum-of-years-digits''
depreciation allowance.
*This function is compatible with Excel.* **TBILLEQ(***S, M, D*) -- The bond-equivalent yield (BEY) for a
Treasury Bill.
**TBILLPRICE(***S, M, D*) -- The price per $100 face value for a
Treasury bill.
**TBILLYIELD(***S, M, D*) -- The yield on a Treasury bill.
**TERM(***P, R, FV*) -- The number of payment periods for an
investment.
**VDB(***C, S, L, S, E*) -- Fixed-declining depreciation
allowance between two periods.
**XIRR(***G, V, D*) -- Internal rate of return for a series of
cash flows with variable intervals.
**XNPV(***R, V, D*) -- Returns the net present value for a
series of cash flows with variable intervals.
**YIELD(***S, M, R, PR, RD, F[, B]*) -- Yield of a security that
pays periodic interest.
**YIELDDISC(***S, M, PR, RD[, B]*) -- The annual yield for a
discounted security.
**YIELDMAT(***S, M, I, R, PR[, B]*) -- Annual yield of a security
which pays interest at maturity.

4.11.8 Date and Time Functions

**DATE(***Y, M, D*) -- The date value for year
*Y*, month*M*, and day*D*.*This function is compatible with Excel.* **DATEVALUE(***S*) -- The corresponding date value for a given
string
*S*.*This function is compatible with Excel.* **DAYS360(***S, E*) -- The number of days between two dates,
based on a 30/360 day count system.
*This function is compatible with Excel.* **DAY(***DT*) -- The day number in the date/time value
*DT*.*This function is compatible with Excel.* **EDATE(***S, M*) -- The date/time value representing number of
months (
*M*) before or after start date (*S*). **EOMONTH(***S, M*) -- The date/time value representing the last
day of the month
*M*months after*S*, if M is positive, or*M*months before if*M*is negative. **HOUR(***DT*) -- The hour value (0-23) of date/time value
*DT*.*This function is compatible with Excel.* **MINUTE(***DT*) -- The minute value (0-59) of date/time value
*DT*.*This function is compatible with Excel.* **MONTH(***DT*) -- The number of the month in date/time value
*DT*.*This function is compatible with Excel.* **NETWORKDAYS(***S, E[, H]*) -- The number of whole working days,
starting at
*S*and going to*E*, excluding weekends and holidays. **NOW() -**- The date/time value of the current system date and time.
*This function is compatible with Excel.* **SECOND(***DT*) -- The seconds value (0-59) of the date/time
value
*DT*.*This function is compatible with Excel.* **TIME(***H, M, S*) -- The time value for hour
*H*, minute*M*, and second*S*.*This function is compatible with Excel.* **TIMEVALUE(***S*) -- The corresponding time value for a given
string value
*S*.*This function is compatible with Excel.* **TODAY() -**- The date value of the current system date.
*This function is compatible with Excel.* **WEEKDAY(***D*) -- The integer representing the day of the week
on which the day
*D*falls. 1 is Sunday, 7 is Saturday. **WORKDAY(***S, D[, H]*) -- The day that is
*D*working days after*S*, if*D*is positive, or before*S*, if*D*is negative, excluding weekends and all holidays specified as dates in range*H*. **YEAR(***DT*) -- The year value of date/time value
*DT*.*This function is compatible with Excel.* **YEARFRAC(***S, E[, B]*) -- The portion of the year represented by
the number of days between start date (
*S*) and end date (*E*).

4.11.9 Miscellaneous Functions

**@(***S*) -- Reference to the cell or range
*S*. **ALARM(***X, S*) -- If X evaluates non-zero, string (
*S*) is evaluated as an expression and the terminal beeps. If*X*evaluates to zero,*S*is not evaluated and the return value is zero. **ANNOTATE(***Text, X, Y[, H[, V]*- ) -] Generates a dynamic
graph annotation text, given the text (Text),
coordinates
*(X,Y)*and the justification values*(H,V)*. **CELLREF(***N1, N2*) -- A reference to the cell in column
*N1*and row*N2*. **CHOOSE(***N, ...*) -- The
*N*th argument from the list, where the index of the first argument in the list is 0. **XLCHOOSE(***N, ...*) -- The
*N*th argument from the list, where the index of the first argument in the list is 1.*This function is compatible with Excel.* **COL(***C*) --
The column address of the cell referenced by
*C*, with columns numbered starting with 0 (zero-based). **COLUMN(***C*) --
The column address of the cell referenced by
*C*, with columns numbered starting with 1 (one-based).*This function is compatible with Excel.* **COLS(***R*) -- The number of columns in the specified range
*R*. **COLUMNS(***R*) -- A synonym for function ``COLS.''
*This function is compatible with Excel.* **HLOOKUP(***X, T, N[, R]*) -- The value of the cell in range
*T*that is*N*rows beneath the largest value in the first row of*T*that is less than or equal to*X*. If optional parameter*R*is set to 0, an exact match to*X*is required. **XLHLOOKUP(***X, T, N[, R]*) -- The value of the cell in range
*T*that is*N-1*rows below the largest value in the first row of*T*that is less than or equal to*X*. If optional parameter*R*is set to 0, an exact match to*X*is required.*This function is compatible with Excel.* **INIT(***X1, X2*) -- The first argument on the first
recalculation pass and the second argument on all
subsequent recalculation passes when SpreadScript is performing
iterative calculations.
**INTERP2D(***R1, R2, N*) -- The interpolation value for a
2-dimensional vector.
**INTERP3D(***R, X, Y*) -- The interpolation value for a
3-dimensional vector.
**MATCH(***V, R[, T]*) -- The relative position in range
*R*of value*V*based on positioning criteria*T*.*This function is compatible with Excel.* **MESSAGE(***X, S*) -- The string
*S*is displayed on the status line and the terminal beeps, if*X*evaluates non-zero. **N(***R*) -- The numeric value of the top left cell in range
*R*. **NA() -**- The ``not available'' value, ``N/A.''
*This function is compatible with Excel.* **RANGEREF(***N1, N2, N3, N4*) -- A reference to the range
defined by coordinates
*N1*through*N4*. **ROW(***C*) -- The row address of the cell referenced by
*C*.*This function is compatible with Excel.* **ROWS(***R*) -- The number of rows in the specified range
*R*.*This function is compatible with Excel.* **S(***R*) -- The string value of the top left cell in range
*R*. **SALARM(***X, S*) -- Silent alarm. The same as ALARM with no
terminal beep.
**VLOOKUP(***X, T, N[, R]*) -- The value of the cell in range
*T*that is*N*columns to the right of the largest value in the first column of*T*that is less than or equal to*X*. If optional parameter*R*is set to 0, an exact match to*X*is required. **XLVLOOKUP(***X, T, N[, R]*) -- The value of the cell in range
*T*that is*N-1*columns to the right of the largest value in the first column of*T*that is less than or equal to*X*. If optional parameter*R*is set to 0, an exact match to*X*is required.*This function is compatible with Excel.*

4.11.10 Embedded Tools

**DFT(***R*) -- The Discrete Fourier Transform of the range
*R*. **EIGEN(***M*) -- The eigenvalues of the matrix
*M*. **FFT(***R*) -- The Discrete Fourier Transform of the range
*R*using a fast Fourier Transform algorithm. **FREQUENCY(***R, B*) -- Returns a frequency distribution for
values
*R*with a set of intervals*B*.*This function is compatible with Excel.* **INVDFT(***R*) -- The inverse of the Discrete Fourier
Transform of the range
*R*. **INVERT(***M*) -- The inverse of matrix
*M*. **INVFFT(***R*) -- The inverse of the Discrete Fourier
Transform of the range
*R*using a fast Fourier Transform algorithm. **LINCOEF(***X, Y*) -- The least squares coefficients for the
straight line fit.
**LINFIT(***X, Y*) -- The straight line least squares fit.
This function is equivalent to POLYFIT(
*X, Y, 1*). **LLS(***A, Y*) -- The linear least squares solution
*X*to the over-determined system of equations . **MMUL(***M1, M2*) -- The product of multiplying matrix
*M2*by matrix*M1*. **PLS(***X, Y, d*) -- Analyzes the least squares polynomial
model , where
*P*is a polynomial of degree*d*. **POLYCOEF(***X, Y, d*) -- The least squares coefficients for
the polynomial fit , where
*P*is a polynomial of degree*d*. **POLYFIT(***X, Y, d*) -- The least squares polynomial fit,
given a vector of independent variables (
*X*), dependent variables (*Y*), and the degree (*d*) of polynomial. **TRANSPOSE(***M*) -- The transpose of matrix
*M*.*This function is compatible with Excel.* **TREND(***NX, KX, KY*) -- The
*y*values for new*x*values given existing*x*and*y*values.

Grey Trout Software

02 March 2003