This copies the formula to all the selected cells. As an example, if you had data in cells A1 through A100, drag the lower right corner of B1 down to B100 to copy the formula to all 100 cells.

Compound Probability Formulas There are different formulas for calculating the two types of compound events: Say A and B are two events, then for mutually exclusive events: P (A or B) = P (A) + P (B).