The Gnumeric Manual
Prev |  | Next

# ADDRESS

## Name

ADDRESS --

## Synopsis

    ADDRESS(row_num,col_num[,abs_num,a1,text])

## Description

ADDRESS returns a cell address as text for specified row and column numbers.

If @abs_num is 1 or omitted, ADDRESS returns absolute reference. If @abs_num is 2 ADDRESS returns absolute row and relative column. If @abs_num is 3 ADDRESS returns relative row and absolute column. If @abs_num is 4 ADDRESS returns relative reference. If @abs_num is greater than 4 ADDRESS returns #VALUE! error.

@a1 is a logical value that specifies the reference style. If @a1 is TRUE or omitted, ADDRESS returns an A1-style reference, i.e. $D$4. Otherwise ADDRESS returns an R1C1-style reference, i.e. R4C4.

@text specifies the name of the worksheet to be used as the external reference.

If @row_num or @col_num is less than one, ADDRESS returns #VALUE! error.

## Examples

ADDRESS(5,4) equals "$D$5".

ADDRESS(5,4,4) equals "D5".

ADDRESS(5,4,3,FALSE) equals "R[5]C4".

## See also

Prev | Home | Next
ACOSH | Up | AMORDEGRC