Hi

I use Excel 2K too, and I've set up a similar scenario and it works as
expected!
B1 is blank
In A1 I've got "B1"
In A2 I've got =IF(ISBLANK(INDIRECT(A1)),"",INDIRECT(A1))
If anything is in B1, it returns the value, and if B1 is blank it returns a
blank
(My logical test also returns Volatile)

--
Andy.


"Sam" wrote in message
...
Please help:

C388=IF(ISBLANK(INDIRECT(C189)),"",INDIRECT(C189))
When I look at C388, it appears blank. However, when I select
C388 and click "Edit Formula" [I have Excel 2000],
I am told that
Logical test ISBLANK(INDIRECT(C189)) = VOLATILE

When I set BB388=ISBLANK(C388), it returns FALSE. I expected it to return
TRUE,
because C189 evaluates to C1, and C1 is blank, so INDIRECT(C189) should be
blank.

Why does BB388=ISBLANK(C388), returns FALSE? Is there a way to make it to
(correctly) return TRUE?

Thank you