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.

.. if(dateok,formula result,"")

Untested, but you could tinker, indicatively like this:
... if(dateok,if(ISNA(<formula),NA(),<formula),NA())
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"akaka" wrote:
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.

"Max" wrote:

.. if(dateok,formula result,"")

Untested, but you could tinker, indicatively like this:
.. if(dateok,if(ISNA(<formula),NA(),<formula),NA())
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"akaka" wrote:
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.

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

On Dec 3, 12:09*am, akaka wrote:
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.



"Max" wrote:
.. if(dateok,formula result,"")

Untested, but you could tinker, indicatively like this:
.. if(dateok,if(ISNA(<formula),NA(),<formula),NA())
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"akaka" wrote:
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.- Hide quoted text -

- Show quoted text -

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

"akaka" wrote:

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.