View Single Post
  #3   Report Post  
Old April 18th 08, 08:53 PM posted to microsoft.public.excel.misc
gavin gavin is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 19
Default Formula for evaluating predictions - Fantasy Football League


"akphidelt" wrote in message
...
Let me see if I get this.

Say you have

---A----B----C----D
1--2---5----3----4
2--1---1----3----3

So the first row is saying I predict the away team wins 5 to 2. The
outcome
was the away team won 4 to 3. So in cell E or wherever you want you can
right
up a formula.

=IF(AND(A1=C1,B1=D1),4,IF(AND(A1=B1,C1=D1),2,IF(OR (AND(A1B1,C1D1),AND(A1<B1,C1<D1)),1,0)))

If you put this formula in cell E1 or wherever you start the scores and
then
copy and paste it down to the bottom it will evaluate all the games and
give
you the scores.


Thanks so much for that. I've just tried it on my home PC where I'm running
Open Office and I'm getting a #Name? error - I don't know if that is
peculiar to OO? I'm just about to fire up my work laptop which has Excel on
it and I'll report back.

Thanks again for your time.