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

[binuacs]

@Barclaysusercds Can you try 

IIF(IsEmpty([Stage 1 DataLens Trade ID matched]), IIF(IsEmpty([Stage 2 Business mapping]), [ Stage 3 Assumption based], [Stage 2 Business mapping]), [ Stage 3 Assumption based])

[grazitti_sapna]

Hi @Barclaysusercds , try this 

IIF([Stage 1 DataLens Trade ID matched]="",IIF([Stage 2 Business mapping]="",[Stage 3 Assumption based],[Stage 2 Business mapping]),[Stage 1 DataLens Trade ID matched])

I hope this works!

Thanks!

[Barclaysusercds]

No it did not work. It did not pick up stage 1.

[binuacs]

@Barclaysusercds can you try this

IIF(IsEmpty([Stage 1 DataLens Trade ID matched]), IIF(IsEmpty([Stage 2 Business mapping]), [ Stage 3 Assumption based], [Stage 2 Business mapping]), [Stage 1 DataLens Trade ID matched])

[Barclaysusercds]

No it did not work. It did not consider stage 2 or stage 3

[binuacs]

@Barclaysusercds Can you provide some sample data?

[binuacs]

@Barclaysusercds The formula I provided working fine for me. May be if you can provide some data we will check

[grazitti_sapna]

@Barclaysusercds  could you provide us some input and output required, as per my screenshot row 3 returned the value of the stage 1 result.

The other thing could be instead of empty the fields have null values. Give this a try

IIF(ISNULL([Stage 1 DataLens Trade ID matched]),IIF(ISNULL([Stage 2 Business mapping]),[Stage 3 Assumption based],[Stage 2 Business mapping]),[Stage 1 DataLens Trade ID matched])

Thanks!

[Barclaysusercds]

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