CELLREF(N1, N2)

 

Description

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

 

Parameters

 

N1

A numeric value.

 

N2

A numeric value.

 

Examples

 

CELLREF(3, 1) = -80

Where D1 = -80.

 

CELLREF(27, 34) = 2400

Where AA34 = 2400.

 

CELLREF(4, 8) = 100.00

Where E8 = 100.00.