![]() So my question is, can this be done with a string of formulas, or would I be better solving this problem using VBA? I am fairly new to VBA by the way, but know some basics. It doesn't just matter what number is hit, but when. The object being to close all numbers and have the highest total points.Įach dart for each round is being entered in, and I need two things: counting the number of marks for each player (easy), and using some kinda of if statement to determine if those marks should count for points if the other player hasn't closed that particular number (hard). ![]() Once the second player hits 3 of that number, it is then considered to be 'closed' and no other points can be scored on it. For those who may be unfamiliar with the game - player one aims at certain numbers (20, 19, 18, 17, 16, 15, bullseye) until he hits 3 of them, at which point, that number becomes 'open,' and any additional hit on that number results in points being scored. so B11 could be a simple SUM (B3:B10) (to get total runs scored. B3 - B10) In each cell the runs scored could be 1,2,3,etc. So I have assigned a cell to each ball (e.g. (I appreciate it though) In Indoor - Each over is 8 balls. I wish to make a scoreboard for the game of cricket. Thanks for the reference to 'lucky', however in Indoor Cricket every over is complete so no need for that equation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |