How to Stop #DIV/0! from showing

[posfog]

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 82"]
<tbody>[TR]
[TD="class: xl66, width: 82, align: center"]#DIV/0![/TD]
[/TR]
</tbody>[/TABLE]
Morning All,
I have a number of different formulas within a work book which look at a data set which sometimes shows zero's or no information, So as you would expect the formula's bring back #DIV/0!

Is there a way that the formulas could infact then show nothing or a single zero and not the #DIV/0!


Here is examples of the formulas in question

=ABS(SUM($R$8/$R$15)-100%)
=VLOOKUP($R$4,'Off Load Data'!$A:$D,3,FALSE)


Kind Regards
P

 

[steve the fish]

Why not consider adding up all the errors and dividing by the sum of outputs for a true average.

 

[posfog]

needs to show each day as a separate percentage along with then a weekly one