poker excel game
Excel formula question?
I can make a spreadsheet for my beautiful Poker Club. We earn points every time we play. I have two tables in my spreadsheet, a table showing this week's game: 1 – 10 th place. The second table shows the number of points that the person received for each week. Basically I want to put in a formula, if only I have to go through the ranks and fill points automatically. For example 1st place gets 12 points, second place gets 10, etc. … all the way to 6 th place. Seventh-tenth get all "0" points. Any help would be greatly appreciated! Where is my mistake? = IF (B3 = 1, "12", (IF (B3 = 2 ", 8", (IF (B3 = 3 ", 5", (IF (B3 = 4 ", 3" (IF (B3 = 5 ", 2", (IF (B3 = 6 ", 1", (IF (B3 = 7 "0", (IF (B3 = 8, "0", (IF (B3 = 9 "0" (IF (B3 = 10, "0 ",)))))))))))))))))))
Probably would have been easier to go with the VLOOKUP instead of the if statement. notice that on the right track: nested. what you have written above, and what I wrote in the formula are different. on top which says that 2 nd place gets 10, but the formula that says the second place gets 8. I went with the second line gets 10. just change numbers correspond to what you desired. This will help you get started. time, so I beat him in four lines, or I get the … = IF (B3 = 1.12, + IF (+ B3 = 2, 10, + IF (+ B3 = 3.8, + IF (B3 = + 4.6 + IF (+ B3 = 5.4 + IF (+ B3 = 6.2, + IF (+ B3> 6,0,0 )))))))
Excel Dog Racing
Tags: bookmarks, del.icio.us, poker excel game, video, videos, web2.0