if i use "" in an IF formula, then it generates a cell which looks empty.
however, when i then use the data series to generate a scatter graph, my
whole series disppears, including the cells which contain numeric data.

is there another way of creating a blank cell through use of a formula?

Thank you

I've heard that the #N/A error works well in this context.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Tosh" wrote in message
...
if i use "" in an IF formula, then it generates a cell which looks empty.
however, when i then use the data series to generate a scatter graph, my
whole series disppears, including the cells which contain numeric data.

is there another way of creating a blank cell through use of a formula?

Thank you