P
PZ
I am setting a spreadsheet that will automatically fill in points earned for
the week/year, etc.
Each week the winner(team with most points earned) gets $14.
I have found I can do that with:
=IF((H2>=(LARGE(H2:H15,1))),14,0)+week5!j2
However if two or more teams tie, what needs to be there in order to evenly
distribute that $14 amongst the the tied teams?
I would really appreciate the help! Thanks
the week/year, etc.
Each week the winner(team with most points earned) gets $14.
I have found I can do that with:
=IF((H2>=(LARGE(H2:H15,1))),14,0)+week5!j2
However if two or more teams tie, what needs to be there in order to evenly
distribute that $14 amongst the the tied teams?
I would really appreciate the help! Thanks