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
|