-
Join the MyBroadband community
South Africa’s biggest forum. Discuss, discover, and connect with thousands of members.
-
Question of the Day: What's the most interesting small town you've visited in South Africa?
Could you perhaps explain what you need in more detail ?
Ho3n3r
Honorary Master
But if it's a win/loss ratio, the Submitted value wouldn't play a role, correct, since win/loss does not include not-as-yet-determined results?
If so, the formula would be:
= A2 / GCD(A2, B2) & ":" & B2 / GCD(A2, B2)
This is when having A2 as no. of wins, and B2 as number of losses. If you add C2 as Submitted and you want a win/loss/submitted ratio, the formula is:
= A2 / GCD(A2, B2, C2) & ":" & B2 / GCD(A2, B2, C2) & ":" & C2 / GCD(A2, B2, C2)
According to logic, Submitted will not be able to fall under either Win or Loss, as it represents neither - an undefined result, if you like.
Hope this helps.
If so, the formula would be:
= A2 / GCD(A2, B2) & ":" & B2 / GCD(A2, B2)
This is when having A2 as no. of wins, and B2 as number of losses. If you add C2 as Submitted and you want a win/loss/submitted ratio, the formula is:
= A2 / GCD(A2, B2, C2) & ":" & B2 / GCD(A2, B2, C2) & ":" & C2 / GCD(A2, B2, C2)
According to logic, Submitted will not be able to fall under either Win or Loss, as it represents neither - an undefined result, if you like.
Hope this helps.