View Single Post
  #9   Report Post  
Old June 10th 08, 09:03 AM posted to microsoft.public.excel.misc
Kevin Burrell Kevin Burrell is offline
external usenet poster
First recorded activity by ExcelBanter: Jun 2008
Posts: 1
Default Euro Prediction league formula advice

I am doing a prediction competition however my points are slightly different and i am having trouble working out the formula. In my game, it is still 3 points for the correct score, however it is 1 point for the correct result.

For Example

Predicted Actual

cell A B C C

1 1 1 0 0

2 3 0 3 0

So game 1 would be 1 point as the draw was correctly predicted but the score incorrect.

I cant seemt to get the formula correct for this particular scenario.

Much appreciated if anyone can assist