Thread: Conditional
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default Conditional

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","")))))