Hi Andrew,

=IF(YourCondition,YourValue,=NA())

--
Kind regards,

Niek Otten

<agbiggs@hotmail.com> wrote in message
news:1141058052.551758.200120@j33g2000cwa.googlegroups.com...
> I'm using the IF function to create a column of data which will be
> charted. If the IF criterion isn't satisfied, I'd like it to output a
> blank cell, rather than a zero or some other number, so it won't be
> charted. Is there any way to do this? Thanks,
>
> Andrew
>