Short Question:
What can I have the IF statement return as a result that will NOT graph at all. Just leave a hole in the graph.
Long Question:
I have a large range of values and dates.
1/1 1/2 1/3 ....etc
10 11 7 .......etc
8 12 6 .....etc
These values are pulled via VLOOKUP() from various places.
When VLOOKUP finds a blank cell, it returns a '0', which doesn't work for me.
I've added an IF(ISBLANK), to return "", which is (I believe) an empty cell.
The problem is, this is still graphing as a zero. So it will be graphing along nicely, and then shoot down to zero and back up again.
Thanks!
What can I have the IF statement return as a result that will NOT graph at all. Just leave a hole in the graph.
Long Question:
I have a large range of values and dates.
1/1 1/2 1/3 ....etc
10 11 7 .......etc
8 12 6 .....etc
These values are pulled via VLOOKUP() from various places.
When VLOOKUP finds a blank cell, it returns a '0', which doesn't work for me.
I've added an IF(ISBLANK), to return "", which is (I believe) an empty cell.
The problem is, this is still graphing as a zero. So it will be graphing along nicely, and then shoot down to zero and back up again.
Thanks!