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 a...
Forum Discussion
Ironically, exactly how you typed it!
If(
[Supplier]="Maintenance Supply Headquarters" and [Type] = "Subcontractor", "Zenovia",
[Supplier]="Ferguson Facilities Supply" and [Type] = "Subcontractor", "Manuela",
etc.....
Perhaps someone has a more elegant solution though since there is one constant condition?
------------------------------
Mike Tamoush
------------------------------
If(
[Supplier]="Maintenance Supply Headquarters" and [Type] = "Subcontractor", "Zenovia",
[Supplier]="Ferguson Facilities Supply" and [Type] = "Subcontractor", "Manuela",
etc.....
Perhaps someone has a more elegant solution though since there is one constant condition?
------------------------------
Mike Tamoush
------------------------------