IF statement to generate nothing

A

akaka

I have created a table that checks the date via an if statement, and if the
date is ok, then it returns the result of a formula. If the date is not ok,
then it should return nothing.
The formula I currently have is if(dateok,formula result,"").
When I chart the results, the values are 0. I have also tried #N/A, but the
chart includes the #N/A as value labels.
I would like to know if there is anything I can put at the end of the IF
statement to get the chart to not include anything, ie the same result as if
I completely delete the formula.
Thanks.
 
A

akaka

Thanks Max.
The formula is working fine. It's only the false condition on the IF
statement I am trying to tinker with.
When charted, "" (or any other text) charts as 0, and NA() gives the value
lable of #N/A. I would like nothing to appear in my chart.
 
P

Pete_UK

You could apply a filter to the column containing your values -
custom, does not equal, #N/A, to temporarily hide those error values,
then the chart should adjust automatically.

Hope this helps.

Pete
 
S

Shane Devenshire

Hi,

If you have formulas you can return "" or NA but these will still be plotted
as 0 on the chart, so if you are charting a line chart there is no easy
solution.

Cheers,
Shane Devenshire
 
Top