Formula for multiple IF

[vvissamsetty]

I'm trying to build this formula in Alteryx "IF(AND(U6="TRUE",W6="TRUE"),X6,IF(AND(Y6="TRUE",Z6="TRUE"),AB6,IF(AND(AC6="TRUE",AE6="TRUE"),AF6,T6)))" and came up with the following formula

IF [Is Applicable Stock Price <= 150 - Alteryx] = "True" && [Lowest Qualified Benchmark < Applicable Stock Price - $10 - Alteryx] = "True"

THEN [Lowest Qualified Benchmark (150 Rule) - Alteryx]

ELSE IF [Is the Strike Price > $50 - Alteryx] = "True" && [Was The Option Entered Into More Than 90 Days Prior To Expiration - Alteryx] = "True"

THEN [Lowest Qualified Benchmark (90 Days and 50 Rule) - Alteryx]

ELSE IF [Applicable Stock Price <= $25 - Alteryx] = "True" && [Lowest Qualified Benchmark < 85% of Applicable Stock Price - Alteryx] = "True"

THEN [Lowest Qualified Benchmark (25 Rule) - Alteryx]

ELSE [Lowest Qualified Benchmark (General Rule) - Alteryx]

ENDIF

Is this the right way to do if we have multiple "IF'? I'm getting an error "Parse Error at Char(672): Malformed If Statement (Expression #1)". char 672 is after ENDIF.

[CharlieS · Accepted solution]

"ELSEIF" should be one string.

[vvissamsetty]

Thanks @CharlieS