Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone know whether there is a neat way to deal with a formula
whose result may be "error" without using the "iserror" function and effectively having to write the formula twice. For example, the construct I use currently is =IF(ISERROR(my formula),"n/a",my formula). This requires me to enter my formula twice which is redundant. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
it is painful but you can use a shortened version of long formulas to test
for error I am sure you are aware you can cut and paste in the formula bar,not so painful then -- paul remove nospam for email addy! " wrote: Does anyone know whether there is a neat way to deal with a formula whose result may be "error" without using the "iserror" function and effectively having to write the formula twice. For example, the construct I use currently is =IF(ISERROR(my formula),"n/a",my formula). This requires me to enter my formula twice which is redundant. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On 19 Mar 2006 01:37:45 -0800, "
wrote: Does anyone know whether there is a neat way to deal with a formula whose result may be "error" without using the "iserror" function and effectively having to write the formula twice. For example, the construct I use currently is =IF(ISERROR(my formula),"n/a",my formula). This requires me to enter my formula twice which is redundant. It depends on what you want to happen if there is an error. If you just want to hide the error message, you could use conditional formatting and format the font the same as the background color if the cell contains an error (Formula Is: =iserr(cell_ref) Sometimes, if you understand why there is an error result, you can simplify the formula. For example, you might be able to test just for the presence of a single value in a single cell, rather than repeat the entire formula. --ron |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
MS has heard you.
http://blogs.msdn.com/excel/search.aspx?q=iferror&p=1 " wrote: Does anyone know whether there is a neat way to deal with a formula whose result may be "error" without using the "iserror" function and effectively having to write the formula twice. For example, the construct I use currently is =IF(ISERROR(my formula),"n/a",my formula). This requires me to enter my formula twice which is redundant. -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Dave, yes, it does seem that MSFT is onto this in XL12. Hope it
will convert all my existing double-barrelled ISERROR formulae into nice neat IFERROR formulae. What do you think the chances are? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I wouldn't guess that existing =if(iserror(),"",()) would be converted. But
that's just my guess. But you could post a question on that blog. " wrote: Thanks Dave, yes, it does seem that MSFT is onto this in XL12. Hope it will convert all my existing double-barrelled ISERROR formulae into nice neat IFERROR formulae. What do you think the chances are? -- Dave Peterson |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
None, because ISERROR will still be around.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... Thanks Dave, yes, it does seem that MSFT is onto this in XL12. Hope it will convert all my existing double-barrelled ISERROR formulae into nice neat IFERROR formulae. What do you think the chances are? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot Open Excel getting error: EXCEL.exe has generated errors .. | Excel Discussion (Misc queries) | |||
Shared sheet errors | Excel Discussion (Misc queries) | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Errors accessing shared speadsheet. | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |