View Single Post
  #4   Report Post  
Old April 18th 08, 09:25 PM posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 461
Default Formula for evaluating predictions - Fantasy Football League

No problem for the help. Im not very familiar with Open Office. I tested it
on an excel sheet and it worked perfectly. Let me know if you have any
problems in the actual excel sheet.

"gavin" wrote:


"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.