View Single Post
  #1   Report Post  
Lori1218 Lori1218 is offline
Junior Member
 
Posts: 3
Default Nested IF Formula

I am having a problem creating a formula . what I am trying to do is working off a changing date to see what accrual rate is for vacation time. My todays date is in C2. Employees accrue at different rates per so many years
Vac Accrual 6.25(F1) 9.38(G1) 12.5(H1) 15.63(I1)
Hire Date 6/1/199(F2) 7/8/1997(G2) 7/29/2003 (H2) 7/16/2013 (I2)

Today is 8/30/2008
=IF(F2=MONTH(C2),"6.25",IF(G2=MONTH(C2),"9.38",I F(H2=MONTH(C2),"12.5",15.63)))

I tried this formula and I am way off. I have never done a nested if function. Could some please help.

Last edited by Lori1218 : August 31st 08 at 12:19 AM