Replace #DIV/0 error with zeros
You are getting the error because somewhere you are trying to divide by
zero. What you need to do is to track back to discover where the #DIV/0
error is first being introduced. Your screen shot shows that you are
getting data from columns G, L, Q etc for something that is labelled as
a percentage, so go back to those cells, where you will probably find
something like:
= a / b
to get the percentage. Then you can try my suggestion:
=IF(b=0, 0, a / b)
Hope this helps.
Pete
|