A company has employees who receive severance based on time with the company
and the payments are made monthly. If they have been employed for 1 year or
more, they get 5 weeks. I know how to write the part of the formula that says
if an employee is let go AND they have been with the company more than 1
year, to calculate one month's severance. I need to show the payments over
each month until the # months they receive pmt is to end. What I can't figure
out is what to add to the formula to make it stop when their pmts run out.
Fields = Severance, Time with company, severance amount, date let go.