Address in IF formula.. doens work..
 

Hi.
I´ve made the following formula but it doesn´t assume the
values in the address formula..... why?

=IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"")

A1=Sheet2!

Thanks a lot
SpeeD

Address in IF formula.. doens work..
 

Address returns a string. If you want to reference a cell with the result,
would use the result with indirect.
If A1 contains Sheet2!, it should only contain Sheet2 with out an
exclamation point

=if(Indirect(Address(row(),Column(),,,A1)) < "", column(),"")

Change the , to ; if that is your regional list separator.

--
Regards,
Tom Ogilvy


"SpeeD72" wrote in message
...
Hi.
I´ve made the following formula but it doesn´t assume the
values in the address formula..... why?

=IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"")

A1=Sheet2!

Thanks a lot
SpeeD

Address in IF formula.. doens work..
 

What are you trying to do? Even if you change your semicolons to
commas, the test will always evaluate as true.

SpeeD72 wrote:

Hi.
I´ve made the following formula but it doesn´t assume the
values in the address formula..... why?

=IF((ADDRESS((ROW());(COLUMN());;;A1))<"";COLUMN( );"")

A1=Sheet2!

Thanks a lot
SpeeD