using if iserror on aonther sheet

[NathanG]

Hi,

I need to check all the cells in a spreadsheet for error such as #div/0!. I
am using iserror to supress the error as a 0 or to display the value of the
cell if its correct.

The problem is that if the value I am looking at is a2 and I put the formula
in a3, a3 will display a value. Here is my formula

=IF(ISERROR(A2),0,A2)

Is there a way of putting the iserrors on another sheet? I thogutht the
formula would be along the lines of

=financial!if(iserror(a2),0,a2) but that doesn't work.

Can it be done? I want to hide to result of the iserror

Thanks

Nathan

 

[Dave Peterson]

=if(iserror('financial'!a2),0,'financial'!a2)

The apostrophes may not be required with all worksheet names--if they're not,
excel will remove them.

 

[Max]

=IF(ISERROR(A2),0,A2)

Is there a way of putting the iserrors on another sheet? ..

Maybe you mean, in say A1 in Sheet2:
=IF(ISERROR(Sheet1!A2),0,Sheet1!A2)