"DLZ217" wrote...
Can I use an IF function to ignore the #DIV/0 output when making a formula
and if so how and if not what could I use?

You could trap #DIV/0! using

=IF(COUNT(1/(ERROR.TYPE(expression)=2)),"ignore",expression)

but it's generally better to trap the subexpression causing the error, e.g.,
to trap it in averages,

=IF(COUNT(x),AVERAGE(x),"ignore")

and to trap it in denominators,

=IF(N(denominator)<0,numerator/denominator,"ignore")