I'm trying to create a simple model to evaluate Overwatch teams. The equation I want to use divides map win by total maps in a given game then multiplies that by a difficulty rating i give the game. It looks like this:

(1/(N2/(N2+O2))*Q2)

N2=map wins

O2=map losses

Q2=difficulty

The issue I'm having is when a team doesn't win a game in the series so the equation ends up trying to divide 0 by the total games. Excel gives an error from this. The fix i came up with adds 1 game win to every series. That equation looks like this:

(1/((N2+1)/(N2+O2))*Q2)

I'm not happy with this though it seems that teams with a zero win series are punished to heavily. I'm not a math expert at all so just kind of winging it. Thanks for reading I hope it made sense.