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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top