showing blank cells

S

Steve K

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?
 
K

Kevin H. Stecyk

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
 
Top