stockport6
New member
- Joined
- May 13, 2011
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi
I am organinsing a girls football tournament and have got some very good xls sheets, however the points structure is not correct and i do not know how to change it
I need it to show 3 points for a win, 2 points for a score draw and 1 point for a no score draw. this is the current formula that give just 3 points for a win and 1 point for any draw.
=IF(ISBLANK(AW25),"0",IF(AW25>AZ25,3,IF(AW25=AZ25,1,0)))
Any help much appreciated
I am organinsing a girls football tournament and have got some very good xls sheets, however the points structure is not correct and i do not know how to change it
I need it to show 3 points for a win, 2 points for a score draw and 1 point for a no score draw. this is the current formula that give just 3 points for a win and 1 point for any draw.
=IF(ISBLANK(AW25),"0",IF(AW25>AZ25,3,IF(AW25=AZ25,1,0)))
Any help much appreciated