next up previous contents index
Next: 7.11.10 Embedded Tools Up: 7.11 Quick-Reference Guide to Previous: 7.11.8 Date and Time

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

@COL(C) -
The column address of the cell referenced by   C.

@COLS(R) -
The number of columns in the specified range   R.

@HLOOKUP(X, S, R) -
The value of the cell in range S   that is R number of rows beneath X.

@INIT(X1, X2) -
The first argument on the first   recalculation pass and the second argument on all subsequent recalculation passes when NExS 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.

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

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

@ROWS(R) -
The number of rows in the specified range   R.

@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, S, C) -
The value of the cell in range S   that is C number of columns to the right of X.


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


next up previous contents index
Next: 7.11.10 Embedded Tools Up: 7.11 Quick-Reference Guide to Previous: 7.11.8 Date and Time

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999