Dirtbikindad393
New member
- Joined
- May 13, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
I am trying to make a formula for a fantasy league sheet where there will be multiple names and a currency number that each player donated and a total of all money in the league. The league pays top 3 at a rate of
1st 50%
2nd 30%
3rd 20%
How can I make it so all I have to do is put 1, 2 or 3 and it will tell me what the currency number is for that spot?
Lets say 10 names each donate 20.00 total is 200.00 I want to put the number 1 in a box and have it tell me what 50% of the total is. @ in a box and have it tell me what 30% of the total is etc
1st 50%
2nd 30%
3rd 20%
How can I make it so all I have to do is put 1, 2 or 3 and it will tell me what the currency number is for that spot?
Lets say 10 names each donate 20.00 total is 200.00 I want to put the number 1 in a box and have it tell me what 50% of the total is. @ in a box and have it tell me what 30% of the total is etc