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
=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
Last edited: