need percent to update

  • Thread starter Thread starter jfab
  • Start date Start date
J

jfab

Here is what my problem is;

W L T %
team a 1 1 1 .333
my formula for getting this is :
=IF(ISERROR(SUM(E28)/(E28+F28+G28)),0,(E28)/(E28+F28+G28))
as you can see it does give me the correct %, but the fact of th
matter is the % is off by .167 %.
in other words:
W L T %
1 1 0 .500
1 2 0 .333
2 1 0 .667
a tie is consider a whole game won or lost.
a team with a 1 - 1 -1 record should have a percentage of .416%.

the difference between .500 and .333 is .167.
so if you take 1/2 of the .167 that is .083.
add the .083 to the .333 and you get .416.

does any one out there have a solution to this?

what if there are more than 1 tie?

any help would be apprciated.

thank
 
I think that most people say that a tie is half a win and half a loss.

so a record of 1-1-1 should be considered the same as 1.5-1.5-0 (w-l-t).
That means that the percentage is still .500.

If you agree:

=if(count(e28:g28)=0,0,(e28+.5*g28)/sum(e28:g28))


If this isn't correct for you, what do you mean by:
"a tie is consider a whole game won or lost."

Does that mean you add the number of ties to both the number of wins and losses?
 
Back
Top