T
Teri
I am trying to calculate accrued vacation. Our employees accrue 6.667
hours/month. For someone who has more than one year of service, I have the
following formula:
=(IF(U1>1,MONTH(E8)*6.667,U1*6.667)-6.6667)
U1 = Years of service
E8 = TODAY()
I need to add a nested function to the above which would calculate the
accrual if Cell U1 is <1. Can anybody help?
hours/month. For someone who has more than one year of service, I have the
following formula:
=(IF(U1>1,MONTH(E8)*6.667,U1*6.667)-6.6667)
U1 = Years of service
E8 = TODAY()
I need to add a nested function to the above which would calculate the
accrual if Cell U1 is <1. Can anybody help?