.. 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.