HELP I CAN WRITE THIS IF FUNCTION

[hurshie]

Hello,

I am trying to write a function that does this. if salary grade falls between 10 - 20 then number of years then the allocations. HELP

Salary Level	Min Sev after 1 full year of service	5 years - 10 years	10 or more years**
10 - 20	4 weeks	8 weeks	12 weeks
22 - 35	8 weeks	12 weeks	16 weeks
40 - 55	12 weeks	18 weeks	26 weeks
60	26 weeks	34 weeks	39 weeks

[#2]

@hurshie 

If your table is in A1:D5, the salary level is in F2, and the years of service are in G2, then:

=INDEX($A$1:$D$5,IF($F$2<=20,1,IF($F$2<=35,2,IF($F$2<=55,3,IF($F$2=60,4,"")))),IF($G$2<5,1,IF($G$2<10,2,IF($G$2>=10,3,""))))