Question: HOW CAN I CONVERT THIS ALGORITHM TO A FORMULA IN EXCEL? BETS PLACED ON HEADS AND TAILS FOLL BELOW ALGORITHM. THE ALGORITHM IS 1, WIN
HOW CAN I CONVERT THIS ALGORITHM TO A FORMULA IN EXCEL?
BETS PLACED ON HEADS AND TAILS FOLL BELOW ALGORITHM.
THE ALGORITHM IS 1, WIN BET 3(LOSE, BET 1), WIN BET 7(LOSE BET 3), WIN, BET 4 (LOSE, REPEAT BET OF 4 , IF THE REPEAT IS LOST , BET 1)
IF 4 WINS, BET 6 (LOSE BET 4, IF WON BET 7, IF BET OF 4 IS LOST , BET 1), WIN BET 7 (LOSE , BET 4, IF WON BET 7, IF BET OF 4 IS LOST , BET 1).
IF 7 WIN , BET 8 (LOSE , BET 4, IF WON BET 7, IF BET OF 4 IS LOST , BET 1), CONTINUE THE ALGORITHM UNTIL 2 LOSSES IN A ROW THEN START BETTING 1 AGAIN.
| EXAMPLE | BETS ON HEADS AND TAILS | |
| IF FOLL SEQUENCE OF BETTING BELOW WILLUNDERSTAND THE ALGORITHIM BETTER THAN THE EXPLANATION ABOVE. | ||
| HEADS | TAILS | |
| H | 1 | -1 |
| T | -3 | 1 |
| T | -1 | 3 |
| T | -1 | 7 |
| H | 1 | -4 |
| H | 3 | -4 |
| H | 7 | -1 |
| T | -4 | 1 |
| H | 4 | -3 |
| H | 7 | -1 |
| T | -5 | 1 |
| H | 5 | -3 |
| T | -1 | 1 |
| T | -1 | 3 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
