Problem Nature:
Odds calculator needed
When I need it: as soon as possible
Payment Amount: 15,- USD via PAYPAL
Hi guys
a nice simple one for you (detailed explanation below but i probably make it sound more complicated than it is)
please no VBA on this one (just excel functions)
as you can see there is a constant stake on each line of $4
i want to be able to have the formula that i can drag further down the sheet so that i can add more rows of information
excel attached file
Basically this is a small part of a betting stategy (the other parts are done but i cant get my head around this problem)
this is laying horses to lose rather than betting to win.
Column a is result - win or lose
Column b is odds (these may vary and i would like to be able to change some of these but the formulas on the sheet must be able to cope with this
Column c - bet amount
column d - amount won (if horse looses the race i win)
Column e - Amount lost (if horse wins the race, i lose and have to payout 2.5 times my stake
e.g. $4 stake = payout $10
now the tricky bit
Rows 10,11 & 12 all win which means i lose
row 11 Bet Amount is $14 ($4 Constant stake + $10 loss from row 10
row 12 Bet Amount is $49 ($4 Constant stake + $10 loss from row 10 & $35 loss from row 11
i hope that is enough information
Hope you get the picture
good luck
the first solution to be posted will get the money.