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
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
"Menno" wrote:
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks