Ignoring #DIV/0! Errors in Formulas

[Tom L.]

Hello folks!

I can't seem to find any information on ignoring div/0 errors when using formulas. Currently I have a lot of formulas that read from cells which currently have a div/0 error due to another formula. I'd rather make some changes to the formula reading the div/0 errors than change the formulas themselves to change any div/0 errors (using the countif tips given to me on my last post - thanks for the help, once again).

How do you make a formula ignore div/0 errors? If that doesn't work, does that mean I need to change all of my formulas which result in div/0 errors?

Any help would be greatly appreciated.

Examples:
Formula 1: AVERAGE(A1:A50) - results in #DIV/0!
Formula 2: AVERAGE(Formula 1, someothervalue)

 

[Tom L.]

That works! Thank you very much.