If the CountA returns zero then the result will be zero This makes a difference when doing some calculations. If you want to return nothing don't use " " with a space. I can clarify if I am confusing (basically if there is no scoring above, I am getting zeros below)Ĭan you have negative points? If not then there is no need for the IF. See what you think so far? How do i rid the zeros from showing up? Here are my issues: I want to keep cells blank until someone gets to 100, and I am not sure my logic is working correctly there also may be more effecient ways of doing this without Going VBA (thats my last book after Arrays next) The total tally of the points, box bonus, game or shutout bonus gets scored and the difference is made and kept track of (I havent even tackled this yet) Winner of the round gets 100 point "game bonus" unless the other player wins no games then 200 (shutout bonus) My Daughter and I have been playing Gin Rummy, and wanted to see if I could build a score sheet that would tally up the scores.Įach round consists of one to usually several "boxes"Įach player gets 20 or 25 (house rules we use 25) points for each "box" won I am just learing Excel, and have been reading Slaying Excel Dragons, I am about 1/3 thru and trying to apply a bit of what I have learned
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |