Address in IF formula.. doens work..

S

SpeeD72

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
 
T

Tom Ogilvy

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


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
 
J

JWolf

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