Microsoft KB Archive/74390

{| = ADDRESS Function Incorrect in Excel Documentation =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q74390

SUMMARY
Page 7 of the &quot;Microsoft Excel Function Reference&quot; shows five examples for the ADDRESS function. The first three examples are correct. However, the last two examples show incorrect return values.

The following five examples contain the correct information:

ADDRESS(2,3) equals &quot;$C$2&quot;

ADDRESS(2,3,2) equals &quot;C$2&quot;

ADDRESS(2,3,2,FALSE) equals &quot;R2C[3]&quot;

ADDRESS(2,3,2,FALSE,&quot;SHEET1.XLS&quot;) equals &quot;SHEET1.XLS!R2C[3]&quot;

ADDRESS(2,3,2,FALSE,&quot;EXCEL SHEET&quot;) equals &quot;'EXCEL SHEET'!R2C[3]&quot; Note also that the last example uses the name &quot;Excel Sheet&quot; as the name of a worksheet; this name is only valid under OS/2 with HPFS installed.