AND/IF formulas

Melanie Courtemanche

I'm trying to identify the syntax error in my formula. Can someone help me?

=IF(Statut@row= "Terminé", "Vert), IF(AND(Statut@row = "En Cours"; IF(Échéance@row<=TODAY(); "Rouge", "Jaune")))

Paul Newcome

The closing parenthesis after "Vert" also needs to be removed.

=IF(Statut@row= "Terminé"; "Vert"; IF(AND(Statut@row="En Cours"; Échéance@row<=TODAY()); "Rouge"; "Jaune"))

Danielle Arteaga

Try this:

=IF(Statut@row= "Terminé", "Vert"), IF(AND(Statut@row="En Cours"; Échéance@row<=TODAY()); "Rouge", "Jaune"))

I think these are the issues

• missing end quote after Vert
• do not need "IF" inside AND statement
• missing end parenthesis after TODAY() to finish AND statement
• too many parenthesis at end

I'm unsure about the use of semi-colons in this formula. That may be required for your language, but if you continue to get errors, try replacing them with commas.

Melanie Courtemanche

Thank you so much! It really helps. I was overcomplicating things.

Paul Newcome

The closing parenthesis after "Vert" also needs to be removed.

=IF(Statut@row= "Terminé"; "Vert"; IF(AND(Statut@row="En Cours"; Échéance@row<=TODAY()); "Rouge"; "Jaune"))

Melanie Courtemanche

Thank you so much for your help!

Paul Newcome

Happy to help. 👍️