You can use ISNA to suppress #N/A errors... use it like this
=IF(ISNA(your_formula),"",your_formula)

ISNA returns true if the formula within ISNA returns #N/A

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"PaulinaDi" wrote:

I'm using a formula to bring results from another worksheet but in some cases
I get the #N/A result as I don´t have data on the original worksheet. To get
the graphics on the final worksheet I use the formula with NA() not to give
me 0 values on the chart and I also use the conditional formula to get the
#N/A results just like the cells were empty (the same color I use for that
cell) but when I print my page, I get the #N/A in black (so I can see them)
and additional I'm not able to get a SUM or AVERAGE on each column as I get
the #N/A for those cells with that mark.

Two examples of the formula I'm using a

=IF(SUMPRODUCT(--('2009'!$B$8:$B$256=$O14),--('2009'!$B$8:$B$256<$O15))=0,NA(),SUMPRODUCT(--('2009'!$B$8:$B$256=$O14),--('2009'!$B$8:$B$256<$O15),('2009'!E$8:E$256))/SUMPRODUCT(--('2009'!$B$8:$B$256=$O14),--('2009'!$B$8:$B$256<$O15)))

=IF(L9/L8-1=0,NA(),L9/L8-1)

How may I get the SUM or the AVERAGE for that column and how may I print my
file without seeing the #N/A's in black?