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

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