next up previous contents index
Next: RANK Up: A Function Reference Previous: RAND

RANGEREF

 

Syntax: @RANGEREF(N1, N2, N3, N4)

N1 = the upper left column index of the range
N2 = the upper left row index of the range
N3 = the lower right column index of the range
N4 = the lower right row index of the range

@RANGEREF returns a reference to the range described by corner coordinates N1, N2, N3, and N4. Row index must be relative to 1; column index must be relative to 0.

Examples:

@SUM(@RANGEREF(0, 1, 0, 2)) is equivalent to @SUM(A1..A2)

@AVG(@RANGEREF(1, 1, 25, 10)) is equivalent to @AVG(B1..Z10)


next up previous contents index
Next: RANK Up: A Function Reference Previous: RAND

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