View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] mario.cicak@gmail.com is offline
external usenet poster
 
Posts: 7
Default 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