Formula with multiple IF criteria

Andrea Mayer · 08/23/19

Hi all -

Trying to create a formula that raises a flag any time a milestone is NOT marked complete AND the due date has past. Below is what I have tried and I am receiving an "Unparseable" error.

=IF(Stage2<>"Complete" AND [Due Date]<= TODAY, 1)

I am not sure that I am combining the two statesments correctly. Can anyone help with this?

Appreciate the help!

-Andrea

Connor Hartford · 08/23/19

Hi Andrea,

You'll want to use the formula like this:

=IF(AND(Stand2<>"Complete", [Due Date]<= TODAY()),1,"")

If this the data for this formula is in the same row as the formula, I would write it this way:

=IF(AND([Stand]@row<>"Complete", [Due Date]@row<= TODAY()),1,"")

Connor

Andrea Mayer · 09/06/19

Thank you, Connor! This worked perfectly.

Formula with multiple IF criteria

Comments

Help Article Resources

Categories