J
jg53
I am trying to come up with a formula for the following situation:
I have 4 cells that get a sum, divide by 4, subtract 36. This is
formula to come up with a user's golf handicap. The problem is if
take the four previous cells and divide by 4 the handicap is wron
because I would really have to divide it by 3 instead to get th
correct handicap. This is the formula I am using:
=ROUND(SUM(B4:B6)/4-36,0). Now if I take this same formulate and th
user missed a game, I would only divide it by 3 to get the correc
handicap I assume. I does make a difference in the answer as I trie
it manually even to see if I was thinking it through wrong. Fo
example, say a user had 3 games so far. Of those 3, scores of 45, 50,
because he missed one. If I add those up and divide by only 2 games i
comes up with a different answer than if it is divided by 3. How woul
you create the formulate that if the cell is 9, divide by 3 instead o
4
I have 4 cells that get a sum, divide by 4, subtract 36. This is
formula to come up with a user's golf handicap. The problem is if
take the four previous cells and divide by 4 the handicap is wron
because I would really have to divide it by 3 instead to get th
correct handicap. This is the formula I am using:
=ROUND(SUM(B4:B6)/4-36,0). Now if I take this same formulate and th
user missed a game, I would only divide it by 3 to get the correc
handicap I assume. I does make a difference in the answer as I trie
it manually even to see if I was thinking it through wrong. Fo
example, say a user had 3 games so far. Of those 3, scores of 45, 50,
because he missed one. If I add those up and divide by only 2 games i
comes up with a different answer than if it is divided by 3. How woul
you create the formulate that if the cell is 9, divide by 3 instead o
4