LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Susan
 
Posts: n/a
Default "" does not seem to give a Blank cell

Hello!

I have what I thought was going to be a simple problem. I need to produce a
graph of the cumlative result with time; the data is outputted from access as
shown below
A B C
1 Sample_hr Flask 1 Flask 11
2 190.4 0.191433102
3 190.41
4 208.5 0.867723822
5 209.25
6 210
7 379.7
8 379.92
9 380.04 2.498789629


So I wrote the following if statement to add the cell if they contained a
value:

=IF(ISBLANK(B4)=TRUE,"",SUM(B$4:B4))

Which I copied down...so in M9 I've got

=IF(ISBLANK(B9)=TRUE,"",SUM(B$4:B9))

Then I graphed the results - and the cells with "" are graphing as 0; the
result for flask 1 at 210 hour is 0.

Also if I have another cell with =isblank(M9) I get a FALSE

Any suggestions on how to get a true blank cell???

Any help will be greatly appreciated

THANKS

Susan
 
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
Blank (empty) cell always equal to 0?? ulfah Excel Discussion (Misc queries) 3 February 1st 06 04:55 PM
How to get a formula result zero as blank cell Excelerate-nl Excel Discussion (Misc queries) 4 November 22nd 05 04:32 PM
Setting Purely BLANK Cell yokato95 Excel Worksheet Functions 4 August 18th 05 04:43 PM
Replace null string with blank cell gjcase Excel Discussion (Misc queries) 2 August 9th 05 02:13 PM
Look for change next blank cell in Range Nigel Bennett Excel Worksheet Functions 1 March 13th 05 09:45 PM


All times are GMT +1. The time now is 02:51 AM.

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"