How do I convert functions that are zero into a null ?

N

Nick

I have a sales worksheet that totals monthly from January thru December.

I plot the summary sales by month in a simple line chart.

The problem is that since the year is not completed, the line chart drops
off to zero for the month that total zero which makes it look like a sales
decline. I would like to make it just stop plotting at the last month with
sales.

I can do this manually by deleting the totals for each month but I would
prefer to use some kind of an "IF" statement and a "NULL" value but am unable
to find the correct mix.

Any ideas ? Thanks In advance. Nick.
 
P

Peo Sjoblom

To get the equivalent of a null value in a chart you can use

=IF(cell=0,NA(),cell)



Regards,

Peo Sjoblom
 
N

Nick

This worked great

Also, how can I test for a cell with an NA or #N/A value with an IF function ?
 
N

Nick

Once again, thanks for your fast and accurate answer

In regards to my reply about the ISNA() function, please ignore ... I was
using the incorrect syntax.

Best Regards,
Nick
 
Top