View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GerryGerry GerryGerry is offline
external usenet poster
 
Posts: 18
Default 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!