Malformed If Statement

Question

Hello, can someone help me fix my if statement? if [Exposure] >= 1000000 then 'Sr. Management Review' elseif [Exposure] >= 700000 and [Exposure] <=1000000 then 'Director Review' elseif [Exposure] >= 400000 and [Exposure] <=70000 then 'Cr. Manager Review' elseif [Exposure] >= 200000 and [Exposure] <=400000 then 'UW Review' elseif [Exposure] <= 200000 and [Credit Score] = 1 and [Credit Score]=2 and [Credit Score]=3 then 'Auto-Approved' ENDIF

Qiu · Answer

@ana_nardo_ADP 
Including the point from @Bren_Spill2 , I have made 6 markups in your formula for your consideration.

700000, 400000 and 200000 are used for boudary values as >= and <= in two conditions, which may cause ambiguity.

0907-ana_nardo_ADP.yxmd

Bren_Spill2 · Answer

Sorry - you're also missing the final Else at the very end

then 'Auto-Approved' Else ......... Endif

ana_nardo_ADP · Answer

that makes sense but it didn't fix the malformed error :(