=IF(OR(E2="Startup",E2="Enrollment Open",E2="Enrollment
Closed",E2="Treatment",E2="Startup",E2="On Hold",E2="Terminated"),"Yes","")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"PAL" wrote:

Can someone help with this formula, or perhaps come up with a simpler version?

=IF(E2="Startup","Yes",IF(E2="Enrollment Open","Yes",IF(E2="Enrollment
Closed","Yes",IF(E2="Treatment","Yes",IF(E2="Start up","Yes",IF(E2="On
Hold","Yes",IF(E2="Terminated,"Yes","")))))