Where is my mistake ???

Christophe AUBRIOT

Hello to all,

Could someone please tell me where my mistake is, please ?

=IF(OR(Résultat@row <= "69,99%"; [Compteur Non-Conformité]@row > "0"; "Rouge"; IF(AND(Résultat@row >= "70,00%"; [Compteur Remarques]@row < "1"; "Vert"; "Jaune"))))

Thanks

Christophe

Andrée Starå

Hi @Christophe AUBRIOT

I hope you're well and safe!

Try something like this.

=IF(OR(Résultat@row <= 0,6999; [Compteur Non-Conformité]@row > 0; "Rouge"; IF(AND(Résultat@row >= 0,7; [Compteur Remarques]@row < 1; "Vert"; "Jaune"))))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

Hi @Christophe AUBRIOT

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Andrée Starå

Hi @Christophe AUBRIOT

I hope you're well and safe!

Try something like this.

=IF(OR(Résultat@row <= 0,6999; [Compteur Non-Conformité]@row > 0; "Rouge"; IF(AND(Résultat@row >= 0,7; [Compteur Remarques]@row < 1; "Vert"; "Jaune"))))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Christophe AUBRIOT

Hello,

Thank you for this proposal.

But my problem is not solved.

Could you help me, please ?

Thanks a lot

Andrée Starå

@Christophe AUBRIOT

Happy to help!

I've corrected the formula now.

Did it work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Christophe AUBRIOT

Hi Andrée,

The formula works perfectly, now.

 

Many thanks to you.

 

Sincerely

Andrée Starå

@Christophe AUBRIOT

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!