young nut
10-12-2004, 10:42 AM
Hola chicos,
I am trying to put together a spreadsheet for tracking my SNG progress. I know most of the basic forumulas in excel, but there is one forumula I cannot find for the certain use I need.
I am trying to reference a value from a payout table. For example, the payouts for a 5+1 SNG are 1-25 2-15 3-10 4...10-0
In my chart I have a column that tells me what place I finished in the sit and go. But I need a forumula that recognizes that place and puts a value for it in the next column. So I guess it would be a forumula that references the payout structure and puts a value in that corresponds to my finishing place.
I appreciate the help with this, I realize I have much to learn about excel. Thanks in advance for the help.
I am trying to put together a spreadsheet for tracking my SNG progress. I know most of the basic forumulas in excel, but there is one forumula I cannot find for the certain use I need.
I am trying to reference a value from a payout table. For example, the payouts for a 5+1 SNG are 1-25 2-15 3-10 4...10-0
In my chart I have a column that tells me what place I finished in the sit and go. But I need a forumula that recognizes that place and puts a value for it in the next column. So I guess it would be a forumula that references the payout structure and puts a value in that corresponds to my finishing place.
I appreciate the help with this, I realize I have much to learn about excel. Thanks in advance for the help.