using if iserror on aonther sheet
 

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

using if iserror on aonther sheet
 

=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.

NathanG wrote:

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

using if iserror on aonther sheet
 

=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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NathanG" wrote:
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