| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function problem | Excel Worksheet Functions | |||
| Problem with IF function | Excel Worksheet Functions | |||
| MAX / MIN function problem | Excel Discussion (Misc queries) | |||
| Problem with IRR function | Excel Worksheet Functions | |||
| FV Function Problem | Excel Worksheet Functions | |||
Threaded Mode
