Need formula 1 x 2 1x x2
 

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

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!

Need formula 1 x 2 1x x2
 

Your question is not very clear, but here is my best guess...

Are you looking for a formula to put in Column C that will see if whatever
(single character) is in Column B also appears somewhere in Column A and
return 1 for True and 0 for False? If so, give this formula a try...

=--ISNUMBER(FIND(B1,A1))

If this is not what you want, you will have to restate your question and
supply a lot more detail about what is in Columns A and B (what are the 1s,
2s, and Xs), what Column C is there for, and what you are trying to get from
them.

Rick


wrote in message
...
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

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!

Need formula 1 x 2 1x x2
 

On 14 tra, 11:11, "Rick Rothstein \(MVP - VB\)"
wrote:
Your question is not very clear, but here is my best guess...

Are you looking for a formula to put in Column C that will see if whatever
(single character) is in Column B also appears somewhere in Column A and
return 1 for True and 0 for False? If so, give this formula a try...

=--ISNUMBER(FIND(B1,A1))

If this is not what you want, you will have to restate your question and
supply a lot more detail about what is in Columns A and B (what are the 1s,
2s, and Xs), what Column C is there for, and what you are trying to get from
them.

Rick

wrote in message

...



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

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!- Sakrij citirani tekst -

- Prikaži citirani tekst -

My question is how to do formula wich know that 1x (column A) and x
(column B) is true (1)

Need formula 1 x 2 1x x2
 

On 14 tra, 11:11, "Rick Rothstein \(MVP - VB\)"
wrote:
Your question is not very clear, but here is my best guess...

Are you looking for a formula to put in Column C that will see if whatever
(single character) is in Column B also appears somewhere in Column A and
return 1 for True and 0 for False? If so, give this formula a try...

=--ISNUMBER(FIND(B1,A1))

If this is not what you want, you will have to restate your question and
supply a lot more detail about what is in Columns A and B (what are the 1s,
2s, and Xs), what Column C is there for, and what you are trying to get from
them.

Rick

wrote in message

...



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

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!- Sakrij citirani tekst -

- Prikaži citirani tekst -

I would like fomula who will know the result of column A and B. If i
put in column A or B some of this characters

Need formula 1 x 2 1x x2
 

=IF(AND(A1="1x",B1),TRUE,FALSE)

--

Regards,
Nigel




wrote in message
...
On 14 tra, 11:11, "Rick Rothstein \(MVP - VB\)"
wrote:
Your question is not very clear, but here is my best guess...

Are you looking for a formula to put in Column C that will see if whatever
(single character) is in Column B also appears somewhere in Column A and
return 1 for True and 0 for False? If so, give this formula a try...

=--ISNUMBER(FIND(B1,A1))

If this is not what you want, you will have to restate your question and
supply a lot more detail about what is in Columns A and B (what are the
1s,
2s, and Xs), what Column C is there for, and what you are trying to get
from
them.

Rick

wrote in message

...



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

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!- Sakrij citirani tekst -

- Prikaži citirani tekst -

My question is how to do formula wich know that 1x (column A) and x
(column B) is true (1)

Need formula 1 x 2 1x x2
 

On 14 tra, 11:53, "Nigel" wrote:
=IF(AND(A1="1x",B1),TRUE,FALSE)

--

Regards,
Nigel


wrote in message

...
On 14 tra, 11:11, "Rick Rothstein \(MVP - VB\)"





wrote:
Your question is not very clear, but here is my best guess...

Are you looking for a formula to put in Column C that will see if whatever
(single character) is in Column B also appears somewhere in Column A and
return 1 for True and 0 for False? If so, give this formula a try...

=--ISNUMBER(FIND(B1,A1))

If this is not what you want, you will have to restate your question and
supply a lot more detail about what is in Columns A and B (what are the
1s,
2s, and Xs), what Column C is there for, and what you are trying to get
from
them.

Rick

wrote in message

...

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

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!- Sakrij citirani tekst -

- Prikaži citirani tekst -

My question is how to do formula wich know that 1x (column A) and x
(column B) is true (1)- Sakrij citirani tekst -

- Prikaži citirani tekst -

I wont formula for all combinations in one chell.

Need formula 1 x 2 1x x2
 

On Mon, 14 Apr 2008 02:19:02 -0700 (PDT), wrote:

My question is how to do formula wich know that 1x (column A) and x
(column B) is true (1)

Your description of what you want is NOT clear in English.

Rick's formula gives the same result as you showed in Column C for all of the
examples you posted.

If you cannot state your requirements clearly, perhaps you could post examples
where Rick's formula gives undesired results.
--ron

Need formula 1 x 2 1x x2
 

Use a UDF to set up al valid conditions, suggest you add the following
function to a standard module, then place in column C the following formula

=Sport(A1,B1)

then copy down all rows....

Add or amend conditions in the function as required.


Function Sport(c1 As Range, c2 As Range) As Boolean
' take value in c1 and c2 apply logic, return true or false
Dim xA, xB
xA = Trim(UCase(c1))
xB = Trim(UCase(c2))

Sport = False
If xA = 1 And xB = 1 Then Sport = True
If xA = 2 And xB = 2 Then Sport = True
If xA = "X" And xB = "X" Then Sport = True
If xA = "1X" And xB = 1 Then Sport = True
If xA = "1X" And xB = "X" Then Sport = True
If xA = "X2" And xB = 2 Then Sport = True
If xA = "X2" And xB = "X" Then Sport = True
End Function

--

Regards,
Nigel




wrote in message
...
On 14 tra, 11:11, "Rick Rothstein \(MVP - VB\)"
wrote:
Your question is not very clear, but here is my best guess...

Are you looking for a formula to put in Column C that will see if whatever
(single character) is in Column B also appears somewhere in Column A and
return 1 for True and 0 for False? If so, give this formula a try...

=--ISNUMBER(FIND(B1,A1))

If this is not what you want, you will have to restate your question and
supply a lot more detail about what is in Columns A and B (what are the
1s,
2s, and Xs), what Column C is there for, and what you are trying to get
from
them.

Rick

wrote in message

...



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

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!- Sakrij citirani tekst -

- Prikaži citirani tekst -

I would like fomula who will know the result of column A and B. If i
put in column A or B some of this characters

Need formula 1 x 2 1x x2
 

I THINK the following is what your looking for although like the others who
have already posted, I'm a little unclear.

=ISNUMBER(SEARCH(B2,A2))

Regards

Gerry
wrote in message
...
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

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!