In the Comp Days column, enter a formula with nested IFs to display the number of comp days that an employee will receive based on their years of service. The table for Comp Days is on the second worksheet. Remember to use absolute references to the cells in the second worksheet because the formula will be copied to the entire column.
Bookmarks