Excel formula

[Sarath27]

Hi All,

I tried to transform the below excel formula in Alteryx, but it turned out to with an error, pls advise.

=IFERROR(IF(G4=TRUE,(AH4-AN4)*VLOOKUP(U4,'FX Rates'!$A:$C,3,FALSE),IF(H4=TRUE,(AH4+AN4+AI4)*VLOOKUP(U4,'FX Rates'!$A:$C,3,FALSE),AH4*VLOOKUP(U4,'FX Rates'!$A:$C,3,FALSE))),0)

IF [Is Starting today?]="TRUE" THEN ([ccynpvnocasht2t1]-[ccysignedsettlementamount])*[FX Rate]
ELSEIF
IF [Is Maturing Today?]="TRUE" THEN ([ccynpvnocasht2t1]+[ccyaccrualsincelastcoupont2t1]+[ccysignedsettlementamount])*[FX Rate]
ELSE
[ccynpvnocasht2t1]*[FX Rate] ENDIF

Thanks in Advance.

[jdminton · Accepted solution]

There is an extra "IF" in your formula unless that was just mistyped here.

IF [Is Starting today?]="TRUE" THEN ([ccynpvnocasht2t1]-[ccysignedsettlementamount])*[FX Rate]
ELSEIF
▶️IF [Is Maturing Today?]="TRUE" THEN ([ccynpvnocasht2t1]+[ccyaccrualsincelastcoupont2t1]+[ccysignedsettlementamount])*[FX Rate]
ELSE
[ccynpvnocasht2t1]*[FX Rate] ENDIF

[Sarath27]

Thanks @jdminton