i am trying to create a calculator of sorts in excel....rather, it is
going to calculate the value in dollars for a sick day buy back at
retirement.

i have no problem writing the formulas to calculate the differnt
percentages, The idea is one someone is getting ready to retire, they
can enter their salary into one field and the number of days they have
in their sick bank. the spread sheet would tell them how much they
might be getting back.

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%.

what i did was try to write a set of formulas that look at the number
of days entered into one cell the "155" and then calculate how many
days fall into each catagory then calculate the money for each
catagory. once done it would total it up.

the problem is the "if" formula will not let me set more then one
formula. the first cat works fine since there is not an upper and
lower limit but the others i can't figure out how to set up two
parameters. the formula i had was "=IF(B8=50,SUM(C4-149),0))" it
does the lower limit fine, but when the number of days exceeds the
cat, it keeps adding them in. so by the time you get to the end, the
days are too many.

i've never used the solver and i can't seem to figure it out. any
help would be appreciated.