Quote Originally Posted by vba_php View Post
you can probably answer that yourself based on all the information you posted. it's just reverse mathematics. like being given 2 elements in a 3-element math problem, and then using grade school mathematics to move the elements around so there is only one unknown element on one side of the equal sign. think reciprocols in fractional mathematics. that's the same concept.

have you looked here?

google.com/search?q=calculate+probably+of+multiple+year+bet
I'm not sure it's quite that simple Adam, I've found a solution but it includes a table that calculated every eventuality then using the vlookup and match function to identify the correct value.

If your solution is possible I would much rather use it but I have limited mathematical knowledge and struggle to comprehend much of the content from the results of that google search.