How does it not work? It just returns a zero, so in that case the team doesn't get any points for opponent wins since there aren't any.
Triathlon Dude
offline
offline
math doesn't work with 0/1/2. Yes it will give you a zero, but there are () missing.
It should either be (0/1)/2 or 0/(1/2). It will matter the numbers get bigger.
Example with 4 games played.
4/4/2 gives you .5 in excel
(4/4)/2 also gives you .5 in excel
4/(4/2) gives a 2 though.
I was just asking for clarification on the matter, and to get the formula actually written correctly.
It should either be (0/1)/2 or 0/(1/2). It will matter the numbers get bigger.
Example with 4 games played.
4/4/2 gives you .5 in excel
(4/4)/2 also gives you .5 in excel
4/(4/2) gives a 2 though.
I was just asking for clarification on the matter, and to get the formula actually written correctly.
Euss
offline
offline
In this case the result wanted is .5 in your example, so no need for extra parentheses. Parentheses are used if you want to change the order in which the calculations are made, but in this case the 0/1/2 is the correct order. If you want to write it (0/1)/2 the result is the same but you just wasted 2 extra characters! It's all about saving the rainforests by using less characters 

You are not logged in. Please log in if you want to post a reply.





























