Thanks Surround.

I can see what you've done in principle with Cell J4 and J7 formula.
By comparison I think something else is missing and I just don't know what it is, yet.
When I change the Cell K4 to 25 ( generally a default value for simplicity ), it calculates 70 units required to make 25 units profit after bet cost.
That is way way to high a cost.

I have a DOS program, a with hedge calculator - with settings for "make profit of", then Enter the amount 100, 200, or in this test case, 25.

Once I get the graphics working with the help of a puter techie ( XP does not like DOS programs with graphs !) I'll be able to see again what the exact unit amounts are using the odds available and hopefully we can "reverse engineer" this thing and then use those formulas in excel.

The goal/s to reach in the mean time, or a strategy is to control the Cost by a Variable percent.

Meaning, if one wants to make 25 units profit, and the Max Cost allowed is 80% of 25 = 20, then it is a bet on those 3 runners.
The 80% can be adjusted of course, to 100, or even to 110, one may choose to spend 30 units to make 25 units profit, it's personal choice.

Let's say we have Divs
3.50
4.00
5.00
If my memory serves me correctly, I think with those odds it be close to 20 units to make 25 units profit after cost of total bet.
If my Max is set to 80% of 25, ( 20 ) then I can assume it's a Value bet.
If I want to use lower priced runners, (1.80 fav), naturally it may blow out to 35 Units to make 25 Profit. That's OK to, IF one has their settings at 120 % instead of 80%
Some choose to not bet on favorites, but the rest of the field has a few runners under 7/1's. The variable 80 % limiter for 25 Unit profit goal may assist in determining a "Value Hedged Bet".


When I get the graphics sorted later this week, I'll be able to run this DOS program, put in the Odds, and see what it comes up with.

Thanks once again, much appreciated for your help.