How can Excel make a cell empty without making it na()?
 

I want to preserve the "empty" status of cells from one sheet to another so
that when they are plotted or averaged they behave correctly. For example,
the initial sheet has some values that are not declared (read as ",,," in a
CSV file). A second sheet is used to assemble parts of the first sheet for
analysis and uses "paste link". However, "paste link" makes empty cells from
the first sheet into zeros on the second. I can use an IF() to test for zero
(but not empty?) and then make them either "" or na(). However, making them
"" is fine for average() but not good for a chart, which assumes they are
zero. Making them NA() is good for charts but no good for average(). Is there
a function that simply replicates the keystroke of 'delete'?

How can Excel make a cell empty without making it na()?
 

Nel post
*Bruce* ha scritto:

I want to preserve the "empty" status of cells from one sheet to
another so that when they are plotted or averaged they behave
correctly. For example, the initial sheet has some values that are
not declared (read as ",,," in a CSV file). A second sheet is used to
assemble parts of the first sheet for analysis and uses "paste link".
However, "paste link" makes empty cells from the first sheet into
zeros on the second. I can use an IF() to test for zero (but not
empty?) and then make them either "" or na(). However, making them ""
is fine for average() but not good for a chart, which assumes they
are zero. Making them NA() is good for charts but no good for
average(). Is there a function that simply replicates the keystroke
of 'delete'?

Maybe you can make two linked copy, the first with "" for average and the
secnd with na for chart.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy