Hi everyone basically i need help creating a formula to give me the answer in a percentage of R.O.I = return on investment.My spreadsheet looks like this. WINS BETS B.R 5% NEXT LEVEL TOTAL PTS % R.O.I %
K L £50.00 2.50 £75.00 R
1 1 1%
1 2
2 3
2 4
3 5
4 6
5 7
6 8
6 9

I need to calculate the wins in column K with the bets in column L to give me a percentage in return of my wins and losses in column R. It's got 1% i need it to calculate in terms of 100% then down in relation to the amount of wins losses i sustain as you can see i have had 9 bets and won 6 of them so i need to find out how to put it as a percentage on my spreadsheet so it calculates it for me when i put in my wins or losses hope to hear from you soon many thanks in advance.
Regards Terence.