Dealing with errors
 

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.

Dealing with errors
 

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.

Dealing with errors
 

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

Dealing with errors
 

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

Dealing with errors
 

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?

Dealing with errors
 

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

Dealing with errors
 

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?