Getting Started

 View Only
  • 1.  Formula help - multiple conditions

    Posted 07-29-2020 10:47
    This group has helped me tremendously previously, and I'm hoping for some similar results. Previously you helped me with a formula to return a name based on a particular condition (see below). Now I am trying to create a formula that can take two conditions and return the name. So if the Type = Subcontractor AND Supplier = "Maintenance Supply Headquarters", "Zenovia"

    I'm not sure how to have the AND in there to include the two conditions.



    If(
    [Supplier]="Maintenance Supply Headquarters", "Zenovia",
    [Supplier]="Ferguson Facilities Supply", "Manuela",
    [Supplier]="HD Supply", "Manuela",
    [Supplier]="HD Supply White Cap", "Manuela",
    Begins([Supplier],"F"),"Zenovia",
    Begins([Supplier],"G"),"Zenovia",
    Begins([Supplier],"H"),"Zenovia",
    Begins([Supplier],"I"),"Zenovia",
    Begins([Supplier],"J"),"Zenovia",
    Begins([Supplier],"K"),"Zenovia",
    Begins([Supplier],"L"),"Zenovia",
    //else
    "Manuela")

    Thank you,

    Brandy

    ------------------------------
    Brandy Nunes
    ------------------------------


  • 2.  RE: Formula help - multiple conditions

    Posted 07-29-2020 16:11
    The format you need is something like:

    If(Condition1 And Condition2, true result, optional false result)

    ------------------------------
    Paul Peterson
    ------------------------------