+ Reply to Thread
Results 1 to 4 of 4

Golf skins payout

  1. #1
    Registered User
    Join Date
    05-06-2018
    Location
    Bradford
    MS-Off Ver
    2011
    Posts
    0

    Angry Golf skins payout

    Hi there
    i am trying to figure out a formula for 4 players playing an 18 hole golf game. each hole is worth £4, however if someone draws at a hole there is no pay out. i have looked at a skin calculator online and i can't figure out the formula that figures out how much each player owes. below are some examples:

    1st won 4 holes - wins £12
    2nd won 3 holes - loses £4
    3rd won 3 holes - loses £4
    4th won 3 holes - loses £4

    1st won 6 holes - wins £36
    2nd won 5 holes - wins £20
    3rd won 3 holes - loses £12
    4th won 1 holes - loses £44

    1st won 7 holes - wins £56
    2nd won 4 holes - wins £8
    3rd won 2 holes - loses £24
    4th won 1 holes - loses £40

    1st won 4 holes - wins £36
    2nd won 2 holes - wins £4
    3rd won 1 holes - loses £12
    4th won 0 holes - loses £28

    Please can someone help me out, my head is hurting i have been on this for 3 days now

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello dimples,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    03-29-2013
    Location
    lakewood, usa
    MS-Off Ver
    exce2013
    Posts
    112

    Re: Golf skins payout

    The attached might help. It uses ties carry over and will work for net or scratch.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-29-2013
    Location
    lakewood, usa
    MS-Off Ver
    exce2013
    Posts
    112

    Re: Golf skins payout

    This one might be what you are looking for
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Golf net Skins sheet
    By Bardy in forum Excel General
    Replies: 4
    Last Post: 12-03-2020, 01:25 AM
  2. Golf Skins.. If and Count If Question
    By Joey Holley in forum Excel General
    Replies: 1
    Last Post: 01-23-2015, 03:07 AM
  3. [SOLVED] Conditional Formatting with golf skins
    By EXCEL69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2014, 01:01 PM
  4. Golf Skins Autopopulate
    By gjmosby31 in forum Excel General
    Replies: 3
    Last Post: 03-26-2013, 12:05 AM
  5. Golf Tournament & Skins Pot
    By gjmosby31 in forum Excel General
    Replies: 15
    Last Post: 02-02-2013, 03:59 PM
  6. Using Excel for Golf Skins
    By Vidcity in forum Excel General
    Replies: 1
    Last Post: 04-26-2012, 04:21 PM
  7. Figuring out Skins for Golf
    By pjfan2340 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2011, 03:33 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1