BrandyNunes1
5 years agoQrew Member
Formula help - multiple conditions
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
------------------------------
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
------------------------------