Excel formula to calculate utilization properly

[AparnaWangu]

Hi Team,

I have a capacity sheet for resources project wise and the requirement is that if any fresource resigns and if goes on Exam leave for a duration then in those months instead of capacity(No's) R for resignees and EL for exam leave should reflect and it should not calculate their Capacity in the table mentioned in the excel attached as well.

Which formula will meet this condition.I am attaching the sample sheet as well.Pls help.

Regards,
Aps

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

Cross posted at: https://www.excelguru.ca/forums/showthread.php?8888-Excel-formula-to-calculate-utilization-properly

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.