IF statement and "" syntax for leaving cells blank

[ad5184]

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

[Aladin Akyurek]

On 2002-04-10 06:24, ad5184 wrote:
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

Use:


=if(a5>0,a5/2,ISNA())

Aladin

[Mark W.]

=IF(A5>0,A5/2,#N/A)

[ad5184]

Thanks, works a treat.