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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Keyrookie" wrote:

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 ....