#### Skudwincell

##### New Member

- Joined
- Mar 5, 2015

- Messages
- 2

I'm currently doing some uni analytics work and I'm trying to make a cell represent the chance of two other cells being mutually exclusive. Is there a way of including the probability of each cell occurring in the formula?

The example is

Year 1:

Low Price: x, 0.4

High Price: y, 0.6

Year 2:

Low Price: a, 0.4

High Price b, 0.6

and so on..

I want a cell to show the answer after assuming the cells are mutually exclusive.

I'm assuming the formula I need to use is P(x) + P somehow?

Any help would be greatly appreciated as this is due soon!