showing blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spredsheet that uses formulas to calculate percentages. Info is
added throughout the month so some cells with formulas that have not yet been
used show -100%. These false numbers naturally go to the graph page. How
can I eliminate a calculation in unused cells where there is a formula that
doesn't yet have numbers to work with?
 
Steve K wrote...
I have a spredsheet that uses formulas to calculate percentages. Info is
added throughout the month so some cells with formulas that have not yet
been
used show -100%. These false numbers naturally go to the graph page. How
can I eliminate a calculation in unused cells where there is a formula
that
doesn't yet have numbers to work with?
Click to expand...

Hi Steve K,

One way,

=If(your_formula=-100%,"", your_formula)

Regards,
Kevin
 
You must log in or register to reply here.

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

Similar Threads

How To Have A Cell Be Blank If... 2
Excel formula, sum the value cell and if empty cell left blank 0
display value as % in concantenated cell 4
Excel Sumproduct 0
Conditional Formatting with Calculated Blank 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Displaying cell contents 3
Conditional formatting 2

Back
Top