next up previous contents index
Next: 4.12 Specifying Arguments to Up: 4. Built-in Functions Previous: 4.10 Embedded Tools   Contents   Index

Subsections


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 ( $180/\pi \times X$).

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 ($\pi$). This function is compatible with Excel.

POLY(X, ...) -
The value of an Nth-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 ( $\pi/180 \times X$).

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 $1/(1 + e^{-X})$.

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 ($\alpha$) 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 Nth 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 Nth 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 ($\alpha$) 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 Nth smallest number in range R. This function is compatible with Excel.

SSE(...) -
The sum squared error of its arguments. It is equivalent to VAR(...) $\times$ 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 ($\alpha$) of the two-sided single population T-test for the population samples contained in range R.

TTEST2EV(R1, R2) -
The significance level ($\alpha$) 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 ($\alpha$) 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 Nth argument from the list, where the index of the first argument in the list is 0.

XLCHOOSE(N, ...) -
The Nth 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.


IMPORTANT: Some SpreadScript functions return a result that is a range or cell reference. SpreadScript does not include these indirect references in determining the pattern of recalculation. Plan carefully before using these functions. See Section 4.13, Computed Cell References at the end of this chapter for more information.


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 $AX=Y$.

MMUL(M1, M2) -
The product of multiplying matrix M2 by matrix M1.

PLS(X, Y, d) -
Analyzes the least squares polynomial model $Y=P(X)$, where P is a polynomial of degree d.

POLYCOEF(X, Y, d) -
The least squares coefficients for the polynomial fit $Y=P(X)$, 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.


Embedded tools should not be contained within other functions or arithmetic operations in a single formula. You may, however, copy, move and format embedded tools just as any other function.


next up previous contents index
Next: 4.12 Specifying Arguments to Up: 4. Built-in Functions Previous: 4.10 Embedded Tools   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003