I want to use an 'if' statement on a list of values to then create another column of vlaues from which a graph is drawn. If the 'if' statement is not satisfied then I want to leave the cell blank. I can do this but the problem is that Excel treats the blank as a zero and plots it. The syntax I'm using is =if(a5>0,a5/2,"") - it's the "" that I probably need to replace so that the graph doesn't plot a zero although trying text also doesn't work