#ref to equal zero

C

cherrynich

I need a statement to put in an excel cell that basically says in excel
language;
If(cell reference=#ref,0,reference). I know for other errors there are
keywords like "iserror". Please help. Thanks
 
P

Pete

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
 
Top