IF or IFS for a between number formula

[Breadnjam18]

Ok so Im trying to create a formula to calculate between some dates in excel

Start Date	Years Service	Std Holiday Entitlement	Result
28/08/2018​	2​	20​	20

So have most of it but not quite all.

Basically what i need is if the years service is grater than 5 but less than 10 then add 1 (or result in 21) and if greater than 10 add two. I have half of the formula sorted as if its greater than 10 its adds two, but i cant figure out the between 5-10 part. here is what i have

=IFS(D6<=5, "20",D6>5<10,"21", D6>10,"22")

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(D6<=5,20,IF(D6<=10,21,22))

 

[Breadnjam18]

Thank you, i knew it would be something simple!!

 

[Fluff]

You're welcome & thanks for the feedback.