how do i create a blank cell in excel using a formula

[Tosh]

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

 

[RagDyeR]

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!
==============================================

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