Forum Discussion

actzikas's avatar
actzikas
Frequent Visitor
6 years ago
Solved

IF ELSE Statement for Column

I am trying to create an If Statement to create/group a column in the following order.  If Probability < 50 then it is "Early"  If Probability >= 50 or < 75 then it is "Warm"  If Probability is ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi actzikas 

    i dont think you need the last statement 

    IF(Opportunity[Probability] >= 75, "Late"

    because you have already described any of possible values.

    so, you could leave just

    Piepline Probability Stage = IF(Opportunity[Probability] < 50, "Early", IF(Opportunity[Probability] >= 50 || Opportunity[Probability] < 75, "Warm", "Late"))
az38's avatar
az38
Community Champion
6 years ago

Hi actzikas 

i dont think you need the last statement 

IF(Opportunity[Probability] >= 75, "Late"

because you have already described any of possible values.

so, you could leave just

Piepline Probability Stage = IF(Opportunity[Probability] < 50, "Early", IF(Opportunity[Probability] >= 50 || Opportunity[Probability] < 75, "Warm", "Late"))
actzikas's avatar
actzikas
Frequent Visitor
6 years ago

Thanks I just had to replace the || with && and it worked