Excel-Logical Function (Question#2 of 3)

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I am trying to calculate Additional Months of Service

Years of Add'l Mths
Service Due To Service
21 2

Here are my qualifiers:
----------------------------------------------------
If less than 10 years service = 0
If equal to 10 or greater than 10 but less than 20=1
If equal to 20 or greater than 20 = 2

I need this all in one formula. I have tried nesting and
I am not writing correctly or something. HELP !!! Frank
 
One way:

=INT(DATEDIF(<startdate>,<enddate>,"y")/10)

or, if you already have years of service in A2:

=INT(A2/10)
 
Back
Top