Forum Discussion
Excel Formula
In order to write a totally reliable formula, you'll need to be a bit more comprehensive with your description.
It may seem obvious to you, but relying on the "obvious" can be a recipe for disaster.
So what you're doing is recording hours worked, a part of which is paid time off accrued under certain circumstances. You've only given two, neither one of which is intuitively obvious. If 80 hours means 2 hours of accrued paid time off, what does 79 hours mean? 1 hour accrued? How about 79.5? Etc.
What about 90 hours? Still only 2?
And if they're under 80 hours, is nothing accrued?
Not to be difficult; just wanting to be totally reliable.
How is your spreadsheet for tracking this organized? Would you be willing to post a copy (removing real names) on OneDrive or GoogleDrive, with a link here granting edit access.
The formula you're seeking is not going to be difficult, but how it would be constructed depends on how you are collecting and organizing the time worked in the first place.
At the simplest level, if the hours worked is in cell A1, =IF(A1>=80,2,0) will give you the answer 2 for any number equal to or greater than 80.
As I said in my first post, though (and writing as a person once responsible for the HR/Payroll database of a major corporation) , I would not be satisfied with that simple picture. There are too many questions, too many slightly different circumstances or contingencies, not addressed by that formula.