IF and IF then put X or IF then put X Help!

[NicoleAM]

I have issues forming expressions especially If/Then! I've made several iterations of this but here is the last one I made. Can someone help me correct it?

IF [DMA Name]="Multi" && [Vendor State] = "ME" THEN "Maine" ELSEIF [Vendor State] = "NH" THEN "New Hampshire"
ELSEIF [DMA Name] ENDIF

Thanks!

[JohnJPS · Accepted solution]

Hi @NicoleAM

Try changinge the last "ELSEIF" to  a catch-all "ELSE" ...

IF [DMA Name]="Multi" && [Vendor State] = "ME" THEN 
  "Maine" 
ELSEIF [Vendor State] = "NH" THEN 
  "New Hampshire"
ELSE
  [DMA Name] 
ENDIF

[JoeM]

Duplicate answer removed.

[NicoleAM]

Thanks!