I am attempting to create a spreadsheet that will list the number of vacation days earned per year by each employee. The earning rate is as follows:
0 to < 1 year = 15 days
1 to >= 7 years = 20 days
7 to >=15 years = 25 days
15 to >= 25 years = 30 days
>25 = 35 days
With the exception of the 0 to 1 year employees and the over 25 year employees, this formula yeilds the correct answer. Where G2 (37.31) lists the years of service. The problem I'm having is that I can not total this column. Once I have all the individual employee vacation earnings calculated, I need the sum of all vacation days for all employees. The answer my formula yeilds although correct is purely a text and will not total.
=IF(G2>=15,"30",IF(G2>7,"25",IF(G2>1,"20","")))
Sample
Name On Site Hire Date Other Today Srv Days Srv Yrs
Sterle, T 8/24/93 8/24/70 1/26/87 12/5/07 13617 37.31 30
Sterle, A 2/13/94 2/13/92 8/10/88 12/5/07 5774 15.82 25
Brangard 7/31/94 7/31/00 2/4/91 12/5/07 2683 7.35 25
Freoni 8/28/94 8/28/02 8/15/88 12/5/07 1925 5.27 20
Jackson 7/2/95 7/2/05 11/13/89 12/5/07 886 2.43 20
Any help would be greatly appreciated.
NPA Sr.
Bookmarks