Results 1 to 2 of 2

Thread: Stumped on Boolean construct

  1. #1

    Question Stumped on Boolean construct



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

    I have spreadsheet that attempts to figure out the net score on a hole in golf, where the number of strokes given is determined by the individual's handicap and the handicap rating for a given hole.

    Specifically:
    A -Individ handicap = 0 - 27
    B -Hole handicap = 1 - 18
    C- Gross strokes on that hole = 1 - 9

    Need a formula that will cause
    0 strokes to be deducted from the gross strokes if A < B
    1 stroke to be deducted from the gross strokes if A is > B, and B is less than 19
    2 strokes to be deducted from the gross strokes i A is >B, and B > 18

    Make sense? What would be the formula to do that? Thanks.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,491
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =C2-IF(A2>B2,IF(B2<19,1,2),0)


    where C2 contains the Strokes, A2 contains Individ handicap and B2 contains Hole handicap.


Posting Permissions

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