problem with if conditions
 

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

problem with if conditions
 

You can use the VLOOKUP function to do this. In some range on a
worksheet, say K1:L20, enter

TestValue ReturnValue
clarifying project task 1
project initiate task 2
' and so on


Then, use a formula like

=VLOOKUP(B32,K1:L20,2,FALSE)

This will search down column K looking for a match to the value in
B32. If a match is found, the corresponding value in column L is
returned. If no match is found, the formula will return a #N/A error.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sun, 7 Dec 2008 14:34:02 -0800, getting a headache
wrote:

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