Excel Forum
Similar Content
Increment a Value Every X Number of Rows in Excel
Tutorial: How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial...
Delete Entire Rows Based on Predefined Criteria (Text)
Macro: This macro will allow you to specify certain criteria and then to delete rows based up...
Linking Cells in Excel
Tutorial: In this tutorial I am going to cover how to link cells together. This is a useful feature ...



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





Got a Question? Ask it Here in the Forum.