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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" 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" wrote in
message
...
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