Note below that we don’t directly loop through the keys, but wrap them in an array statement using @() first (an expression with $() also works), otherwise we will get an error saying that we can’t modify the
The value in B2 matches the value in C2, so the formula returns TRUE. First, enter the formula in cell D2 and then copy it down to other cells by dragging the fill handle to compare columns B and C row by row. The fill handle is a small green square in the bottom right corner o...
Then, copy the formula in C11 to other cells by dragging it down to cell C21. Now, we need to calculate the individual probabilities of the sum of numbers occurring on the rolls. To do that, we need to divide the value of each chance by the total value of chances, which is 36 (6...