| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with formula
On Jan 15, 8:07*pm, joeu2004 wrote:
On Jan 15, 4:00*pm, Gil wrote: the conditions are a sliding scale based on days accrued. *example: 16-99 days @20% 100-149 days@30% * * * *150-200@40% * * 201+ @50%. *IF a person has 155 days on the books, the first 15 are not paid, then the days between 16-99 are paid at 20% value, the days between 100-149 days are paid at 40%. Following the examples athttp://www.mcgimpsey.com/excel/variablerate.html (which provides alternatives that you might also want to consider), I think the following would meet your needs: =round(B1 * sumproduct(--(A1{15,99,149,200}), A1-{15,99,149,200}, {0.2,0.1,0.1,0.1}), 2) where A1 is the number of sick days, and B1 is the value of a sick day. worked nicely....thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
![Gil[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
