View Single Post
  #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