N
neo314trinity
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
b4=b3-2 but if b1=3 & b2=4 then b4=b3
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Hi!
Here's a sample file that will give you some ideas:
http://s54.yousendit.com/d.aspx?id=313OVCDZEWGND29PSG68HQ9SSC
It'll handle handicaps up to 54.
Biff
Here's a sample file that will give you some ideas:
http://s54.yousendit.com/d.aspx?id=313OVCDZEWGND29PSG68HQ9SSC
It'll handle handicaps up to 54.
Biff
F
Fred Smith
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.
=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.
B
Biff
=if(and(b1=36,b2=1),b3-2,if(and(b1=3,b2=4),b3,"?"))
My interpretation:
B1 is the players hdcp
B2 is the hole hdcp
B3 is the players gross score for that hole
Biff
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
N
neo314trinity
Thanks Biff
just what i needed and your interpretation was spot on!
just what i needed and your interpretation was spot on!
B
Biff
You're welcome. Thanks for the feedback!
Biff
Biff
neo314trinity said:Thanks Biff
just what i needed and your interpretation was spot on!