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.
Solved! Go to Solution.
"ELSEIF" should be one string.
Thanks @CharlieS