Horse Racing Payout Pot

KPH3802

New Member
Joined
Dec 10, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. MacOS
I have a spreadsheet I am looking to calculate payout for a pot. Every race will payout the same amount. Say $100 but the race may have different amounts of winners, 2nd place and 3rd place. I would like the payout to be as follows 1st 60%, 2nd 30% and 3rd 10% So if there is only one 1st, one 2nd and one 3rd its easy $70, $30 and $10 but it gets more complicated if I have 4 1st, 3 2nd and 1 3rd. If there were 9 in 1st then the pot is split 9 ways and no 2nd or 3rds get paid out. How do I make a formula to say that?

I could use VBA if necessary.
 

Attachments

  • Screen Shot 2020-12-10 at 10.15.50 AM.png
    Screen Shot 2020-12-10 at 10.15.50 AM.png
    92.4 KB · Views: 33

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,223,617
Messages
6,173,362
Members
452,511
Latest member
jbake23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top