software

Does anyone know whether there is a neat way to deal with a formula
whose result may be quot;errorquot; without using the quot;iserrorquot; function and
effectively having to write the formula twice. For example, the
construct I use currently is =IF(ISERROR(my formula),quot;n/aquot;,my formula).
This requires me to enter my formula twice which is redundant.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!
quot; wrote:

gt; Does anyone know whether there is a neat way to deal with a formula
gt; whose result may be quot;errorquot; without using the quot;iserrorquot; function and
gt; effectively having to write the formula twice. For example, the
gt; construct I use currently is =IF(ISERROR(my formula),quot;n/aquot;,my formula).
gt; This requires me to enter my formula twice which is redundant.
gt;
gt;

On 19 Mar 2006 01:37:45 -0800, quot; gt;
wrote:

gt;Does anyone know whether there is a neat way to deal with a formula
gt;whose result may be quot;errorquot; without using the quot;iserrorquot; function and
gt;effectively having to write the formula twice. For example, the
gt;construct I use currently is =IF(ISERROR(my formula),quot;n/aquot;,my formula).
gt; 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

MS has heard you.

blogs.msdn.com/excel/search.aspx?q=iferroramp;p=1
quot; wrote:
gt;
gt; Does anyone know whether there is a neat way to deal with a formula
gt; whose result may be quot;errorquot; without using the quot;iserrorquot; function and
gt; effectively having to write the formula twice. For example, the
gt; construct I use currently is =IF(ISERROR(my formula),quot;n/aquot;,my formula).
gt; This requires me to enter my formula twice which is redundant.

--

Dave Peterson

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?I wouldn't guess that existing =if(iserror(),quot;quot;,()) would be converted. But
that's just my guess.

But you could post a question on that blog.

quot; wrote:
gt;
gt; Thanks Dave, yes, it does seem that MSFT is onto this in XL12. Hope it
gt; will convert all my existing double-barrelled ISERROR formulae into
gt; nice neat IFERROR formulae. What do you think the chances are?

--

Dave Peterson

None, because ISERROR will still be around.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

gt; wrote in message oups.com...
gt; Thanks Dave, yes, it does seem that MSFT is onto this in XL12. Hope it
gt; will convert all my existing double-barrelled ISERROR formulae into
gt; nice neat IFERROR formulae. What do you think the chances are?
gt;