Forum Discussion
Project Health Formula
Question on how to do the following in Excel. I have the following fields: Cost Schedule Scope Overall Project Health. Cost, Schedule and Scope can have the following values each: ...
Let's say Cost is in C2 and down, Schedule in D2 and down and Scope in E2 and down.
In F2:
=IF(OR(C2:E2="Red"), "Red", IF(OR(C2:E2="Yellow", "Yellow", "Green"))
Fill down.