Calling out an empty cell in an IF statement

M

Mark S

In using an IF statement the "else" value needs to be a
blank cell.=IF(B2 > 10, 'Nov 03'!F72, "") The values are
being charted on a line graph and when 0 or "" are used
the chart shows them as 0 values. When there is no value
I would like them not to appear on the chart at all. Any
ideas?
 
H

Henry

Mark,

Just a suggestion, not certain that it'll work but,
try replacing "" with a reference to a cell you *know* contains nothing.
eg IF(B2 > 10, 'Nov 03'!F72, IV1) or IF(B2 > 10, 'Nov 03'!F72, A65535)

HTH
Henry
 
P

pfsardella

If your goal is to eliminate the value showing in the chart, use NA()
instead of "".

=IF(B2 > 10, 'Nov 03'!F72, NA())

HTH
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an "Empty" Cell 1
Blank Values in Excel Charts 7
Report data from cell if dates match 2
Making a cell empty 3
IF statement to generate nothing 4
Empty content after a calculation 4
Three possible outputs from an if statement. 3
Return an empty cell 2

Top