Multiple IF Function
Teri wrote:
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(U11,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?
You are already handling U<=1 with
U1*6.667
So I presume you want that to apply to U=1 only and do something
different for U<1:
=(IF(U11,MONTH(E8)*6.667,IF(U=1,U1*6.667,[your U<1 rule here]))-6.6667)
|