Data points showing for empty cells?

[hmmm...]

When I populate a worksheet column sparsely (leaving many cells blank), and
then create a line chart of the data, the null cells do not create data
points. This is what I want to happen.

However, if I want to populate the column (e.g. D) based on the existence of
values in corresponding cells in another column (e.g. C), using the
following formula in D:

=IF(C1<>"",SUM($C1+100) ,"")

the cells that are empty now create data points in the chart. Apparently ""
is not the same as an empty cell.

How can I perform my calculation in D, based on the existence of values in
corresponding cells of C, and leave empty cells in D that will not show up
as data points in my line chart.

I'm using Office 97. Thanks!

 

[Andy Brown]

"hmmm...",

Try =IF(C1<>"",SUM($C1+100),#N/A)

instead.

Rgds,
Andy

 

[hmmm...]

Thanks. I also test the contents of these cells later in VBA. If a cell is
set to #N/A, how do I test whether it is empty from VBA?

 

[Andy Brown]

Thanks. I also test the contents of these cells later in VBA. If a cell
is

set to #N/A, how do I test whether it is empty from VBA?

Great -- I don't do code. Maybe this previous response from Dave Peterson
will help.

http://tinyurl.com/hurr

Rgds,
Andy

 

[Jon Peltier]

or =IF(C1<>"",$C1+100,NA())

You don't need to put the small formula inside the SUM function, and you
should specify the #N/A error with NA().

To look for the error, try WorksheetFunction.IsNA(arg)

- Jon