Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions |