Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regarding NESTED IF formula | Excel Discussion (Misc queries) | |||
Nested if formula | Excel Discussion (Misc queries) | |||
Nested formula help | Excel Worksheet Functions | |||
Nested Formula help | Excel Discussion (Misc queries) | |||
Help with nested formula | Excel Discussion (Misc queries) |