Ø @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 Objective Grid 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.
Ø @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.
Ø @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 Objective Grid functions return a result that is a range or cell reference. Objective Grid 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.