Identifying if a project will complete on-time

[dcoxjr]

This is my first post, so please forgive if I overlook a requirement. I have the following variables:

• Budget
• Costs
• # of items requiring repair
• # of items repaired
• Start date
• End date

QUESTION 1/2: What formula will calculate if all items will be repaired by the end date at the current rate of repair?

QUESTION 2/2: What additional code or action can be added to conditionally format the cell with a green check, yellow exclamation, or red x icon based on a 20% margin (>/= average repair rate = green, <10% average repair rate = yellow, <20% average repair rate = red)?

 

[barrowb]

Question 1/2: We need to know the current rate of repair to answer this question. The answer is IF((# of items requiring repair - # of items repaired)/ (rate of repair) <= (End Date - Start Date), TRUE, FALSE)

If it returns TRUE the you will finish on time.