Rectangle Box

[Keyrookie]

Hey all,

I have several boxes that equal cells with formulas. They all sho
blank ( I have them formatted as no background and no lines) when ther
are no results in their associated cells. However, when even just 1 o
the boxes has a referenced cell return a formula, they all show
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 th
correct data, BUT, rectangle 42 displays 0 ....

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

Help please ...

 

[Max]

Presume you are linking rectangles (shapes) to formula cells

Try amending the formulas in the linked formula cells so that these return
blanks: "" instead of zeros. Some examples:
Use: =IF(F2="","",F2) instead of: =F2
Use: =IF(yourformula=0,"",yourformula) instead of: =your formula