any help with a formula
-
Helolo Everyone
I need help with a formula if possible.
Team A v Team B
1 match consists of 4 games. every game you win you get 2 pts. if a game is drawn you share the points so get 1pt each.
after the 4 games have been played the total shots for each team is added up and whichever team has the most they get 1 additional point. if the aggregate shots is equal then that point is shared so each team gets 0.5 pt each.Team A wins 3 games so they get 6 pts
Team B won the last game so they get 2pts
Aggregate shots total is Team A have 72, Team B Have 64.
Team A has highest aggregate shot total so Team A get an additional 1ptTherefore Team A win 7-2 and both teams get those points added to the league Team A +7 and Team B +2
I hope you can help with this formula
Thank you in advance.
Robbie Hendry
ps ive changed the variable names to make it easier to follow along i hope ??
- The topic ‘any help with a formula’ is closed to new replies.