If formula - with multiple criteria

NicoleB

Trying to set up so that a column will return a field based on two other columns -

=IF([IND INT Stage ]:[IND INT Stage ] = "Not

Started", “IDD Not Started”, if([IND INT Stage ]:[IND INT Stage ] = OR(@cell = "IDD Started", @cell = "as

- is documentation completed"), “Requirements Pending”, if([IND INT Stage ]:[IND INT Stage ] = OR(@cell = "design/build in progress",

@cell = "joint sessions in progress", @cell = "analysis in

progress", @cell = "QS hand off in progress", @cell = "idd

signed off"), “Design/Build In Progress”, If([IND INT Stage]:[IND INT Stage} = "Hand off to QS Complete" AND [Integration Rework Status]:[Integration Rework Status], "in testing", "In Testing")

The above formula gives #unparseable error

I tried this one as well and got a different error - #Invalid Operation

=IF([IND INT Stage ]@row = "not started", "IDD Not Started", IF([IND INT Stage ]@row = OR( "IDD Started", "As - Is Documentation Completed"), "Requirements Pending", IF([IND INT Stage ]@row = OR("design/build in progress", "joint sessions in progress", "analysis in progress", "QS hand off in progress", "IDD Signed Off"), "Design/Build In progress", IF([IND INT Stage ]@row = "Hand off to QS Complete", "In Testing"))))

I also tried this formula - the error is unparseable

=IF([IND INT Stage ]:[IND INT Stage ] = "Not

Started", “IDD Not Started”, if([IND INT Stage ]:[IND INT Stage ] = OR(@cell = "IDD Started", @cell = "as

- is documentation completed"), “Requirements Pending”, if([IND INT Stage ]:[IND INT Stage ] = OR(@cell = "design/build in progress",

@cell = "joint sessions in progress", @cell = "analysis in

progress", @cell = "QS hand off in progress", @cell = "idd

signed off"), “Design/Build In Progress”, if([IND INT Stage ]:[IND INT Stage ] = "Hand off

to QS Complete", "In Testing"))))

 AND - Invalid operation below as well

=IF([IND INT Stage ]@row = "not started", "IDD Not

Started", IF([IND INT Stage ]@row = OR(@cell = "IDD Started", @cell = "As

- Is Documentation Completed"), "Requirements Pending", IF([IND INT Stage ]@row = OR(@cell = "design/build in progress",

@cell = "joint sessions in progress", @cell = "analysis in

progress", @cell = "QS hand off in progress", "IDD Signed

Off"), "Design/Build In progress", IF([IND INT Stage ]@row = "Hand off to QS Complete", "In

Testing"))))

Paul Newcome

You are using your OR and AND functions incorrectly. Here's a quick example of the proper syntax:

IF(OR([IND INT Stage ]@row = "IDD Started", [IND INT Stage ]@row = "As - Is Documentation Completed"), "Requirements Pending",