nested if statement

[RedOctoberKnight]

Good Morning,

Probably pretty easy for you guys.

Looking to do a nested if statement for a vacation accrual calculator.

Basically I have a hire date in B1. In C1 in want to do a nested if statement with the following parameters.

if B1 is less than 1 year from date in A1 (first day of calendar year) then 0 days
if B1 is from 1 year to 5 years, then 10 days
if B1 is from 6 years to 10 years, then 15 days
if B1 is from 11 years to 17 years, 20 days
if B1 is greater than 18 years from date in A1, then 25 days.

 

[Joe4]

Try this:

=IF(INT(YEARFRAC(A1,B1))>=18,25,IF(INT(YEARFRAC(A1,B1))>=11,20,IF(INT(YEARFRAC(A1,B1))>=6,15,IF(INT(YEARFRAC(A1,B1))>=1,10,0))))