how to contruct formula
I have a spreadsheet with employee names and years of service
Jane 4.65
Joe 2.50
Jill .85
I have data that indicates years and days
1 15
2 16
3 17 I need some form of formula that will allow me to search
the grid and place the correct number of days off by the number of years
service
|