Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Spreadsheet for bowling games?
I'm trying to keep track of a league's scores, but would like to keep the
frame-by-frame scores as well. I don't know how to get the correct logic to work for the entire game (mainly because I know very little about Excel), but have found an example that works up until the last frame. Then it only works if you happen to get a spare or strike in the 10th frame, otherwise there's a #NAME error. The code looks like this for the 10th frame only: =IF(V4="X",IF(W4="X",IF(X4="X",T5+30,IF(ISNUMBER(X 4),T5+20+X4,"")),IF(ISNUMBER(W4),IF(X4="X",T5+20+W 4,IF(ISNUMBER(X4),T5+10+W4+X4,"")),"")),IF(ISNUMBE R(V4),IF(W4="/",IF(X4="X",T5+20,IF(ISNUMBER(X4),T5+10+X4,"")),is (ISNUMBER(W4),T5+V4+W4,"")))) Since I know so little about Excel logic, I can't tell where the hang up is. Any help would be greatly appreciated! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Spreadsheet for bowling games?
Where exactly is the data, the ten (12?) values?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LizandraT" wrote in message ... I'm trying to keep track of a league's scores, but would like to keep the frame-by-frame scores as well. I don't know how to get the correct logic to work for the entire game (mainly because I know very little about Excel), but have found an example that works up until the last frame. Then it only works if you happen to get a spare or strike in the 10th frame, otherwise there's a #NAME error. The code looks like this for the 10th frame only: =IF(V4="X",IF(W4="X",IF(X4="X",T5+30,IF(ISNUMBER(X 4),T5+20+X4,"")),IF(ISNUMBER(W4),IF(X4="X",T5+20+W 4,IF(ISNUMBER(X4),T5+10+W4+X4,"")),"")),IF(ISNUMBE R(V4),IF(W4="/",IF(X4="X",T5+20,IF(ISNUMBER(X4),T5+10+X4,"")),is (ISNUMBER(W4),T5+V4+W4,"")))) Since I know so little about Excel logic, I can't tell where the hang up is. Any help would be greatly appreciated! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Spreadsheet for bowling games?
I got it worked out. Apparently the "is" at the end should have been an "IF".
Thanks anyway! "Bob Phillips" wrote: Where exactly is the data, the ten (12?) values? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LizandraT" wrote in message ... I'm trying to keep track of a league's scores, but would like to keep the frame-by-frame scores as well. I don't know how to get the correct logic to work for the entire game (mainly because I know very little about Excel), but have found an example that works up until the last frame. Then it only works if you happen to get a spare or strike in the 10th frame, otherwise there's a #NAME error. The code looks like this for the 10th frame only: =IF(V4="X",IF(W4="X",IF(X4="X",T5+30,IF(ISNUMBER(X 4),T5+20+X4,"")),IF(ISNUMBER(W4),IF(X4="X",T5+20+W 4,IF(ISNUMBER(X4),T5+10+W4+X4,"")),"")),IF(ISNUMBE R(V4),IF(W4="/",IF(X4="X",T5+20,IF(ISNUMBER(X4),T5+10+X4,"")),is (ISNUMBER(W4),T5+V4+W4,"")))) Since I know so little about Excel logic, I can't tell where the hang up is. Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet for bowling games? | Excel Worksheet Functions | |||
games on Excel | Excel Discussion (Misc queries) | |||
Games | Excel Discussion (Misc queries) | |||
Bowling Game | Excel Worksheet Functions | |||
Need help with two Bowling Formulas | Excel Worksheet Functions |