Formula Help

If [Business Unit] = "MMB" and [Dollars] > 25000 then [Location] = [Location] else if [Business Unit] = "MMB" and [Dollars] < 7500 then [Location] = "UW" else "Central" endif

Error: Formula (35) Parse Error at char(269): Malformed If Statement (Expression #1)

Workflow

Developer Tools

Error Message

Accepted answers

JohnJPS

Hi @MPCNA

With indentation that looks like:

If [Business Unit] = "MMB" and [Dollars] > 25000 then 
    [Location] = [Location] 
else 
    if [Business Unit] = "MMB" and [Dollars] < 7500 then 
       [Location] = "UW" 
    else 
       "Central" 
    endif

You may want something more like...

If [Business Unit] = "MMB" and [Dollars] > 25000 then 
    [Location] 
else 
    if [Business Unit] = "MMB" and [Dollars] < 7500 then 
       "UW" 
    else 
       "Central" 
    endif
endif

Hope that helps!

All comments

JohnJPS

Hi @MPCNA

With indentation that looks like:

If [Business Unit] = "MMB" and [Dollars] > 25000 then 
    [Location] = [Location] 
else 
    if [Business Unit] = "MMB" and [Dollars] < 7500 then 
       [Location] = "UW" 
    else 
       "Central" 
    endif

You may want something more like...

If [Business Unit] = "MMB" and [Dollars] > 25000 then 
    [Location] 
else 
    if [Business Unit] = "MMB" and [Dollars] < 7500 then 
       "UW" 
    else 
       "Central" 
    endif
endif

Hope that helps!

MPCNA

Thanks!

MarqueeCrew

@JohnJPS,

How about:

IF
     [Business Unit] = "MMB" and [Dollars] > 25000 
     THEN [Location] 
ELSEIF 
     [Business Unit] = "MMB" and [Dollars] < 7500 
     THEN "UW" 
ELSE 
     "Central" 
ENDIF

Just a cosmetic difference of style...

Cheers,

Mark

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703