Multiple IF Statement for Status Codes

mbrawn — Tue, 18 Jul 2017 14:27:37 GMT

Hi there,

I need to form the correct version of this IF statement. Or, more likely, a different statement with the same outcome!

If Status = 3 then "Won"

If Status = 4 then "Lost"

If Status = BLANK then "Open"

Below is the code I'm trying and the Blank part does not seem to recognise it should display as "Open".

Any help appreciated,

Thanks

Status = (IF(opportunities[statuscode] = 3, "Won", IF(opportunities[statuscode] = 4, "Lost", IF(opportunities[statuscode] = BLANK(), "Open"))))

Re: Multiple IF Statement for Status Codes

Eric_Zhang — Wed, 19 Jul 2017 08:42:12 GMT

You could try

Status =
SWITCH (
    opportunities[statuscode],
    3, "Won",
    4, "Lost",
    BLANK (), "Open",
    "defaut value if doesn't in any prior case"
)