# Calculation with multiple conditions - if statement?

Options

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?

• ✭✭✭✭✭✭
Options

Try:

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

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭
Options

Try:

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

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

Thanks! That worked!

• ✭✭✭✭✭✭
Options

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!