• Resolved robb1e

    (@robb1e)


    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 1pt

    Therefore 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 ??

Viewing 1 replies (of 1 total)
  • Roch

    (@rochesterj)

    Hi Robbie

    Thanks for reaching out!

    We are discussing this in the Pro channel so I’ll close this one.

    Thanks!

Viewing 1 replies (of 1 total)
  • The topic ‘any help with a formula’ is closed to new replies.