LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regarding NESTED IF formula zen Excel Discussion (Misc queries) 4 June 16th 08 05:48 PM
Nested if formula ocuhcs Excel Discussion (Misc queries) 4 February 22nd 08 02:45 PM
Nested formula help Rescueme Excel Worksheet Functions 4 December 28th 07 09:45 PM
Nested Formula help Ray Excel Discussion (Misc queries) 1 June 4th 07 10:11 PM
Help with nested formula Rykar2 Excel Discussion (Misc queries) 7 May 16th 07 06:53 PM


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"