Plotting data from cells with a formula

[mjh1348]

I have created a two tables that provide pieces of data to a third table from which a graph is created to show daily changes. To combine the data I am using the following forumula

=IF(OR(ISBLANK(I10),ISBLANK(I25))," ",H41+I10-I25)

This works well for keeping the cells blank for the days for which the data is not yet entered. However, on the graph the seemingly blank cells are treated as if they are a numeric zero and plot accordingly.

Is there a way to use a formula like the one above which would be represented on the graph as if the cell were truly blank, i.e no data would be graphically represented if the conditions of the formula were not met?


-- removed inline image ---

 

[VoG]

Try

=IF(OR(ISBLANK(I10),ISBLANK(I25)),NA(),H41+I10-I25)

 

[mjh1348]

That worked. A little messier in the table but exactly what I wanted for the graph.

Thanks much.