Excel: Formula to yield a blank that won't be graphed as zero


My data looks like this:

DATE |  DATA | Formula
1998 |  7112 | =IF(B2=9999,"",B2)
1999 |  9999 | 
2000 |  7059 | 7059 
If I copy the formula in C2 on down and graph it out, Excel interprets "" as zero, and not as a blank cell. Is there a way to have a formula produce a result that will be interpreted as Blank? Background: Lots of data bases use a string of nines (9999) to represent missing data.


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of May 02, 2015.


For more resources for Microsoft Excel