View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PZ[_2_] PZ[_2_] is offline
external usenet poster
 
Posts: 3
Default Making a formula Work....

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