Hi,
I'm trying to create a basic excel formula based on red/black bets on roulette. The basic layout is currently like this:
<tbody>
</tbody>
I can't quite figure out what the formula should be in column E so the IF argument can make a calculation based on whether the Bet Outcome was Red or Black. I thought it would have been this:
But it comes up with a #VALUE ! error.
Can anyone help?
Thanks,
Stuart
I'm trying to create a basic excel formula based on red/black bets on roulette. The basic layout is currently like this:
A | B | C | D | E | F | |
1 | Bet Round | Red Stake | Black Stake | Bet Outcome | Bet Profit/Loss | Running Balance |
2 | Round 1 | 1 | 1 | Black | 0 | 0 |
3 | Round 2 | 2 | 1 | Black | -1 | -1 |
4 | Round 3 | 4 | 1 | Black | -2 | -3 |
5 | Round 4 | 8 | 1 | Red | 15 | 12 |
<tbody>
</tbody>
I can't quite figure out what the formula should be in column E so the IF argument can make a calculation based on whether the Bet Outcome was Red or Black. I thought it would have been this:
=IF(D2="Black", (C2*2-B2)), IF(D2="Red", (B2*2-C2), 0)
But it comes up with a #VALUE ! error.
Can anyone help?
Thanks,
Stuart
Last edited: