IF statement to generate nothing

  • Thread starter Thread starter akaka
  • Start date Start date
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.
 
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.
 
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
 
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
 
Back
Top