Hello,
I am trying to write a formula with multiple IF conditions.
Column MONDAY has different values.
Each value can have one specific number attached to it.
The values can appear multiple times. For example - I can have 1000 rows and out of the 1000 rows, 200 can have ‘ABCD’.
With the formula below, only the first occurrence works. It will show the 12-34567-8 across the entire group, however no subsequent IF conditions work and it shows “FALSE” even though ‘EFGH’ and ‘WXYZ’ appear in the column.
IF({MONDAY}=“ABCD”,“12-34567-8”,“FALSE”,IF({MONDAY}=“EFGH”,“09-87654-3”,“FALSE”,IF({MONDAY}=“WXYZ”,“56-78901-2”,“FALSE”)))
What am I doing wrong?