Hi Ian,

Rather than using #n/a text use the function NA().
=IF(A1100, NA(), A2)

Cheers
Andy

Ian wrote:
I would like to use the IF statement to set a cell to empty so it doesn't
display in a chart.

If a use the "", then the chart plots this as a zero.
E.g.
=IF(A1100, "", A2)

If I use the #n/a, then the cell isn't plotted in the chart as required.
E.g.
=IF(A1100, #n/a, A2)

However, if I then try to use the MAX() or MIN() commands on a cell range
that contains the #n/a, then a #n/a is returned.

So is there either a way of defining a blank (empty) cell or a way of
setting the MAX() and MIN() commands to ignore the #n/a

Thanks in advance


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info