Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help! Getting a funtion to 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help! Getting a funtion to work.
easier.. if(Rank(H2,H2:H15)=1,14,0)+week5!j2
"PZ" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Funtion | Excel Discussion (Misc queries) | |||
Funtion between worksheets | Excel Discussion (Misc queries) | |||
If Funtion | Excel Worksheet Functions | |||
If funtion help | New Users to Excel | |||
IF funtion | Excel Discussion (Misc queries) |