Football predictions league spreadsheet

[Corleone]

Nearly got this cracked now, however i just need a final tweak making to the formula below



=IF($C51&$E51=H51&J51,3,IF(AND($C51>$E51,H51>J51),1,IF(AND($C51< $E51,H51<J51),1,IF(AND($C51=$E51,H51=J51),1,0))))

The league scoring works on the basis of
3 points fro getting the exact scoreline right (ie Liverpool 2 wba 1)
1 point for getting the result right (ie home win)

the formula is based on the actual results which are inputted into cols C & E and the predictions which are put into cols H &J

The issue i have is that for the matches that havent taken place yet, it assumed that the entrants all have 3 points per game as it treats the Blank contents of Columns C & e as 0-0 as well as the columns H & J

i woould like to add to the formula so that if the cells in Col C and Col E are blank, the score is 0

Thanks

 

[blong]

Nearly got this cracked now, however i just need a final tweak making to the formula below



=IF($C51&$E51=H51&J51,3,IF(AND($C51>$E51,H51>J51),1,IF(AND($C51< $E51,H51<J51),1,IF(AND($C51=$E51,H51=J51),1,0))))

The league scoring works on the basis of
3 points fro getting the exact scoreline right (ie Liverpool 2 wba 1)
1 point for getting the result right (ie home win)

the formula is based on the actual results which are inputted into cols C & E and the predictions which are put into cols H &J

The issue i have is that for the matches that havent taken place yet, it assumed that the entrants all have 3 points per game as it treats the Blank contents of Columns C & e as 0-0 as well as the columns H & J

i woould like to add to the formula so that if the cells in Col C and Col E are blank, the score is 0

Thanks

Good evening.

Could i ask if i could get a copy of this form too as it sounds like this is similar to what i require for a works weekly predictor. Manny thanks Larry

 

[Corleone]

post up your email address

 

[Fluff]

@Corleone please do not ask members to post their email address. Bots regularly patrol sites like this looking for email accounts to spam.

 

[McinerneyD]

Hi Corleone,
How could I get you to send me this spreadsheet?
Working on a Charity World cup event through work and it would be greatly appreciated!

Thanks,
Dave