Hey there! I need to write a function that will gradually decrease an amount from a maximum value based on a pre-determ

[answerhappygod]

Hey there!I need to write a function that will gradually decrease an amountfrom a maximum value based on a pre-determined amount ofpositionsI would like it to be editable through excel so I can change thenumber of numbers generated (1-10) as well as the value which allof the values will add up to the specific number (2).Think of it as a leaderboard where the top person on theleaderboard gets the biggest prize out of the prize pool of 10dollars. Then as you go down from the top position the prize theperson below will get will be less than the person in the positionabove them.
here is an example of how it would work:3 leaderboard positions to split 100 USD in prizesFirst place gets 50 dollarsSecond place gets 30 dollarsThird place gets 20 dollars
essentially I need a function I can put into excel that I caninput how many people are in the "leaderboard" and how much moneyis to be distributed amongst them, then automatically splitting theprize up with the said function
Thank you for the help!