View Single Post
  #1   Report Post  
Elaine
 
Posts: n/a
Default 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