This works for #N/A as well as other orrors:

=IF(ISERROR(A1),0,A1)

--
Gary''s Student - gsnu200761


"F.Rosario" wrote:

I have a VLOOKUP that returns a dollar value from another spreadsheet. If an
entry is not found, the cell value becomes #N/A, which affects the summary of
that column. I want to test for the #N/A condition and make it 0, but I
haven't figured out the syntax to compare the value of a cell to #N/A. Any
suggestions?