|
Bowling: Handicap between Teams
hi!
What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
Let's say the different teams averages are stored on worksheet Sheet2 in
cells A1:A10. Calculate the Team handicap (and store B1:B10) as the following: =max(A$1:A$10)-A1 Copy down to B10. HTH, Barb Reinhardt "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
Correction
=(MAX(A$1:A$10)-A1)*0.8 "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
That does not work, cause you are saying to find the mx number in a colums
and susbstarct that same number.... I tried it! "Barb Reinhardt" wrote: Correction =(MAX(A$1:A$10)-A1)*0.8 "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
Barb's formula produces these results which is what you asked for:
Team 2 gets 120pins Handicap team 3 shoiuld have 240pins handicap and so on... ...........A..........B 1.......900.........0 2.......750.....120 3.......600.....240 4.......850.......40 Biff "Yan" wrote in message ... That does not work, cause you are saying to find the mx number in a colums and susbstarct that same number.... I tried it! "Barb Reinhardt" wrote: Correction =(MAX(A$1:A$10)-A1)*0.8 "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
OK! but my question is
That if in A1 the value is 500, Therefore with the formulas, i am asking find the Maximum number in rows A1:A10 witch equal to 500 and substract the same value, multuiply by 80%... so basically, is 500-500*80%=0 "T. Valko" wrote: Barb's formula produces these results which is what you asked for: Team 2 gets 120pins Handicap team 3 shoiuld have 240pins handicap and so on... ...........A..........B 1.......900.........0 2.......750.....120 3.......600.....240 4.......850.......40 Biff "Yan" wrote in message ... That does not work, cause you are saying to find the mx number in a colums and susbstarct that same number.... I tried it! "Barb Reinhardt" wrote: Correction =(MAX(A$1:A$10)-A1)*0.8 "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
Maybe, i am not understanding exactly, but i have try that formulas and comes
with 0 value! I need to find the max in colums and subsract the actual Highest - Minest * 80% So, like Team 1 equal 900, minus Team 2 = 750 *80% and so on! "T. Valko" wrote: Barb's formula produces these results which is what you asked for: Team 2 gets 120pins Handicap team 3 shoiuld have 240pins handicap and so on... ...........A..........B 1.......900.........0 2.......750.....120 3.......600.....240 4.......850.......40 Biff "Yan" wrote in message ... That does not work, cause you are saying to find the mx number in a colums and susbstarct that same number.... I tried it! "Barb Reinhardt" wrote: Correction =(MAX(A$1:A$10)-A1)*0.8 "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
Sorry! My mistake, it is working...Thx a Lot....!
Biff and Barb "Yan" wrote: Maybe, i am not understanding exactly, but i have try that formulas and comes with 0 value! I need to find the max in colums and subsract the actual Highest - Minest * 80% So, like Team 1 equal 900, minus Team 2 = 750 *80% and so on! "T. Valko" wrote: Barb's formula produces these results which is what you asked for: Team 2 gets 120pins Handicap team 3 shoiuld have 240pins handicap and so on... ...........A..........B 1.......900.........0 2.......750.....120 3.......600.....240 4.......850.......40 Biff "Yan" wrote in message ... That does not work, cause you are saying to find the mx number in a colums and susbstarct that same number.... I tried it! "Barb Reinhardt" wrote: Correction =(MAX(A$1:A$10)-A1)*0.8 "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
Well, now I'm not following you.
If you change A1 to 500, A1 is no longer the max value in the range and the results would be: ...........A..........B 1.......500......280 2.......750... ..80 3.......600.... .200 4.......850..........0 It would help if you could should show us an example with the desired results. Biff "Yan" wrote in message ... OK! but my question is That if in A1 the value is 500, Therefore with the formulas, i am asking find the Maximum number in rows A1:A10 witch equal to 500 and substract the same value, multuiply by 80%... so basically, is 500-500*80%=0 "T. Valko" wrote: Barb's formula produces these results which is what you asked for: Team 2 gets 120pins Handicap team 3 shoiuld have 240pins handicap and so on... ...........A..........B 1.......900.........0 2.......750.....120 3.......600.....240 4.......850.......40 Biff "Yan" wrote in message ... That does not work, cause you are saying to find the mx number in a colums and susbstarct that same number.... I tried it! "Barb Reinhardt" wrote: Correction =(MAX(A$1:A$10)-A1)*0.8 "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
Bowling: Handicap between Teams
Sorry it is working my mistake.....BIll! "T. Valko" wrote: Well, now I'm not following you. If you change A1 to 500, A1 is no longer the max value in the range and the results would be: ...........A..........B 1.......500......280 2.......750... ..80 3.......600.... .200 4.......850..........0 It would help if you could should show us an example with the desired results. Biff "Yan" wrote in message ... OK! but my question is That if in A1 the value is 500, Therefore with the formulas, i am asking find the Maximum number in rows A1:A10 witch equal to 500 and substract the same value, multuiply by 80%... so basically, is 500-500*80%=0 "T. Valko" wrote: Barb's formula produces these results which is what you asked for: Team 2 gets 120pins Handicap team 3 shoiuld have 240pins handicap and so on... ...........A..........B 1.......900.........0 2.......750.....120 3.......600.....240 4.......850.......40 Biff "Yan" wrote in message ... That does not work, cause you are saying to find the mx number in a colums and susbstarct that same number.... I tried it! "Barb Reinhardt" wrote: Correction =(MAX(A$1:A$10)-A1)*0.8 "Yan" wrote: hi! What i am trying to do is to make a formulas on the master sheet that will change weekly the Handicap of the teams... Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take that different at a 80% value and giev it to team 2 score.... But, the problem i have is that, their is 10 Teams in the league, therefore the formuilas need to check the Teams average on the teams page and then assign the correct Handicap to each team in the master sheets... Ex: T1 = 900 ave. t2 = 750 T3=600 T4= 850 Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets 120pins Handicap Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have 240pins handicap and so on... Basically, the Highest average Team, gives Handicap to other teams....This can change weekly, Team or Handicap.. Thx you! |
| All times are GMT +1. The time now is 04:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com