I am stuck and need some help.
I have to calculate bonuses for employees using IF statements based on their salary, age (no bonus until 50) and years of employment. I have the table set up as follows:
Employee Age Length of Service Salary
<5 = 0 bonus
5-10 =20%
11-15=30%
16-20=40%
21-25=50%
26 or more =100% of yearly salary
I am very stuck and really could use some advise.
Thank you so much in advance. I am starting to see stars with my frustration.....
Bookmarks