Bunco is played in six rounds. During your turn, you roll three dice. For each dice that matches the Round #, you get 1 point. If you happen to roll three matching dice that do not match the round number, you get 5 points. If you roll three dice that match the round number, you get 21 points. On any turn where you get no points, you then advance to the next round.
5) For now, enter the number 1 in D5.
The formula for the score in D6 is fairly complex. You can break down the rules as follows:
• If B2, D2, and F2 all match, and they match the round number in D5, then you get 21 points.
• Otherwise, if B2, D2, and F2 all match then you get 5 points.
• Otherwise, add one point if B2 matches D5. Add one point if D2 matches D5. Add one point if F2 matches D5.
You will have to nest a couple of IF functions. The syntax of the IF function is: =IF(Some Test, Value if True, Value if False). If the test portions of the IF statements have several conditions that must be met, then you should include all of the conditions as arguments of the AND function.
Our first scoring rule is “If B2, D2, F2, and D5 all match, then 21 points". The AND statement for this is =AND(B2=D2,D2=F2,F2=D5). The IF statement to give 21 points would be =IF(AND(B2=D2,D2= F2,F2=D5),21,___).
The next scoring rule replaces the ___ in the third parameter of the IF function. This scoring rule says that if B2, D2, and F2 match, then you get 5 points. The AND statement would be AND(B2=D2,D2=F2). This portion of the IF statement would be =IF(AND(B2=D2,D2=F2), 5,___).
The final scoring rule says that for any of the dice that match the round number, you get 1 point. This actually requires three new IF functions, added together: IF(B2=D5,1,0)+IF(D2=D5,1,0)+IF(F 2=D5,1,0).