LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fomula (if?) Jules Excel Worksheet Functions 0 August 8th 06 07:13 PM
Fomula Problem whitieklf Excel Worksheet Functions 6 August 8th 06 12:21 PM
Fomula Steve Excel Discussion (Misc queries) 2 December 8th 05 07:29 PM
Please help, i need a fomula Age Formula?? Excel Worksheet Functions 2 October 13th 05 10:32 PM
IF Fomula DWadding Excel Discussion (Misc queries) 1 August 3rd 05 05:32 PM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"