Hey Roger,

Try this:

=IF(ISNUMBER(C9),B9+C9,IF(C9="/",IF(E9="X",20,IF(ISNUMBER(D9),10+D9,"")),IF(C9="X ",IF(E9="X",IF(G9="X",30,IF(ISNUMBER(F9),20+F9,"") ),IF(E9="/",20,IF(ISNUMBER(E9),10+D9+E9,""))),"")))


On Thu, 13 Oct 2005 20:01:44 GMT, "Roger King"
wrote:

Hi,
I'm taking a class in "basic" excel and one of the projects is to program a
spreadsheet to score a bowling game. Am doing fine, except...
How do I get excel to check for strikes and spares. I have an IF(AND)
statement in the first frame that looks for strikes in frames 1 thru 3,
enters 30 if true and one frame's value if false. I cannot seem to get excel
to accept the spare character (/) as it is an operator. My plan was to have
this formula in each frame, checking ahead and calculating as data is
entered. I am trying to use one cell per ball, i.e. cell B3 is the first
ball, c3 the second, and so on. The score tallys in B4-C4 merged, D4-E4,etc.
Does any of this make sense? Am I way off base? Seems if this is a "basic"
class, this shouldn't be this complicated. What am I missing?
Thanks in advance for your advise and assistance
-roger-