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?
Hi Steve K,
One way,
=If(your_formula=-100%,"", your_formula)
Regards,
Kevin
|