excel help from you gurus

Home ▸ Archive ▸ Serious Business ▸ excel help from you gurus
ZWICK 4 PREZ's avatar

ZWICK 4 PREZ

Senior Member

7,733 posts
Aug 12, 2015 2:29 PM
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 ?
Aug 12, 2015 2:29pm
Belly35's avatar

Belly35

Elderly Intellectual

9,716 posts
Aug 12, 2015 2:50 PM
I'll get back to you later...
Aug 12, 2015 2:50pm
sleeper's avatar

sleeper

Legend

27,879 posts
Aug 12, 2015 2:52 PM
One hell of an 'if' statement.
Aug 12, 2015 2:52pm
ZWICK 4 PREZ's avatar

ZWICK 4 PREZ

Senior Member

7,733 posts
Aug 12, 2015 3:03 PM
sleeper;1745569 wrote:One hell of an 'if' statement.
Yeah I have one and i can't get it out of error. So I'm hoping someone can figure it out.
Aug 12, 2015 3:03pm
ZWICK 4 PREZ's avatar

ZWICK 4 PREZ

Senior Member

7,733 posts
Aug 12, 2015 3:05 PM
I'm thinking there's no way to do this without using VBE?
Aug 12, 2015 3:05pm
ZWICK 4 PREZ's avatar

ZWICK 4 PREZ

Senior Member

7,733 posts
Aug 12, 2015 4:57 PM
i got it.. thanks for nothing lol jk
Aug 12, 2015 4:57pm
G

gut

Senior Member

15,058 posts
Aug 12, 2015 8:23 PM
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.
Aug 12, 2015 8:23pm
ZWICK 4 PREZ's avatar

ZWICK 4 PREZ

Senior Member

7,733 posts
Aug 12, 2015 9:21 PM
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
Aug 12, 2015 9:21pm
G

gut

Senior Member

15,058 posts
Aug 13, 2015 1:04 AM
ZWICK 4 PREZ;1745615 wrote:No, that's retarded
It would have taken me about 10 minutes...how long did your non-retarded method take you before you posted asking how here?
Aug 13, 2015 1:04am
ZWICK 4 PREZ's avatar

ZWICK 4 PREZ

Senior Member

7,733 posts
Aug 13, 2015 5:46 AM
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?
I have a formula based on simple addition. Why would I build a table when I can add 1+1?
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.
Aug 13, 2015 5:46am