software

The outcome of a calaculation in my excel worksheet is #deel/0! ( in Dutch ).
I want to make the calculation and were it says #deel/0! i want to replace it
by another value.

Can you help me how to do this in Excel

I'm not familiar with Dutch, but something like this should work:

=if(iserror(CALCULATION),VALUE,CALCULATION)

Replace CALCULATION with whatever your calculation is and replace VALUE with
whatever you want to display if the result of your calculation is an error.

HTH,
Elkar

quot;Mennoquot; wrote:

gt; The outcome of a calaculation in my excel worksheet is #deel/0! ( in Dutch ).
gt; I want to make the calculation and were it says #deel/0! i want to replace it
gt; by another value.
gt;
gt; Can you help me how to do this in Excel