+ Reply to Thread
Results 1 to 7 of 7

Golf Tracking Help!

  1. #1
    Registered User
    Join Date
    07-21-2017
    Location
    Richmond, KY
    MS-Off Ver
    2013
    Posts
    3

    Golf Tracking Help!

    Working on a spread sheet for a golf tournament and I want to track hole in ones, eagles, birdies, pars, bogies, and double bogies. Just started messing around with the formula and was going to use "0" as par, "+1" for bogie etc. and then use the count function.

    How do I write it to identify if a cells value is 1 less/greater than a cells value (instead of just <F3 or >F3)? Or can someone suggest a better route all together?

    =IF(F5=F3,"0",IF(F5<F3,"-1",IF(F5>F3,"+1","")))

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Golf Tracking Help!

    Look at the formula VLookup. This is the way I should go in this case.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Golf Tracking Help!

    Why not just have =F5-F3, and then format the cell so that it shows a '+' if it is positive?

    Create the format as: +0;-0;0
    Last edited by gak67; 07-24-2017 at 05:54 PM.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  4. #4
    Registered User
    Join Date
    07-21-2017
    Location
    Richmond, KY
    MS-Off Ver
    2013
    Posts
    3

    Re: Golf Tracking Help!

    Thank you, but I need to know if the golfer was -1 or -2 relative to the value. If the hole is a par 5 and he has an eagle (3) I need it to return the value as -2 or if he had a birdie (4) as -1.

  5. #5
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Golf Tracking Help!

    So from your formula I am assuming that F5 has the golfer's score and F3 has the par.

    From my formula, and your examples above (plus a couple more):
    Example 1, a 3 on a par 5 (an eagle) - F5=3, F3=5, so F5-F3 = -2
    Example 2, a 4 on a par 5 (a birdie) - F5=3, F3=5, so F5-F3 = -1
    Example 3, a 5 on a par 5 (a par) - F5=5, F3=5, so F5-F3 = 0
    Example 4, a 6 on a par 5 (a bogie) - F5=6, F3=5, so F5-F3 = +1
    Example 5, a 7 on a par 5 (a double bogie) - F5=7, F3=5, so F5-F3 = +2

  6. #6
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Golf Tracking Help!

    Quote Originally Posted by Dswags115 View Post
    Thank you, but I need to know if the golfer was -1 or -2 relative to the value. If the hole is a par 5 and he has an eagle (3) I need it to return the value as -2 or if he had a birdie (4) as -1.
    I think you might have been getting confused over the cell format. The '+0;-0;0' is not what will be returned in the cell, it is just the format of the number in the cell. It will be a whole number with a '+' in front of it if it is positive, it will be a whole number with a '-' in front of it if it is negative, and it will be 0, if the number = zero.

  7. #7
    Registered User
    Join Date
    07-21-2017
    Location
    Richmond, KY
    MS-Off Ver
    2013
    Posts
    3

    Re: Golf Tracking Help!

    I was totally over thinking this one! Thanks for bringing me back down to earth

+ 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. A Little golf help
    By mckenph in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-04-2015, 09:02 PM
  2. Golf pro that needs help
    By onin2golf in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 04-21-2014, 02:21 PM
  3. golf
    By johnandrews22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2013, 11:52 AM
  4. Golf Groupings
    By Traymond in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2009, 11:54 AM
  5. Replies: 0
    Last Post: 04-04-2006, 07:45 AM
  6. [SOLVED] excel for tracking golf scores or handicap
    By RJ in forum Excel General
    Replies: 0
    Last Post: 01-17-2006, 12:45 AM

Tags for this Thread

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