Hey all,

I have several boxes that equal cells with formulas. They all show blank ( I have them formatted as no background and no lines) when there are no results in their associated cells. However, when even just 1 of the boxes has a referenced cell return a formula, they all show a result, even it it's zero.

eg. Rectangle 41 = Q60
Rectangle 42 = Q61
etc, etc.

When a result is returned in cell Q60, rectrangle 41 displays the correct data, BUT, rectangle 42 displays 0 ....

Why is this happening? Shouldn't the rectangles show results ONLY when there are results to show?

Help please ....