• 461K Members
• 5,456 Online
• 559K Conversations

## HELP I CAN WRITE THIS IF FUNCTION

Occasional Visitor

# HELP I CAN WRITE THIS IF FUNCTION

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

# Re: HELP I CAN WRITE THIS IF FUNCTION

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,""))))

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies