I am currently setting up a league table and fixture list for a football league. I have been able to set up my spreadsheet to calculate wins and losses however I am unable to calculate draws!!
Using the IF function I can detect if the score of the game was a draw, HOWEVER if there is NO DATA of any kind in the cells being examined a draw will still be counted.

eg:
A1 NO DATA ENTERED/BLANK
B1 NO DATA ENTERED/BLANK
C1 =IF(A1-B1=0,1,0)

This returns 1point even though I have no results for this match inputted. Can anyone help with this problem?

Try this

=IF(AND(A1="",B1=""),"",IF(A1-B10,1,0))

It will give blank if blank
1 if a1 bigger than b1
0 if b1 bigger than a1

Hope that helps.