Hey All!
I am running into an issue I can't figure out. I've got a big set of data and there is a specific column that I want to make a case statement based on the results.
If the field, lets call it A1, is...
=42
or =43
or is between 70 - 99, excluding 79 and 81
then I want to call it "Yes"
Can anyone help me with the syntax on this? I am struggling to get it right.
JAK7217
I am running into an issue I can't figure out. I've got a big set of data and there is a specific column that I want to make a case statement based on the results.
If the field, lets call it A1, is...
=42
or =43
or is between 70 - 99, excluding 79 and 81
then I want to call it "Yes"
Can anyone help me with the syntax on this? I am struggling to get it right.
JAK7217