View Single Post
  #2   Report Post  
Kevin H. Stecyk
 
Posts: n/a
Default

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