Div by zero

[Helen Wills]

I know that mathematically, dividing by zero is not possible BUT I am trying to shop an uplift against a zero target
i.e. a group of stores were to receive 0 orders (h9) but they mistakenly received 154,817 orders (BG9)
stores have been staffed against a target of zero orders, but instead had to process 154,817 orders. Formula used is =BG9/h9-1. Formula works for groups of stores that did have a target, but not for those who did not - excel is returning the #DIV/0! error.

How can i override this ?

 

[Joe4]

What do you want returned in these cases?

You can use the IFERROR function to handle it.
If you wanted to return 0, you could do:
=IFERROR(your formula,0)+0