HOW TO REPLACE VALUE WITH IF CONDITION

[mahnoor1279]

Hello everyone from the following table i want to change only specific account invest type only for account

(account no :22534435   RE INVEST into SALE) & ( account no : 35346467     TRANSFER OUT into REDEMPTION)

i.e(

ACCOUNT NO	INVEST TYPE
20038424	SALE
22534435	RE INVEST
24355244	RE INVEST
46354747	SALE
2536436	TRANSFER OUT
3354343225	REDEMPTION
35346467	TRANSFER OUT

[MayilVahanan · Accepted solution]

Hi

Try like below

If([ACCOUNT NO] = 22534435, 'SALE', If([ACCOUNT NO] = 35346467, 'REDEMPTION', [INVEST TYPE])) as [INVEST TYPE]