Multiple IF statements

bakerd90

Hi

I need to create a new column in a worksheet that provides a code based on a set of criteria than be identified from 2 existing columns.

My formula so far looks like this

if Contains("HT", [Benefit Plan])then "L1"
else if Contains("HTN", [Benefit Plan]) then "L2"
elseif Contains("Prmb", [Benefit Plan]) AND Contains("S & P",[Coverage]) then "L3"

etc

So in some cases, it only needs to match to 1 column but in others, where there are more specific requirements it will need to match to 2 columns in order to return a result.

I had it working when I only needed it to apply logic to 1 column but now i'm applying it to 2 I am getting an error when i try to end the if statement.

any help would be greatly appreciated?

alexnajm

You need to have a final ELSE condition followed by an ENDIF! Also I think you may have the column and lookup word switched in your contains statements? Typically it would be  Contains([Benefit Plan], "HT")

if Contains("HT", [Benefit Plan]) then "L1"
elseif Contains("HTN", [Benefit Plan]) then "L2"
elseif Contains("Prmb", [Benefit Plan]) AND Contains("S & P",[Coverage]) then "L3"

ELSE "Review" ENDIF