Home

HELP I CAN WRITE THIS IF FUNCTION

%3CLINGO-SUB%20id%3D%22lingo-sub-883640%22%20slang%3D%22en-US%22%3EHELP%20I%20CAN%20WRITE%20THIS%20IF%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883640%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20write%20a%20function%20that%20does%20this.%20if%20salary%20grade%20falls%20between%2010%20-%2020%20then%20number%20of%20years%20then%20the%20allocations.%20HELP%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3ESalary%20Level%3C%2FTD%3E%3CTD%3EMin%20Sev%20after%201%20full%20year%20of%20service%3C%2FTD%3E%3CTD%3E5%20years%20-%2010%20years%3C%2FTD%3E%3CTD%3E10%20or%20more%20years**%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E10%20-%2020%3C%2FTD%3E%3CTD%3E4%20weeks%3C%2FTD%3E%3CTD%3E8%20weeks%3C%2FTD%3E%3CTD%3E12%20weeks%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E22%20-%2035%3C%2FTD%3E%3CTD%3E8%20weeks%3C%2FTD%3E%3CTD%3E12%20weeks%3C%2FTD%3E%3CTD%3E16%20weeks%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E40%20-%2055%3C%2FTD%3E%3CTD%3E12%20weeks%3C%2FTD%3E%3CTD%3E18%20weeks%3C%2FTD%3E%3CTD%3E26%20weeks%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E60%3C%2FTD%3E%3CTD%3E26%20weeks%3C%2FTD%3E%3CTD%3E34%20weeks%3C%2FTD%3E%3CTD%3E39%20weeks%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-883640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-885945%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20I%20CAN%20WRITE%20THIS%20IF%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-885945%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F417673%22%20target%3D%22_blank%22%3E%40hurshie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20your%20table%20is%20in%20A1%3AD5%2C%20the%20salary%20level%20is%20in%20F2%2C%20and%20the%20years%20of%20service%20are%20in%20G2%2C%20then%3A%3C%2FP%3E%3CP%3E%3DINDEX(%24A%241%3A%24D%245%2CIF(%24F%242%26lt%3B%3D20%2C1%2CIF(%24F%242%26lt%3B%3D35%2C2%2CIF(%24F%242%26lt%3B%3D55%2C3%2CIF(%24F%242%3D60%2C4%2C%22%22))))%2CIF(%24G%242%26lt%3B5%2C1%2CIF(%24G%242%26lt%3B10%2C2%2CIF(%24G%242%26gt%3B%3D10%2C3%2C%22%22))))%3C%2FP%3E%3C%2FLINGO-BODY%3E
hurshie
Occasional Visitor

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 LevelMin Sev after 1 full year of service5 years - 10 years10 or more years**
10 - 204 weeks8 weeks12 weeks
22 - 358 weeks12 weeks16 weeks
40 - 5512 weeks18 weeks26 weeks
6026 weeks34 weeks39 weeks
1 Reply

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

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