I want a cell to reflect how many vacation hours you get depending on how many years of service
CELL A1 1/3/2006
CELL J1 =YEAR(TODAY())
CELL B1 I want a formula that states if Cell A1 is less than 3yrs from CellJ1 input "75", if equal or more than 3yrs but less than 10 yrs input " 112" , if equal or more than 10 yrs input 150
Aucun commentaire:
Enregistrer un commentaire