LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"False" filling in the blank spaces Dave O. Excel Discussion (Misc queries) 1 April 17th 05 05:25 PM
Grouped Sheets and Formating Pank Mehta Excel Discussion (Misc queries) 3 March 24th 05 01:42 AM
Vlookup finds a blank, but returns a zero - HELP! flummoxed Excel Discussion (Misc queries) 6 January 18th 05 03:15 PM
Grand Totals @ Same Place Amber M Excel Worksheet Functions 2 December 30th 04 07:13 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"