View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default #ref to equal zero

ISERROR traps all errors, ISNA traps only the #N/A error, ISERR traps
all errors except for #N/A. The general form of these would be:

=IF(ISERROR(your_formula), 0, your_formula)

Hope this helps.

Pete