| 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) | |||
![PZ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
