Forum Discussion

mbrawn's avatar
mbrawn
Frequent Visitor
9 years ago
Solved

Multiple IF Statement for Status Codes

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...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    mbrawn

    You could try

     

    Status =
SWITCH (
    opportunities[statuscode],
    3, "Won",
    4, "Lost",
    BLANK (), "Open",
    "defaut value if doesn't in any prior case"
)
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

mbrawn

You could try

 

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