|
Featured Tutorial
Featured Macro
Excel Magic Trick 629: HR Salary Calculation Based On Relevant Years Worked (2 methods)
See the functions VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT, and INT to lookup Salary based Relevant Years worked. See two methods:
1) Non-array formula that takes up many cells in spreadsheet
2) Single cell array formula
1) Non-array formula that takes up many cells in spreadsheet
2) Single cell array formula