On Sunday 20 November 2005 10:49, David Chapman wrote: > The indirect, address functions working good for me - also on 2.0 > > Here is my test sheet... > > http://www.openofficetips.com/downloads/indirect.ods > > I can't see what is wrong with your attached examples - I tried to break > OOo but failed. > > Feel free to email me your prob sheet . > > Dave > The crux of the problem appears to be ...
THE HELP PAGE ...................................................... Syntax ADDRESS(row; column; abs;sheet) row represents the row number for the cell reference column represents the column number for the cell reference (the number, not the letter) abs determines the type of reference: 1: absolute ($A$1) 2: row reference type is absolute; column reference is relative (A$1) 3: row (relative); column (absolute) ($A1) 4: relative (A1) sheet represents the name of the sheet. It must be placed in double quotes. Example: ADDRESS(1; 1; 2; "Sheet2") returns the following: Sheet2.A$1 If the cell A1 in sheet 2 contains the value -6, you can refer indirectly to the referenced cell using a function in B2 by entering =ABS(INDIRECT(B2)). The result is the absolute value of the cell reference specified in B2, which in this case is 6. MY RESULT ................................................................ =ADDRESS(1; 1; 2; "Sheet2") gives a result of .. Err:502 & yep there is a 'Sheet2' Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
