I have a function that divides two numbers, sometimes those numbers
are 0 so the result is # DIV/0!. My second function is based on the
result of the first function. Since there isnt always data available
for the first function I get the # DIV/0! error and my final
calculation wont calculate. I need the final calculation to disregard
any 0 cells or # DIV/0! errors and still calculate the data that is
available.
Here's one way.
Suppose the first function is in A1.
Then for the second function, you could put something like:
=IF(ISERROR(A1),"N/A", <your second function here )
|