Isblank returns a negative for any cell with an equaition in it even if the
display is blank.
countblank however counts cells with nothing displayed (as long as the
display has not been formatted out)
try for your B388 logic equation
=(countblank(c388)=1)
this will give you a true for a blank appearing C388

"Sam" wrote:

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