Converting Excel nested if/and/or statement to Alteryx Multi-row formula

Question

Hello,

I have an Excel function that I am having a hard time translating to the syntax used in the multi-row formula tool. The function checks the row above as well as the row below the active row and is as follows:

=IF(OR((AND(I2=I3, E2=E3)), AND(I2=I1, E2=E1)), TRUE, FALSE)

Any help is much appreciated!

ChrisTX · Accepted Answer

Excel:

IF(OR((AND(I2=I3, E2=E3)), AND(I2=I1, E2=E1)), TRUE, FALSE)

Alteryx:

IF (I2 = I3 and E2 = E3) or (I1 = I2 and E1 = E2)
THEN 1
ELSE 0
ENDIF

If you want your data type in Alteryx to be Boolean, use 1 for True and 0 for False.

Chris

binu_acs · Accepted Answer

@r-alrahmani

IF (([Row-1:I] = [I] AND [Row-1:E] = [E]) OR ([Row+1:I] = [I] AND [Row+1:E] = [E]), TRUE, FALSE)