IF formula within IF formula

[Barclaysusercds]

Hi, I am trying to re-create this excel formula =IF(C2="",IF(D2="",E2,D2),C2) in Alteryx.

I wrote the below but the formula is only giving me stage 1. The second IF is not working. No error messages appear.

I tried both these formulae

Please can you help. Thanks in advance.

IF [Stage 1 DataLens Trade ID matched]="" THEN (IF [Stage 2
Business mapping]="" THEN [Stage 3 Assumption based] ELSE [Stage 2
Business mapping] ENDIF) ELSE [Stage 1 DataLens Trade ID matched] ENDIF

IF [Stage 1 DataLens Trade ID matched]="" THEN IF [Stage 2
Business mapping]="" THEN [Stage 3 Assumption based] ELSE [Stage 2
Business mapping] ENDIF ELSE [Stage 1 DataLens Trade ID matched] ENDIF

[Barclaysusercds]

I am trying to upload an example but it's not allowing me to upload excel. It's taking a very long time.

[binuacs]

@Barclaysusercds can you copy paste few records

[Barclaysusercds]

[binuacs · Accepted solution]

@Barclaysusercds i used teh same formula and it seems to be working

[grazitti_sapna · Accepted solution]

@Barclaysusercds, getting the same result.

Thanks!

[Barclaysusercds · Accepted solution]

Thanks all

[grazitti_sapna]

@Barclaysusercds, could you please test my workflow too, if it works in your scenario please mark it as a solution too!

Thanks!