G
getting a headache
it seems the system will only allow a maximum of 8 conditions, is there
another way to have more conditions? Help would be appreciated.
M=IF(B32="clarifying project", "task 1",IF(B32="project initiated", "task
2",IF(B32="Project Initiated (On Hold)","task 3",IF(B32="Data
generation","task 4",IF(B32="Data Generation (On Hold)","task
5",IF(B32="PSCR Submitted","task 6",IF(B32="Data Requirements Issued","task
7",IF(B32="Data with Registrant for Submission","task 8",if(B32="Letter of
Support Received","task 9",IF(B32="Planning Phase","task 10",IF(B32="Planning
Phase (on hold)","task 11",IF(B32="Reporting phase (on hold)","task
12",IF(B32="Reporting phase","task 13",IF(B32="Preparing Submissionn","task
14","Not OK"))))))))))))))))
another way to have more conditions? Help would be appreciated.
M=IF(B32="clarifying project", "task 1",IF(B32="project initiated", "task
2",IF(B32="Project Initiated (On Hold)","task 3",IF(B32="Data
generation","task 4",IF(B32="Data Generation (On Hold)","task
5",IF(B32="PSCR Submitted","task 6",IF(B32="Data Requirements Issued","task
7",IF(B32="Data with Registrant for Submission","task 8",if(B32="Letter of
Support Received","task 9",IF(B32="Planning Phase","task 10",IF(B32="Planning
Phase (on hold)","task 11",IF(B32="Reporting phase (on hold)","task
12",IF(B32="Reporting phase","task 13",IF(B32="Preparing Submissionn","task
14","Not OK"))))))))))))))))