Hello. I hope someone can help me with this.
I would like a formula to show the points won on a football match when the stake is fixed at 50000 points.
For example, the odds for a match between Barcelona - Real Madrid might be 7/4 12/5 6/5
If Barcelona win, the formula to work out the winnings would be 50000*7/4+50000
The draw would be 50000*12/5+50000
A win for Real Madrid would be 50000*6/5+50000
If the result of the match in cell A1 is Barcelona 2-2 Real Madrid, how can I show the winnings in cell B1?
Thank you.
Bookmarks