Issue with 0 in Nested IF Statement

[IsmaelMontesJr]

I'm trying to convert an Excel function using the Formula Tool in Alteryx and I'm running into an issue.

Value A = 1st Value

Value B = 2nd Value

Value C = Column where we are performing operation

Essentially:

IF Value A (Sheet1) = Value B (Sheet2), then Return Value B (Sheet2) OR

IF Value B does note equal Value A, then 0.

I keep getting a Malformed IF Statement message from Alteryx, due to to the 0.  Here's the formula I have:

IF [Value A] = [Value B] THEN

[Value B] ELSEIF

[Value A] != [Value B] THEN 0

ENDIF

Thanks in advance for the help.

Ish

[DanM · Accepted solution]

IF [Value A] = [Value B] THEN

[Value B] ELSE

0

ENDIF

[IsmaelMontesJr]

Thank you!!! (Fist Bump)