I need a teller in my worksheet.
IF (my_condition) is true, teller=1;
For the second time
IF (my_condition) is true, teller=teller+1.
IF(teller=2) Trigger fires a bet.
How can I make this?
Excel question
Moderator: 2020vision
4 posts
• Page 1 of 1
Excel question
by sjaak1943 » Wed Dec 12, 2007 8:55 am
- sjaak1943
- Posts: 174
- Joined: Tue Oct 31, 2006 9:50 pm
- Location: Schagen, the Netherlands
Re: Excel question
by Günter » Wed Dec 12, 2007 9:57 pm
sjaak1943 wrote:I need a teller in my worksheet.
IF (my_condition) is true, teller=1;
For the second time
IF (my_condition) is true, teller=teller+1.
IF(teller=2) Trigger fires a bet.
How can I make this?
Impossible, except with VBA
- Günter
- Posts: 16
- Joined: Sat Jun 24, 2006 4:02 pm
- Location: Somewhere on the Australian coast
Excel question
by sjaak1943 » Wed Dec 12, 2007 10:29 pm
I thought so, but I can't do it with VBA.
Can you?
Can you?
- sjaak1943
- Posts: 174
- Joined: Tue Oct 31, 2006 9:50 pm
- Location: Schagen, the Netherlands
Re: Excel question
by Mattmid » Mon Dec 17, 2007 8:29 pm
sjaak1943 wrote:I need a teller in my worksheet.
IF (my_condition) is true, teller=1;
For the second time
IF (my_condition) is true, teller=teller+1.
IF(teller=2) Trigger fires a bet.
How can I make this?
Could you not have an argument in two separate columns with an answer of 0 or 1, and then a third that adds the two together. Then the trigger can check if the third cell equals 2
- Mattmid
- Posts: 47
- Joined: Thu Jul 19, 2007 1:14 pm
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 65 guests