Worked like a charm - thansk to all.

"Sloth" wrote:

=IF(ISNA(formula),0,formula)

replace formula with your formula, or the cell in question. you can also
use the following formula to account for any other type of error (#DIV/0 for
example).

=IF(ISERROR(formula),0,formula)


"Send Object Command - Two attachments" wrote:

I have a vlookup in one column that has results = #N/A

I need to do an if statement, that looks like:
If the field =#N/A, then 0, if not, the field.
Basically, I want to convert all of the #N/A's to a 0 (zero) in another
column....