I have a spreadsheet which calculates a win / loss percentage (attached) for tennis rankings.
To improve my ranking I need to achieve the following in a qualifying period: 6 wins and a win loss ratio of 60:40.
This bit I can calculate & show all OK, but what I would like to be able to show in the Column G of the sheet "RESULTS" is how many successive wins I need to make to achieve the required ratio. (i.e. if I have played 12 matches, won 6 & lost 6 I have achieved the 6 wins but I fail on the ratio, so in order to achieve the ratio how many more wins do I need to make without loss)
Can Anybody help?