using ISBLANK

[jrtaylor]

I've attached a spreadsheet which is to become a template for multiple reports.

I've tried to generate a graph using the table illustrated in the attached file, but am having difficulty.

Some of the tables will have empty cells. In my reports, an empty cell must not be counted as a zero. But if the empty cell becomes part of a formula using ISBLANK or ISNUMBER, the result is #VALUE!


Any advice?

Thanks.

[Cutter]

In R39 you have:
=IF(ISBLANK(C39),"",C39)+Q39
You are getting #VALUE result in R39 because you are trying to add the result of Q39 (which is "") to the result of the test for ISBLANK() which is also "".

Change the formula in R39 to:
=IF(ISBLANK(C39),"",C39+Q39)
to get blank results.