Hi mcbee,
I have completely changed my approach and it does not resemble the above, and gave up on that idea as it looked too hard.
I've decided to work with the profit and deduct an amount which will be the Bet Amount from the winning player to leave a balance of say 2.00 on that player.
Example:
Nadal +5.00
Murray -10.00
Bet Amount = s_1_profit_loss-2
or
Nadal -10.00
Murray +5.00
Bet Amount = s_2_profit_loss-2
My formula to arrive at the Bet Amount would be:
=IF(s_1_profit_loss>0,s_1_profit_loss-2,IF(s_2_profit_loss>0,s_2_profit_loss-2))
This works in an Excel worksheet replacing s_1_profit_loss with a cell address
However it throws up an error in MFP can you see any problem with it ?
Notes: This formula will only be used on a second bet meaning there will always be a profit with one player and a loss with the other.
My Back triggers don't use an index condition and prefer not to use one.
The formula will be used for the Bet Amount
There will be a 2.00 profit remaining on the player with profit after calculation.
=IF(s_1_profit_loss>0,s_1_profit_loss-2,IF(s_2_profit_loss>0,s_2_profit_loss-2))
Hope you can correct
Many thanks
R