You don’t have to use a formula for dutching prices, particularly place prices. Use an algorithm.
For example, if you select 3 runners with the prices of $2.60, $2.70 and $10.90.
Step 1. Have your program loop around adding 1 unit to each runner ,keeping a count of the total units.
Step 2. At the end of each loop test the return from each runner to see how much profit it will return.
Step 3. Once each runner shows a profit which is greater than the actual total bet then cease the loop.

You can use this algorirthm for all types of betting scenarios – fixed betting amount, target or return amounts.
The above prices would work out as follows.
2.60 4 units $1.4 profit
2.70 4 units $1.8 profit
$10.90 1 unit $$1.9 profit
total bet $9.00

The bigger the place prices the better the return.

Once you have got this algorithm mastered it is not difficult to move onto sets of prices . eg calculating profits for sets of place prices such as 2 or 3 place getters. All same Any2 or Duet

You can also work it for lay prices, but I will leave that for you to work out.


Shaun. Can’t help you with your trigger problem. Not in Excel anyway.