I have designed a template to record tenpin bowling scores but I need a
formula to automatically calculate the scores (taking into account the rules
for spares and strikes). Does any one have such a formula that I can insert
into my template?

Hi, here's one approach:

Let row 1 house your pins made per ball, such that cells A1&B1 are your
first and (if no strike on the first ball) second ball and equal Frame 1. In
a like manner, let C1&D1 equal Frame 2, E1&F1 equal Frame 3, ... , S1&T1
equal Frame 10. Let U1&V1 be the bonus balls for strike/spare possibilities
in Frame 10.

Then enter your score formulas in row 2. For cell A2 enter:

=IF((A1+C1)=20,A1+C1+E1,IF(A1=10,A1+C1+D1,IF((A1+B 1)=10,A1+B1+C1,A1+B1)))

In cell C2 enter:

=A2+IF((C1+E1)=20,C1+E1+G1,IF(C1=10,C1+E1+F1,IF((C 1+D1)=10,C1+D1+E1,C1+D1)))

Copy cell C2 to E2, G2, I2, K2, M2, O2, and Q2.

Finally, In cell S2 enter:

=Q2+IF((S1+U1)=20,S1+U1+V1,IF(S1=10,S1+U1+V1,IF((S 1+T1)=10,S1+T1+U1,S1+T1)))

Of course, all this presupposes that you enter pins made correctly; that is,
A1+B1 <= 10, C1+D1 <=10, etc. Finally, insert a header row that labels Frame
1, Frame 2, etc., and your formulas will adjust appropriately.

or download a template from this link
http://bowling.rreynolds.net/tools/b...rd-spreadsheet

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"BrianEBest" wrote:

I have designed a template to record tenpin bowling scores but I need a
formula to automatically calculate the scores (taking into account the rules
for spares and strikes). Does any one have such a formula that I can insert
into my template?