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

that I would like to re-write as:
=if(address(3,3,2,TRUE,"Sheet1")<"", do something, do something else)

WHY?

If you want that way then try like this:

=IF(INDIRECT(ADDRESS(3,3,2,TRUE,"Sheet1"))<"","do something","do something
else")


"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

on 7/9/2009 9:04 PM Teethless mama wrote the following:
that I would like to re-write as:
=if(address(3,3,2,TRUE,"Sheet1")<"", do something, do something else)

WHY?

If you want that way then try like this:

=IF(INDIRECT(ADDRESS(3,3,2,TRUE,"Sheet1"))<"","do something","do something
else")


"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


Thanks for your suggestion!

You want to know why... Well, the original formula (located on Sheet2
and copied all the way down from A3 to A5000) is linked to a spreadsheet
located on Sheet1. Unfortunately, every time that I delete a row from
Sheet1, I get the dreaded #REF!. So, I am simply trying to find a way
to get around this problem by re-writing my formula as the deletion of
rows on Sheet1 is unavoidable...

If anybody has a better solution...
--
tb

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