# Nested if stated

Microsoft Excel 2007
January 28, 2010 at 07:11:39
Specs: Windows XP
 I am working an excel file to generate a "remaining duration" between date submitted and date required e calculated in weeks. Also if the result is + 1 week to be highlighted in Green, if the result is -+ 3 weeks to be highlighted in Yellow and if the result is -+ 4 weeks to be highlighted in red. Can someone please helpedited by moderator: Post moved from Windows 7 Forum

See More: Nested if stated

#1
January 28, 2010 at 08:31:43
 Not sure I understand what you want.You say if the result is + 1 weekThe result of what? The Submitted Date and the Required Date?Or some other calculation, like Todays date and Required Date?MIKEhttp://www.skeptic.com/

Report •

#2
January 28, 2010 at 09:32:11
 Sorry I forgot to mention the column I have, They are Date submitted, date required, estimated date for completion should always plus 13.5 weeks. so if the date required is more than 1 week and the % complete is 90% it should be green, if its less than 3 weeks and the % complete is 70% it should be yellow and if its less than % below 70 and remainining surationis less than 4 weeks it should be red hope this helps

Report •

#3
January 28, 2010 at 11:48:19
 Still not sure of what you want.Cell A1 is Date SubmittedCell B1 is Date Requiredestimated date for completion should always plus 13.5 weeksDoes this mean 13.5 weeks from Date Submitted?Doesn't that make Date Required = 13.5 from Date Submitted?What about Date Required?if the date required is more than 1 week and the % complete is 90%What happened to 13.5 figure?How do you know it's 90% completed? MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
January 28, 2010 at 12:03:21
 can we then use estimated date for completion? do I need a percent complete column there? too

Report •

#5
January 28, 2010 at 14:51:54
 Sorry, I still don't understand.I think you want something like:http://office.microsoft.com/en-us/t...Perhaps someone else will have a better idea of what your after.MIKEhttp://www.skeptic.com/

Report •