multiple If statements

Richard Zombek

The below works if "Closed -Training Only" is selected.

However, if any other variable is selected i get #invalid data type

=IF(Status@row <> "Closed – Training Only", (AND((IF(Status@row <> "Completed", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), "")))))

Richard Zombek

fixed

=IF(Status@row = "New Submission", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), IF(Status@row = "In Progress", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), IF(Status@row = "On Hold", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()))))

Richard Zombek

fixed

=IF(Status@row = "New Submission", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), IF(Status@row = "In Progress", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()), IF(Status@row = "On Hold", NETWORKDAYS(MAX([Date Entered]1:[Date Entered]1), TODAY()))))