Helen Wills
New Member
- Joined
- Nov 14, 2014
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
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 ?
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 ?