how do i create a blank cell in excel using a formula
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
|