Results 1 to 2 of 2

Thread: Help with Tournament Excels

  1. #1

    Help with Tournament Excels



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    Try this:

    Code:
    =IF(AW25<AZ25,0,IF(AND(AW25=0,AZ25=0),1,IF(AW25=AZ25,2,3)))
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •