In case no one believes me :)
B C
1
2
Foo
3 Foo =INDIRECT("C2")
4 Foo.$C$2 =ADDRESS( 2;3;1;"Foo")
5 42 =INDIRECT("Foo.C2")
6 42 =INDIRECT(B4)
7 42 =INDIRECT(ADDRESS(2;3;1;"Foo"))
8 42 =INDIRECT(ADDRESS(2;3;1;INDIRECT("C2")))
On 11/20/05, dave s <[EMAIL PROTECTED]> wrote:
>
> 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]
>
>
--
My OpenOffice Calc Website
http://www.openofficetips.com
