Manuals/calci/ADDRESS

From ZCubes Wiki
Revision as of 06:06, 12 November 2013 by Abin (talk | contribs) (→‎Description)
Jump to navigation Jump to search


Description

This function generates a cell address as text, given specified row and column numbers. ADDRESS(RN,CN,AN,A1,CText) where RN is the row number ,CN is the column number to use in the cell reference. AN specifies the type of reference to return.

AN Types of reference
1 or omitted Absolute
2 Absolute row,relative column
3 Relative row,absolute column
4 Relative


A1   is a logical value

CText  is text specifying the name of the calcisheet to be used as the external reference.