I would like a formula modified to avoid getting divide by zero errors. The formula was kindly provided by a member yesterday however
since using on a new spreadsheet containing zeros it throws up the errors.
Please refer to attached spreadsheet The zero is highlighted Sum-Probabilities-to-one-V2.xlsx
in cell B17