Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Rename Excel Sheets in Workbook | Excel Worksheet Functions | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel |