View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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)