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
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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
>=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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>
>
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
You're welcome. Thanks for the feedback!
Biff
"neo314trinity" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
>> message
>> news:[email protected]...
>> > 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)
Bookmarks