How to suppress the showing of #N/A values?

Hi,

I want to suppress the showing of #N/A values in the Spreadsheet which result from the use of NA() function. The reason that I used the NA() function is that: I need to plot two columns of data as a line chart. I set missing values as NA() so that unwanted horizontal labels are not to be shown.

So I need to find a way to stop showing missing values as #N/A in both the Spreadsheet and the chart.

Do you have an idea?

Post an example formula and instead of #n/a what do u want as error message?

You can apply conditional formatting to the cells and use a formula:

=ISNA(cell_ref)

to turn the foreground colour to white (if on a white background).

Hope this helps.

Pete

Originally Posted by Pete_UK

You can apply conditional formatting to the cells and use a formula:

=ISNA(cell_ref)

to turn the foreground colour to white (if on a white background).

Hope this helps.

Pete

Hi Pete, this is nice approach. I'll apply it in my case.