Most valuable professional
  • Hot Topics

Excel Easy Formula Stumping Me - Easy =IF() statement

I have 1 column I want to indicate either "On track" or "At Risk".. A1 is a ship date So B2 is the status from above.. H is Release Date I is Kit Date J is Start Date K is Finish Date So the logic is this : If Finish Date + 2days if Start Date + 3 days If Kit Date + 4 days These 4 stages will always have data ( or " " values ) because of Vlookups.. so no 'blank cells". So basically... if the finish date is blank, the start date is blank, the kit date is blank, but the release date +5 days is < ship date = we are still On Track.. Help.

This question generated 28 answers. To proceed to the answers, click here.

This thread is current as of January 9, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel