Formula with multiple IF criteria

Andrea Mayer

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

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&lt;>"Complete", [Due Date]@row&lt;= TODAY()),1,"")

Connor

Andrea Mayer

Thank you, Connor! This worked perfectly.