ExcelBanter - #ref to equal zero

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - #ref to equal zero (https://www.excelbanter.com/excel-worksheet-functions/69832-ref-equal-zero.html)

cherrynich

#ref to equal zero

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

Pete

#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

cherrynich

#ref to equal zero

Pete-
You're Awesome.

All times are GMT +1. The time now is 10:08 AM.