+ Reply to Thread
Results 1 to 4 of 4

If then:complete newbie

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Fleet, Hampshire
    MS-Off Ver
    Excel 2003
    Posts
    9

    If then:complete newbie

    Hi

    please can you help a complete newbie

    I want to make an excel to do golf stableford scoring (sad, I know)

    so, I have the score for hole 1 into cell C3 and this stays there

    I put the score from the first hole in D3

    In D64, I want to put the stableford score (1 point under C3 shows 3; value = C3 shows 2; 1 point over C3 shows 1 and anything else shows 0)

    Can anyone help please?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: If then:complete newbie

    If C3 contains adjusted par and D3 contains actual strokes, the Stableford score is =MAX(0, C3-D3+2)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-11-2009
    Location
    Fleet, Hampshire
    MS-Off Ver
    Excel 2003
    Posts
    9

    re: If then:complete newbie

    Hi

    thank you so much, that's brilliant!

    Could you also advise me how to copy this formula to other cells, so I can keep a running score?

    If I try to drag the formula to E64, it moves the columns e.g. =MAX(0, D3-E3+2). Can I keep C3 as a constant when I move it across

    thanks

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: If then:complete newbie

    I'm not sure how C3 can be a constant, but =MAX(0, $C$3-D3+2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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