This worked great, but is it possible to not show the #N/A in the data table?


"Barb Reinhardt" wrote:

Let's say you have an if statement and you only want values greater than one
to be plotted on your graph, use this type of equation

=if(A11,A1,NA())

This was an OLLLD message.

" wrote:

How do you return the formula NA()

"Barb R." wrote:

Have the formula return NA() instead of "".

"Stephan" wrote:

I have several columns with data. In one column I do not have data for every
row. In the line charts, those "zero" values are plotted and connected with
the previous data point. Instead I would rather have a broken line. The
reason seems that I have a formula entered in this field instead on no entry