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? |
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. |
All times are GMT +1. The time now is 06:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com