I need to create a template with formula to calculate statutory redudancy pay. There are differnent payments dependent on your age and a weeks’ pay is capped at £489 (maximum years service is capped at 20 years too)- please see below. Could you kindly assist me in the formulae that would do this if i had age and years of service in cells A2 and B2 respectively?
Many thanks in advance!!