Hi
I am fairly new to Excel but have a general understanding of the functions and basic formulas. I am currently making a spreadsheet for myself to help me keep track of sports bets as a test for a system I would like to try. So I have made this spreadsheet with 10 games that are played today and I am looking for a formula that can tell me wether or not the bet was a win or loss.
As you can see in my spreadsheet, I have got a few different values. Home and Away states the odds on the Home and Away team, Bet Home and Bet away is the amount of cash being put on either the Home or Away team, Win Home and Win Away is a potential Win for the Home or Away side. Bet Total is the total amount of cash being bet on the Home and Away side in one match and with a grand total in the bottom.
Now, Outcome is blank because I need help with a formula to tell me if the game was either a win or a loss.
Now, I want to be able to plot in a (H)ome, (A)way or (L)oss in the outcome cell which in turn calculates if I have won a bet on the Home or Away side or if I lost the bet. So if I plot in an A in the WBA vs Burnley Outcome cell, I would want it to calculate my Away earnings minus the Bet Total for that match. I then want the Outcome text to be written in either green (for a win) or red (for a loss).
Any help would be greatly appreciated
Bookmarks