Multiple if

[Jaganmohan]

Hi - Need a help on multiple if statement.
Need a solution for below mentioned logic : pfa
if Price 2 column "Blank" and Reason code MP/TP then pull the prices from Action column else Price2.

[Luke_C]

Hi @Jaganmohan 

Try this:

if isempty([Price 2]) and [ReasonCode] in ('MP','TP') then [Action]
else [Price 2]
endif

[mceleavey]

Hi @Jaganmohan ,

if isempty([Price 2]) and ([ReasonCode]="MP" or [ReasonCode]="TP") then [Action] else [Price 2] endif

M.