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

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!

Expression

Accepted answers

JohnJPS

Hi @NicoleMA

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

All comments

JohnJPS

Hi @NicoleMA

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.

NicoleMA

Thanks!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703