String check

[MadhavTR]

I have a data set like 

bu	compcode	compname
xyz	100	ABC

If i am using a formula for this 

IF [bu]="xyz" THEN [compName]=="ABC" ELSE [compName] ENDIF but it is giving me 0. Can you tell what is the mistake i am making here?

[binuacs · Accepted solution]

@MadhavTR you need to write the formula in the same compname column

[MadhavTR]

Got it. Thanks a lot.