Expression - Unknown

I often find myself caught out on which expression to use when I want to perform the following query, your advice is much appreciated:

If column A contains X, then insert the word “Red” in this column, But if it contains Y, then insert the word “Purple” in this column, But if it contains Z, then insert the word “Green”.

which expression IF, AND, CONTAINS or another?

Sounds like IFS will do the jobs.

IFS(
[Column A]=X,“Red”,
[Column A]=Y,“Purple”,
[Column A]=Z,“Green”,
true, “else, whatever you want”
)

This is expression just for another field not for [Column A]

Column A value will decide whatsort of value to anothe column for instance [Column B]

4 Likes
4 Likes

Thank you sir, that makes sense.

1 Like