View Single Post
  #1   Report Post  
Sam
 
Posts: n/a
Default C1 appears blank, but ISBLANK(c1) returns false

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