Replace

[ksarker]

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" 

[binuacs]

@ksarker Here is one way of doing this with the multi-field formula tool

with formula tool

[Christina_H · Accepted 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