Finding the formula

i have a spreadsheet for a sports team. i have the formula for scores example. A2 = 13, B2 = 7. IF(A2>B2,”Win”,IF(B2>A2,”Loss”,IF(A2=B2,”Draw”))). So this = Win

 

i have three different games. first result = Win, second & third result = Loss.

 

i am trying to figure out the formula so i can have total “Win” divided by total games.

By: Jackson Bryant-Kelly

One thought on “Finding the formula

  1. Jackson Bryant-Kelly

    Edit:

    i have a spreadsheet for a sports team. i have the formula for scores example. A2 = 13, B2 = 7. IF(A2>B2,”Win”,IF(B2>A2,”Loss”,IF(A2=B2,”Draw”))). So this = Win

    i have three different games. first result = Win, second & third result = Loss.

    i am trying to figure out the formula so i can have total “Win” divided by total games.

    i am trying to determine our win percentage, without having to manually input.

Leave a Reply

Your email address will not be published. Required fields are marked *