Excel formula question?

Question

I'm making a nice spreadsheet for my Poker Club. We accumulate points each time we play. I have 2 tables in my spreadsheet, one table showing the placement for that weeks game 1st place - 10th place. The second table shows how many points that person earned for each week. Basically I want to put in a formula so I ONLY have to enter in the rankings and the points automatically populate. For instance 1st place gets 12 points, 2nd gets 10, ect... all the way to 6th place. 7th-10th all get "0" points. Any help would be greatly appreciated!!

Where is my error??
=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",)))))))))))))))))))

Answer 1

probably would have been easier to go with vlookup instead of the nested if statement.

you were on the right track.

note: what youve written in top words, and what youve written in the formula are different. on the top you say that 2nd place gets 10, but then in the formula you say 2nd place gets 8. i went with the 2nd gets 10 line. you can just change the numbers to match what you want.

this will get you started. its long so i broke it up into 4 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)))))))

Answer 2

Fix the IF formula by removing the open paren in front of all of the IF's except the first one then you should have only six closed parens at the end. Also remove the quote signs around the values 12, 10, 8, etc. Lastly since Yahoo never shows the complete long formula I don't know what you have so let me say you should only have six IF's and the last one should look like this:
IF(B3=6,2,0))))))
If you use more than 7 IFs Excel won't accept it so the last zero above will take care of 7th - 10th place.

Answer 3

create a 2-column table that contains the rank and points

for each player, use a vlookup formula on the new table

it should look something like this..
=vlookup($B5,$E$1:$F$12,2,FALSE)

*see the source box

(note: vlookup requires the table to be in ascending order. Also, 'FALSE' specifies that the formula should only return an exact match)

Answer 4

Maybe too many nested ifs. Either streamline your formula, or go with a table and do lookups. You'll need a 3rd column, but you can hide the one you don't need to look at.