mercredi 1 avril 2015

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