General Betting
There is currently 1 person viewing this thread.
Hello guys :) just wondering if there is anyway I can make this happen. Ideally I have several columns labelled, stake, potential win, result, bank. What I'd like to do is ask excel to add potential win to bank if result = Win, but at the same time, subtract the stake from the bank if result = Lose. Just wondering if there is anway to make this happen, I assume it would involve count if, but not sure if you can double barrel it. Thanks in advance if you can help :)
sort by:
Show
per page
Replies: 1
|
By:
Easiest way would probably be to make a new column with something along the lines of =if(D1="win",C1,IF(D1="lose",-C1,"") then you can add the sum to your bank.
*Where D1 represents the win/loss cell and C1 represents the potential win. If it's for betfair you'll need to adapt it to take account of commission C1*0.95 or whatever your commission discount is. |