Hi,

The answer is because Microsoft programmed it that way.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"tomj" wrote:

if(cell="","",cellvalue)

Here, if logic determines that a cell is empty, the cell will be empty but
the plot will show zero for the cell.

if(cell="",na(),cellvalue)
Here, if logic determines an empty cell the cell will be shown as #n/a, but
the point will be a non-plot.

How can one statement cause an empty cell but show as non-plot?