# golf handicap

1. ## 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. ## 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. ## 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. ## 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. ## 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. ## Re: golf handicap

You're welcome. Thanks for the feedback!

Biff

"neo314trinity" <neo314trinity@discussions.microsoft.com> wrote in message
> 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

>>
>>
>>

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

#### 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