Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"False" filling in the blank spaces | Excel Discussion (Misc queries) | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |