Using replace formula with IF formula from Formula Tool

Question

Hello,

can i use Replace formula inside IF formula. i want to replace some specific line based on few criteria such as-

If column A(Zip Code)=4589 then Column B(City Name)= NYC then replace "Small City" from Column D(City Type) to "Mega City"

Please note on my above task we are working on both type Double Type (Column A) and V_String Type(Column B & D).

can we use IF and Replace functions from Formula tool

thank you

jonnyrask · Accepted Answer

@ksarker

Yes, you can.

Example -

Set the column you want to change to be a new column or [City Type]

IF [Zip Code]=4589 THEN REPLACE([City Type],"Small City","Mega City") ELSE [City Type] ENDIF