Calculation with multiple conditions - if statement?

Angie Little

I'm calculating the number of days between my due date and today. I'm trying to make this calculation based on a separate column NOT being certain conditions. I have successfully done the following:

=IF(Stage@row <> "9 Released", [Due Date-Plan]@row - TODAY())

But I want this calculation to also exclude those items in the Stage column that are "X On Hold" and "Z Rejected".

I've tried below, which doesn't work.

=IFs(Stage@row <> "9 Released", Stage@row <> "X On Hold", Stage@row <> "Z Rejected", [Due Date-Plan]@row - TODAY())

Suggestions?

Mark Cronk

Hi @Angie Little ,

Try:

=IF(AND(Stage@row <> "9 Released", Stage@row <> "X On Hold", Stage@row <> "Z Rejected"), [Due Date-Plan]@row - TODAY(),"")

Mark

Mark Cronk

Hi @Angie Little ,

Try:

=IF(AND(Stage@row <> "9 Released", Stage@row <> "X On Hold", Stage@row <> "Z Rejected"), [Due Date-Plan]@row - TODAY(),"")

Mark

Angie Little

Thanks! That worked!

Mark Cronk

Excellent. Glad you found a solution. Thank you for contributing to the community. Mark