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

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!

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

If I understand you correctly, all you need is in C1 enter "=IF(A1=B1,1,0)
and copy it down.

" wrote:

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

On 14 tra, 12:07, Stu Gnu wrote:
If I understand you correctly, all you need is in C1 enter "=IF(A1=B1,1,0)
and copy it down.



" wrote:
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- Sakrij citirani tekst -

- Prikaži citirani tekst -

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote
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!!

Ah, darned. You multi-posted in .programming. Pl don't multi-post.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---