I want to find a way to do this (with a loop):
a list in excel is, for example :
when input of a new value in C ( x ) : 1-->0 OR 0 -->1 OR 0 --> undetermined OU 1 --> undetermined or undetermined to 1 OR undetermined to 0
For each Row ( i ) from 1 to N
If a ( i ) = "v1" (same value of a ( i ) than row X)
then change value of b ( i ) in agreement with the formula in column B
thanks
a list in excel is, for example :
Rows / Colums | A (code) | B litteral formula to calculate C ( i ) | C (value 0 ou 1 or undetermined) | D |
1 | a(1) = v1 | si (b(x)=1; b(1)=0; b(1)=1) | write here b ( i ) value | |
2 | a(2) = v2 | si (b(x)=1; b(2)=0; b(2)=1) | write here b ( i ) value | |
3 | a(3) = v1 | si (b(x)=1; b(3)=1; b(3)=0) | write here b ( i ) value | |
4 | a(4) = v1 | si (b(x)=1; b(4)=1; b(4)=0) | write here b ( i ) value | |
5 | a(5) = v1 | si (b(x)=1; b(5)=1; b(5)=0) | write here b ( i ) value | |
6 | a(6) = v2 | si (b(x)=1; b(6)=0; b(6)=1) | write here b ( i ) value | |
- - - - | - - - - | - - - - | ||
N | a(N) | si (b(x)=1; b(N)=0; b(N)=1) | write here b ( i ) value | |
Any X | v1 | b(x) (value = {0,1,undetermined} | 0, 1, undeterminded |
when input of a new value in C ( x ) : 1-->0 OR 0 -->1 OR 0 --> undetermined OU 1 --> undetermined or undetermined to 1 OR undetermined to 0
For each Row ( i ) from 1 to N
If a ( i ) = "v1" (same value of a ( i ) than row X)
then change value of b ( i ) in agreement with the formula in column B
thanks