ZWICK 4 PREZ
Posts: 7,733
Aug 12, 2015 2:29pm
I'm making a worksheet for a golf league...
Player A is an 8 handicap and Player B is 4 handicap
How do I calculate the difference between their handicaps (4) and assign 4 strokes to the lowest handicap holes ?
Player A is an 8 handicap and Player B is 4 handicap
How do I calculate the difference between their handicaps (4) and assign 4 strokes to the lowest handicap holes ?
Belly35
Posts: 9,716
Aug 12, 2015 2:50pm
I'll get back to you later...
sleeper
Posts: 27,879
Aug 12, 2015 2:52pm
One hell of an 'if' statement.
ZWICK 4 PREZ
Posts: 7,733
Aug 12, 2015 3:03pm
Yeah I have one and i can't get it out of error. So I'm hoping someone can figure it out.sleeper;1745569 wrote:One hell of an 'if' statement.
ZWICK 4 PREZ
Posts: 7,733
Aug 12, 2015 3:05pm
I'm thinking there's no way to do this without using VBE?
ZWICK 4 PREZ
Posts: 7,733
Aug 12, 2015 4:57pm
i got it.. thanks for nothing lol jk
G
gut
Posts: 15,058
Aug 12, 2015 8:23pm
I thought you were an engineer....
if(min(A,B)=A, A+abs(A-B),B+abs(A-B))...that's your total value.
Then use a lookup table that distributes the handicap according to the number. So if you're doing up to 36 handicap, you might need 36 distributions for a differential of 1-36.
if(min(A,B)=A, A+abs(A-B),B+abs(A-B))...that's your total value.
Then use a lookup table that distributes the handicap according to the number. So if you're doing up to 36 handicap, you might need 36 distributions for a differential of 1-36.
ZWICK 4 PREZ
Posts: 7,733
Aug 12, 2015 9:21pm
gut;1745609 wrote:I thought you were an engineer....
if(min(A,B)=A, A+abs(A-B),B+abs(A-B))...that's your total value.
Then use a lookup table that distributes the handicap according to the number. So if you're doing up to 36 handicap, you might need 36 distributions for a differential of 1-36.
No, that's retarded
G
gut
Posts: 15,058
Aug 13, 2015 1:04am
It would have taken me about 10 minutes...how long did your non-retarded method take you before you posted asking how here?ZWICK 4 PREZ;1745615 wrote:No, that's retarded
ZWICK 4 PREZ
Posts: 7,733
Aug 13, 2015 5:46am
I have a formula based on simple addition. Why would I build a table when I can add 1+1?gut;1745644 wrote:It would have taken me about 10 minutes...how long did your non-retarded method take you before you posted asking how here?
The formula didn't take time at all, the 0 handicap was blowing up my formula since you can't have a "0th" smallest number in an array.