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

 

[S.H.A.D.O.]

Hi Corleone,

There are some brackets missing off the end of your posted formula.
Anyway, give this formula a try...

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

I hope this helps!

 

[Corleone]

Hi Corleone,

There are some brackets missing off the end of your posted formula.
Anyway, give this formula a try...

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

I hope this helps!

Apologies for taking so long to respond

thanks for your help - works ok now

 

[S.H.A.D.O.]

Hi Corleone,

Apologies for taking so long to respond.

Thanks for your help - works OK now.

You're welcome and thanks for the feedback.

 

[richardob]

I realise this is 5 years ago but I've just stumbled across your thread in a search. It sounds like you've created exactly what I need for a football predictions game I've started. Do you have the spreadsheet still and if so, would you be prepared to share it with me please? Many thanks. Richard

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

</j51),1,if(and($c51=$e51,h51=j51),1,0))))

 

[Corleone]

Hi send me your email and I will send you a copy later today or tomorrow

 

[richardob]

Hi,

I sent you my email by private message but it occurred to me that perhaps you don''t monitor them. My email is xxxxxx if you could send me that football spreadsheet please?

Many thanks for your time.

Richard

 

[Corleone]

Hi,

I sent you my email by private message but it occurred to me that perhaps you don''t monitor them. My email is if you could send me that football spreadsheet please?

Many thanks for your time.

Richard

just sent

cheers

 

[Fluff]

@richardob
I removed your email address from your post, as Spam Bots routinely troll Public User Forums like these looking for email addresses to Spam.

 

[Harrisson]

Would it be possible for you to forward it to me also? many thanks Harrisson