Thread
:
#ref to equal zero
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Pete
Posts: n/a
#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
Reply With Quote