+ Reply to Thread
Results 1 to 6 of 6

golf handicap

  1. #1
    neo314trinity
    Guest

    golf handicap

    Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1 then
    b4=b3-2 but if b1=3 & b2=4 then b4=b3

  2. #2
    Biff
    Guest

    Re: golf handicap

    Hi!

    Here's a sample file that will give you some ideas:

    http://s54.yousendit.com/d.aspx?id=3...D29PSG68HQ9SSC

    It'll handle handicaps up to 54.

    Biff

    "neo314trinity" <neo314trinity@discussions.microsoft.com> wrote in message
    news:2FC81D78-C499-4D2A-8612-634E42F6C8A1@microsoft.com...
    > Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1
    > then
    > b4=b3-2 but if b1=3 & b2=4 then b4=b3




  3. #3
    Fred Smith
    Guest

    Re: golf handicap

    To do what you've asked you would put this formula in B4:

    =if(and(b1=36,b2=1),b3-2,if(and(b1=3,b2=4),b3,"?"))

    I don't know what this has to do with golf handicaps though.

    --
    Regards,
    Fred


    "neo314trinity" <neo314trinity@discussions.microsoft.com> wrote in message
    news:2FC81D78-C499-4D2A-8612-634E42F6C8A1@microsoft.com...
    > Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1 then
    > b4=b3-2 but if b1=3 & b2=4 then b4=b3




  4. #4
    Biff
    Guest

    Re: golf handicap

    >=if(and(b1=36,b2=1),b3-2,if(and(b1=3,b2=4),b3,"?"))

    >I don't know what this has to do with golf handicaps though.


    My interpretation:

    B1 is the players hdcp
    B2 is the hole hdcp
    B3 is the players gross score for that hole

    Biff

    "Fred Smith" <fredsmith99@yahoo.com> wrote in message
    news:eEm6Hk8RGHA.2300@TK2MSFTNGP11.phx.gbl...
    > To do what you've asked you would put this formula in B4:
    >
    > =if(and(b1=36,b2=1),b3-2,if(and(b1=3,b2=4),b3,"?"))
    >
    > I don't know what this has to do with golf handicaps though.
    >
    > --
    > Regards,
    > Fred
    >
    >
    > "neo314trinity" <neo314trinity@discussions.microsoft.com> wrote in message
    > news:2FC81D78-C499-4D2A-8612-634E42F6C8A1@microsoft.com...
    >> Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1
    >> then
    >> b4=b3-2 but if b1=3 & b2=4 then b4=b3

    >
    >




  5. #5
    neo314trinity
    Guest

    Re: golf handicap

    Thanks Biff
    just what i needed and your interpretation was spot on!
    "Biff" wrote:

    > Hi!
    >
    > Here's a sample file that will give you some ideas:
    >
    > http://s54.yousendit.com/d.aspx?id=3...D29PSG68HQ9SSC
    >
    > It'll handle handicaps up to 54.
    >
    > Biff
    >
    > "neo314trinity" <neo314trinity@discussions.microsoft.com> wrote in message
    > news:2FC81D78-C499-4D2A-8612-634E42F6C8A1@microsoft.com...
    > > Newbie alert, could anyone help with a formula for this: if b1=36 & b2=1
    > > then
    > > b4=b3-2 but if b1=3 & b2=4 then b4=b3

    >
    >
    >


  6. #6
    Biff
    Guest

    Re: golf handicap

    You're welcome. Thanks for the feedback!

    Biff

    "neo314trinity" <neo314trinity@discussions.microsoft.com> wrote in message
    news:4CA585D5-00C7-42F2-AADD-6AAD0079944E@microsoft.com...
    > Thanks Biff
    > just what i needed and your interpretation was spot on!
    > "Biff" wrote:
    >
    >> Hi!
    >>
    >> Here's a sample file that will give you some ideas:
    >>
    >> http://s54.yousendit.com/d.aspx?id=3...D29PSG68HQ9SSC
    >>
    >> It'll handle handicaps up to 54.
    >>
    >> Biff
    >>
    >> "neo314trinity" <neo314trinity@discussions.microsoft.com> wrote in
    >> message
    >> news:2FC81D78-C499-4D2A-8612-634E42F6C8A1@microsoft.com...
    >> > Newbie alert, could anyone help with a formula for this: if b1=36 &
    >> > b2=1
    >> > then
    >> > b4=b3-2 but if b1=3 & b2=4 then b4=b3

    >>
    >>
    >>




+ 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