- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2009 March
- onerror or catch exception/error on Excel?

Subject: | onerror or catch exception/error on Excel? |

Posted by: | Defranco (ericofran…@gmail.com) |

Date: | Wed, 4 Mar 2009 |

Hi,

For years, when I have a calculation that could result in error I do

something like:

=if(iserr(A1/B1),C1, A1/B1)

So in case of A1/B1 result in some error, it will show C1 - it is a

nice solution for formula error management but there is a little

problem: I need to paste twice the formula (in this case "A1/B1" )...

one for testing and another for displaying the result - this is not

nice for long formulas.

Is possible to have some kind of "onerror()" or try() in Excel for

example it would be something like this:

=onerror(A1/B1, C1)

it would be very simple: in case of not generating an error it would

display A1/B1 result directly, but in case of error it would result

C1.

I'm asking about a single cell formula and A1/B1 is just an example (I

Know that I could test if B1=0 to avoid error, but this is just a

small example).

Sorry if this idea sounds stupids... I just want to know if I'm doing

the correct way for the last years (pasting the same formula twice

inside a single cell).

kind regards

defranco

- Re: onerror or catch exception/error on Excel? posted by Bernie Deitrick on Wed, 4 Mar 2009