I can never seem to get these If/Then Statements right! I have one that should be pretty easy....and I don't know maybe if/then isn't even the right way to go?! I am open to suggestions if there is a better way to accomplish what I am trying to do!
In snapshot below you can see I have added two columns to indicate what kind of store it is....Non-Divest and Divest. I don't want to see these two columns though. I only want to see one column so I'm tyring to use the formula tool and an If/Then to add a column in that says "Store Type" and will indicate either "Non-Divest" or "Divestiture".
First Try:
IF Contains([Non-Divest Store],"Non-Divest Store") THEN "Non-Divest Store" Elseif
[Divestiture Store],"Divestiture Store" then "Divestiture Store" ENDIF
Second Try:
If [Non-Divest Store]="Non-Divest Store" THEN "Non-Divest Store"
ELSEIF [Divestiture Store]="Divestiture Store"" THEN "Divestiture Store"
ENDIF
Thanks in advance!!
