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]
Thank you sir, that makes sense.
User | Count |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |