Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need formula 1 x 2 1x x2
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need formula 1 x 2 1x x2
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |