Forum Discussion
Vacation Tracker
As suggested by erol sinan zorlu, you could use one of the several LOOKUP functions with a table to yield number of days earned based on length of employment.
As you suggested in your first question, you could also use IF or IFS.
A lot would actually depend on how granular the system is within which these vacation days are being earned. Is it a clearly demarked step system, with something happening after precisely five years and every multiple of five thereafter? Or are vacation days earned more gradually during the course of time, even each year? Or is it a combination?
So it would help if you could be more descriptive of the rules that apply in your situation. As is generally true in Excel, there will no doubt be multiple potential answers, but which one is most effective will depend on more details.