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-


I don't play ten-pin bowls myself, (only English Crown Green bowls),
so am not familiar with the scoring system. If you'd like to write the
rules for a couple of typical frames, and any special conditions which
might apply in the last frame, then I'll attempt to suggest an Excel
interpretation.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________