View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JockW JockW is offline
external usenet poster
 
Posts: 32
Default IF, AND, BUT and ON-THE-OTHER-HAND formula :)

Wow!
I'm overwhelmed guys. Many thanks for all your input on this, it's very much
appreciated.

--
tia


"JockW" wrote:

I'm unsure if this is do-able, but I know some of you will relish the
challenge....
I'm creating a spreadsheet showing points gained from predicting soccer
scores.
For the correct result (ie home win, away win or draw) - 3 points,
For getting home team score correct - 1 point,
For getting away team score correct - 1 point.
Therefore, the max possible points per game would be 5.
So, for instance:

Home Away
3 1

john's prediction
2 1 4 points - 3 for the result and 1 for the correct
away score
Jane's prediction
1 0 3 points for the correct result
Jack's prediction
0 3 0 points

I think there may be too many variables but any/all help greatly appreciated.
--
tia