Thread: Formula with multiple if statement

i'm looking @ doing something similar... but instead i'm looking at putting a "cancellation system" into excel.
http://www.excelforum.com/excel-programming/612303-formula-with-multiple-if-statement.html

Here is an example:

You start with 1 1 1 1 1 1 1 1 1 1.
You then wager two units and win, cross off the 1 on the left and right, leaving 1 1 1 1 1 1 1 1.
You then wager another two units and lose, adding a 2 to the right, leaving 1 1 1 1 1 1 1 1 2.
You then wager three units (1+2) and lose again, adding a 3 to the right, leaving 1 1 1 1 1 1 1 1 2 3.
You then wager four units (1+3) and win, crossing off the 1 on the left and the 3 on the right, leaving 1 1 1 1 1 1 1 2 .

I've tried EVERYTHING .. but can't seem to get it into excel... please help

Here you go. I set it up in 3 columns; Column A has your wager scheme, B has the amount you should bet, and C (manual input) is whether you won or lost.

In A3, the formula is

=IF(C2="Win",MID(A2,3,LEN(A2)-4),IF(C2="Loss",A2&" "&B2,""))

which removes the first and last digit if you win and adds your last wager to the end if you lost

In B3, the formula is

=IF(ISERROR(LEFT(A3,1)+RIGHT(A3,1)),"",LEFT(A3,1)+RIGHT(A3,1))

which sums the first and last digit of your new wager scheme. ISERROR is necessary to prevent error codes in rows you haven't gotten to yet.

Let me know if you have any questions.

ChemistB
(Not responsible for any losses incurred while running this program)

hi markinsurrey, please read forum rules:


2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.