Help with Tournament Excels

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
 
Top