Rectangle Box

  • Thread starter Thread starter Keyrookie
  • Start date Start date
K

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