If then Statement

[brandon16]

Hi,

I have 2 columns

Column 1 (CT_Flag)
Values: RM, V, EE

Column 2 (VB_Flag)
1,0

I need to create a new column with the following logic:

If VB_FLAG = 1 then CT_FLAG = V else CT_FLAG

Any idea how to get this to work please?

Thanks

 

[ravishankar]

C2= if(B2=1,"V",A2)
ravishankar