next up previous contents index
Next: CHAR Up: A. Function Reference Previous: CEIL, CEILING, XLCEILING   Contents   Index


CELLREF

Syntax: CELLREF(N1, N2)

N1 = a numeric value
N2 = a numeric value

CELLREF returns a reference to the cell whose column index is N1 and whose row index is N2. Column indices start with 0, so the column index for column A is 0, B is 1, etc. Row indices are the same as the row number, and therefore start with 1.

Examples:

CELLREF(3, 1) = -80, where D1 = -80

CELLREF(27, 34) = 2400, where AA34 = 2400

CELLREF(4, 8) = 100.00, where E8 = 100.00

Excel function: N/A


next up previous contents index
Next: CHAR Up: A. Function Reference Previous: CEIL, CEILING, XLCEILING   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003