Nested conditions in expression

[Fa1con74]

Hello,

Hello, I have a question regarding expressions. I have a form in which I filled in several fields with a color value (Green, Yellow, Red and Black), I would like to have a field of 6 or depending on the values entered, it displays a color.
Let me explain if in my field 1 it is green, my field 2 is Red, my field 3 is green the result of my field will be Red because there is a red in the previous field.
Hoping to have made myself understood

[Joseph_Seddik]

Hello, 

Sorry I'm having difficulties understanding your requirement. I recommend that you share a screenshot of your table setup please and explain again what you'd like to achieve. Thanks

[Fa1con74]

I think I have a start of solution

IF(
OR([Site-Sol]=Noir,[Environnement]=Noir,[Résultat Structure]=Noir,[non structuraux]=Noir),Noir,
IF(
OR([Site-Sol]=Rouge,[Environnement]=Rouge,[Résultat Structure]=Rouge,[non structuraux]=Rouge),Rouge,
IF(
OR([Site-Sol]=Jaune,[Environnement]=Jaune,[Résultat Structure]=Jaune,[non structuraux]=Jaune),Jaune,
IF(
OR([Site-Sol]=Vert,[Environnement]=Vert,[Résultat Structure]=Vert,[non structuraux]=Vert),Vert,
IF(
OR([Site-Sol]<>Noir,[Environnement]<>Noir,[Résultat Structure]=Noir,[non structuraux]<>Noir),Noir,
IF(
OR([Site-Sol]=Noir,[Environnement]<>Noir,[Résultat Structure]<>Noir,[non structuraux]<>Noir),Noir,
IF(
OR([Site-Sol]<>Rouge,[Environnement]<>Rouge,[Résultat Structure]=Rouge,[non structuraux]<>Rouge),Rouge,
IF(
OR([Site-Sol]=Rouge,[Environnement]<>Rouge,[Résultat Structure]<>Rouge,[non structuraux]<>Rouge),Rouge,
IF(
OR([Site-Sol]<>Rouge,[Environnement]=Rouge,[Résultat Structure]<>Rouge,[non structuraux]<>Rouge),Rouge,
"-")))))))))

[Joseph_Seddik · Accepted solution]

Et qu'est-ce que t'en penses de celle-ci?

https://help.appsheet.com/en/articles/2355961-ifs

[Steve]

any(
  intersect(
    list("Noir", "Rouge", "Jaune", "Vert")
    list([Site-Sol], [Environnement],[Résultat Structure], [non structuraux])
  )
)