<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody>
</tbody>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
#DIV/0! |
<tbody>
</tbody>
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