Hello,
How to solve this following issue -
if Column A contain 123 then
if Column B contain XYZ then -------------
Replace Column C into "Only EXP"
Solved! Go to Solution.
Based on your data, is column C a numeric column? If so you'll need to change it to a string before you can put string data in it. Use a select tool to convert it, then use the formula from above to set the values. The only change it to retain the values where the condition is false:
IF [Column A]="ABC" AND [Column B]="XYZ" THEN "EXP Only" ELSE [Column C] ENDIF
You were previously using 123 as the value for Column A. If Column A is also numeric, drop the quote marks around the value:
IF [Column A]=123 AND [Column B]="XYZ" THEN "EXP Only" ELSE [Column C] ENDIF