Div by zero

Helen Wills

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

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,820
Office Version
  1. 365
Platform
  1. Windows
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,837
Messages
5,766,721
Members
425,373
Latest member
ndiejennrrd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top