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

Making a formula Work....
 

Try this
=IF(H2=MAX($H$2:$H$15),14,0)/COUNTIF($H$2:$H$15,MAX($H$2:$H$15))

You need the $ (absolute references) so you can copy the formula down the
column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PZ" wrote in message
...
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

Making a formula Work....
 

That worked very well. Thanks! First time doing this type of thing/

"Bernard Liengme" wrote:

Try this
=IF(H2=MAX($H$2:$H$15),14,0)/COUNTIF($H$2:$H$15,MAX($H$2:$H$15))

You need the $ (absolute references) so you can copy the formula down the
column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PZ" wrote in message
...
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