G
Guest
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
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