Handicap Formula

Excel Discussion in 'Microsoft Office' started by Mark Neale, Jan 18, 2018.

  1. Mark Neale

    Mark Neale

    Joined:
    Jan 18, 2018
    Likes Received:
    0
    Hi
    I currently play for a local snooker league. We are looking to handicap people so have come up with a simple formula that all players start on 0 and if they lose the get 2 points added to there handicap and if they win they get 2 points taken away. I just need a simple formula to put in the spredsheet were each week i put in "L" or "W" and it calculates the running handicap. So for exaple if after four week a player has lost all four matches they will be on a handicap of "8" if they won all four they will be on "-8". Hope this makes sense. Can anyone help.
    CIA
     
    Mark Neale, Jan 18, 2018
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.