Hi,

If you told us your goal we might be able to give you a better solution.
Why do you want to write it this way?

Although the function is called Address it actually returns a text type not
a reference type result. Therefore would use it with INDIRECT or just try a
different approach.

=IF(INDIRECT("Sheet1!C"&ROW(A3))<"","something"," blank")

and here is a second idea

=IF(OFFSET(Sheet1!A1,2,2)<"","something","blank")


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tiziano" wrote:

I have the following formula:
=if(Sheet1!$c3<"", do something, do something else)
that I would like to re-write as:
=if(address(3,3,2,TRUE,"Sheet1")<"", do something, do something else)

The second formula unfortunately always seems to evaluate to TRUE.

What am I doing wrong?
--
tb