Hi, All.
I'm trying to make a sheet that will automatically calculate winnings. I'm trying to get a Zoom staff night at the races.. and can't get this working.
https://docs.google.com/spreadsheets...KO8/edit#gid=0
The idea:
I have the odds in the Red border box.
I add what people have bet on in the green board box. They can bet up to 3 times on each race.
The results of the race are entered into the blue box.
If the number in the blue box matches any where in the green box it's a winner and we need to calculate your winnings.
So in this case we've a few winners.
So i'd like to automatically fill in the total win section. The second I fill in the blue box with the winning number it should fill in the "Total Win" section.
So it's needs to
If E14= Win multiply F14*C4+F14 - I manually entered this for the sample.
But because traps 1 to 6 could win the range would need to be bigger.
I'm not even sure if this can be done. Just hoping it can be.
thanks.
Bookmarks