Problem using the IF function
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?
|