Problem with fomula IF, AND, OR... help
On 14 tra, 11:15, wrote:
Hy,
I am trayng to do formula for sport betting. but i have problem with
1x and x2. How to make formula for this;
A * *B * C
1 * *1 * *1
1 * *2 * *0
1 * *x * *0
2 * *2 * *1
2 * *1 * *0
2 * *x * *0
x * *x * *1
x * *1 * *0
x * *2 * *0
1x *1 * *1
1x *2 * *0
1x *x * *1
x2 *1 * *0
x2 *2 * *1
x2 *x * *1
First column (A) is pick, second is result of game (b) a C is true of
false!!
=IF(A=b;1;........
Meny thank!
I would like formula in colomn C to do result (1 - true, 0 - false)
when in column A or B somethinh of this
|