View Single Post
  #8   Report Post  
Old April 19th 08, 08:29 PM posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 913
Default Formula for evaluating predictions - Fantasy Football League

On Sat, 19 Apr 2008 18:53:53 GMT, "gavin"
wrote:


"akphidelt" wrote in message
...
Wow, glad it worked out. Yea it's amazing how things can be figured out in
excel. What's funny is some guys on here can probably do that same exact
equation that's half the size of mine.


Well no one's posted an alternative so I reckon your solution is perfect!


The following is a bit shorter, but the price for that is maybe less
clarity, so I suggest you stick with the formula suggested by
akphidelt.

=IF(AND(A1=C1,B1=D1),4,IF(AND(A1=B1,C1=D1),2,IF((A 1-B1)*(C1-D1)0,1,0)))

Lars-Åke