Hi all,
I've done my best to research my issue, but have so far come up blank and am hoping for some of your expert assistance.
I am having some trouble with using the IF function to calculate the vacation entitlement of employees with a certain tenure. I would like to stipulate that an employee whose tenure is less than 5 years would get 80 hours of vacation, but if 5 or more years, would get 120 hours of vacation.
On my spreadsheet, Column D displays the years of tenure. However, what I think is throwing a wrench into things is that the values in column D are not straight numbers I've typed in, but values I calculated using the DATEDIF function.
The below formula is what I've been using:
=IF(D2<5, "80", "120")
Now, the issue I'm running into is thatthe answer always ends up being 120, even if the value in column D is less than 5 years. I'm thinking this is because the data in D2 is not a straight number, but a calculation
Any assistance in helping me correct this would be greatly appreciated, and thank you in advance! If there's any other info I can provide, please let me know.
I've done my best to research my issue, but have so far come up blank and am hoping for some of your expert assistance.
I am having some trouble with using the IF function to calculate the vacation entitlement of employees with a certain tenure. I would like to stipulate that an employee whose tenure is less than 5 years would get 80 hours of vacation, but if 5 or more years, would get 120 hours of vacation.
On my spreadsheet, Column D displays the years of tenure. However, what I think is throwing a wrench into things is that the values in column D are not straight numbers I've typed in, but values I calculated using the DATEDIF function.
The below formula is what I've been using:
=IF(D2<5, "80", "120")
Now, the issue I'm running into is thatthe answer always ends up being 120, even if the value in column D is less than 5 years. I'm thinking this is because the data in D2 is not a straight number, but a calculation
Any assistance in helping me correct this would be greatly appreciated, and thank you in advance! If there's any other info I can provide, please let me know.