PLEASE, HELP My table will be attached. I need an excel formulas.
If the seniority is less than 5 years there is no bonus.
•If the seniority is greater than 5 years and less than 15 years the bonus is 15% of the salary.
•If the seniority is greater than 15 years the bonus is 20% of the salary.
•Payment.
•Display the list of employees whose seniority is greater than 15 years.
•Display the list of employees (name and surname) who had been hired the current year and have their payment under average.
•How many employees haven’t received a bonus?
•What’s the total amount of money paid to the employees with seniority greater or equal to 15 years?