IF/THEN

[nihou]

I have tried the formula: 

IF Contains([SysProdCode]"GAS") and Contains([Type]"Processing" THEN '03'
ELSE IF Contains([SysProdCode]"GAS" and [Type]"Treatment" THEN '04'

Source

SysProdCode	Type
Gas	Processing
Gas	Processing
Gas	Treatment

Desire Output

SysProdCode	Type	PC
Gas	Processing	03
Gas	Processing	03
Gas	Treatment	04

[Ar13f · Accepted solution]

Dear @nihou 

please see the workflow below ... I hope this is what you are looking for

[Qiu · Accepted solution]

A master table should be easier for maitenance.