Custom Conditional Column using IF / AND / ELSE returning "FALSE"

[Anonymous]

I am trying to create a custom column that says

= if [Vendors Name] = "Jingo Inc" and [Buyer] = "Jango Adams" then [Vendors Name] = "Jongo Plc" else [Vendors Name]

I am returning a "FALSE" result instead of Jongo Plc where it meets the condition for Jingo Inc + Jango Adams

What i need is the logic: if column 1 has Jingo Inc and column 2 has Jango Adams return Jongo Plc, else show the vendor in the original column. Please help out.

[Anonymous · Accepted solution]

@Anonymous,

Try this in your custom column:

= if [Vendors Name] = "Jingo Inc" and [Buyer] = "Jango Adams" then "Jongo Plc" else [Vendors Name]

[Anonymous]

Worked like a charm. Thank you!!