Softball League Standings

  • Resolved perianderson

    (@perianderson)


    4 years, 10 months ago

    Hello, Trying to add 2 points for a win, and 1 point for a tie, but I can’t seem to figure out the formula. It seems that the Home wins, are being calculated, and not the away wins. I only want to count a win as 2 points regardless if it’s a home or away win, and a tie as 1 point regardless if Home or Away.

    Cheers,

    Peri Anderson

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Roch

    (@rochesterj)

    4 years, 10 months ago

    Hi there!

    Thanks for reaching out.

    Can you send us a screenshot of your table column setup? I’d like to see your current formula so we can help you.

    Thanks!

    Thread Starter perianderson

    (@perianderson)

    4 years, 10 months ago

    Hello,

    Here is my League Table setup, and this is the results it is producing

    View post on imgur.com

    Ideally I want to see 2 points for the 3 teams with 1 win, and 0 points for the 3 teams that have lost. If there are any ties, I want 1 point awarded.

    Cheers,

    Peri Anderson

    Roch

    (@rochesterj)

    4 years, 10 months ago

    Hi Peri!

    Thanks for your reply.

    The formula gets the values form the values you add. So in your case the correct formula would be:

    Win * 2 + Tie

    You don’t need to multiply ties to 1, as the number of ties is there already.

    The formula you have right now is basically:
    Win + Tie + 3

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Softball League Standings’ is closed to new replies.