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