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