LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
yhtak
 
Posts: n/a
Default Another "World Cup" related query

Apologies if this query has been raised before...

We are running a "predict the score" syndicate and I am trying to write a
fomula to generate the following points score e.g.

if the predicted score is say, 3-0 and the actual score is 3-0 then you get
3 points
if the predicted/actual score is incorrect but the RESULT is correct - you
get 1 point
if the predicted score is, say 3-0 but the result is 0-3, you get 0 points.

Any assistance will be gratefully received.



 
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
changing query source [email protected] Excel Worksheet Functions 2 March 21st 06 08:55 PM
enable automatic refresh Vass Excel Worksheet Functions 2 March 11th 06 04:36 AM
AHHH! Again JAA149 Excel Discussion (Misc queries) 0 October 31st 05 11:36 AM
AHHHH-Get Data from Multiple Excel workbooks JAA149 Excel Discussion (Misc queries) 5 October 30th 05 05:19 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 02:29 PM.

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

About Us

"It's about Microsoft Excel"