Multiple if

Question

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.

Question.xls

mceleavey · Answer

Hi @Jaganmohan ,

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

M.

Luke_C · Answer

Hi @Jaganmohan

Try this:

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

New Workflow5.yxmd