| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.worksheet.functions
|
|||
|
|||
|
Spreadsheet for bowling games?
there's a #NAME error.
...is(ISNUMBER(W4),T5+V4+W4,"")))) I'll bet ya a Coke that "is" is supposed to be IF ! There is a sample bowling file he ftp://members.aol.com/hrlngrv/ -- Biff Microsoft Excel MVP "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.worksheet.functions
|
|||
|
|||
|
Spreadsheet for bowling games?
I guess I owe you a Coke!!! Thank you so much!!!
"T. Valko" wrote: there's a #NAME error. ...is(ISNUMBER(W4),T5+V4+W4,"")))) I'll bet ya a Coke that "is" is supposed to be IF ! There is a sample bowling file he ftp://members.aol.com/hrlngrv/ -- Biff Microsoft Excel MVP "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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Spreadsheet for bowling games?
You're welcome!
-- Biff Microsoft Excel MVP "LizandraT" wrote in message ... I guess I owe you a Coke!!! Thank you so much!!! "T. Valko" wrote: there's a #NAME error. ...is(ISNUMBER(W4),T5+V4+W4,"")))) I'll bet ya a Coke that "is" is supposed to be IF ! There is a sample bowling file he ftp://members.aol.com/hrlngrv/ -- Biff Microsoft Excel MVP "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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Spreadsheet for bowling games?
Ok, I'm trying to make some more adjustments. Would you mind sharing some
more info? Would it be better to take that off-list? Rachel "T. Valko" wrote: You're welcome! -- Biff Microsoft Excel MVP "LizandraT" wrote in message ... I guess I owe you a Coke!!! Thank you so much!!! "T. Valko" wrote: there's a #NAME error. ...is(ISNUMBER(W4),T5+V4+W4,"")))) I'll bet ya a Coke that "is" is supposed to be IF ! There is a sample bowling file he ftp://members.aol.com/hrlngrv/ -- Biff Microsoft Excel MVP "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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Spreadsheet for bowling games?
If you take it off the list, how will anyone else benefit?
|
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Spreadsheet for bowling games?
Hmmm...
Not sure what you mean. -- Biff Microsoft Excel MVP "LizandraT" wrote in message ... Ok, I'm trying to make some more adjustments. Would you mind sharing some more info? Would it be better to take that off-list? Rachel "T. Valko" wrote: You're welcome! -- Biff Microsoft Excel MVP "LizandraT" wrote in message ... I guess I owe you a Coke!!! Thank you so much!!! "T. Valko" wrote: there's a #NAME error. ...is(ISNUMBER(W4),T5+V4+W4,"")))) I'll bet ya a Coke that "is" is supposed to be IF ! There is a sample bowling file he ftp://members.aol.com/hrlngrv/ -- Biff Microsoft Excel MVP "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 | |||
| games on Excel | Excel Discussion (Misc queries) | |||
| Games | Excel Discussion (Misc queries) | |||
| bowling scores | Excel Discussion (Misc queries) | |||
| Bowling Game | Excel Worksheet Functions | |||
| Need help with two Bowling Formulas | Excel Worksheet Functions | |||
Hybrid Mode
