Thanks:  0
Likes:  0

# Thread: IF statement and "" syntax for leaving cells blank

1. 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

2. 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())

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

4. Thanks, works a treat.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•