Next: 7.11.10 Embedded Tools
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.8 Date and Time
- @@(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: 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