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-