New Posts For Thread: Help with excelhttps://community.betfair.com/general_betting/go/thread/view/94082/23512322/help-with-excelHello 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,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 behttps://community.betfair.com/general_betting/go/thread/view/94082/23512322/help-with-excel?post_id=420128182#420128182Easiest 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 beWed, 03 Feb 2010 03:09:45 -0600Hello 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,https://community.betfair.com/general_betting/go/thread/view/94082/23512322/help-with-excel?post_id=420128178#420128178Hello 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,Wed, 03 Feb 2010 02:59:30 -0600