Calling out an empty cell in an IF statement

  • Thread starter Thread starter Mark S
  • Start date Start date
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?
 
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
 
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
 
Back
Top