My data looks like this:
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.
DATE | DATA | Formula 1998 | 7112 | =IF(B2=9999,"",B2) 1999 | 9999 | 2000 | 7059 | 7059
This question generated 12 answers. To proceed to the answers, click here.
This thread is current as of May 02, 2015.