Problem with fomula IF, AND, OR... help

  • Thread starter Thread starter mario.cicak
  • Start date Start date
M

mario.cicak

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!
 
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!
Click to expand...


I would like formula in colomn C to do result (1 - true, 0 - false)
when in column A or B somethinh of this
 
If I understand you correctly, all you need is in C1 enter "=IF(A1=B1,1,0)
and copy it down.
 
If I understand you correctly, all you need is in C1 enter "=IF(A1=B1,1,0)
and copy it down.






- Prikaži citirani tekst -
Click to expand...

It is not so simple. I hawe only one row. I wont formula for all
combinations in one chell. if is in cheel A 1x and in chell B x i
would like ina chell C result for that combination.
 
Try this in C1: =IF(ISNUMBER(SEARCH(B1,A1)),1,0)
Copy down. This seems to return the results that you indicate

P/s: Change the commas to semi-colons to suit
 
Back
Top