next up previous contents index
Next: CHAR Up: A Function Reference Previous: CEIL

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


next up previous contents index
Next: CHAR Up: A Function Reference Previous: CEIL

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