if condition with AND

[surajap123]

Hi Experts,

I want to change the below expression, but it is not working as expected.

From-->  
if(field3 = 'Closed', black(),
   pick(match(Field2,'NY','LD,','JP'),yellow(),Blue(),green()))

To-->
if(field3 = 'Closed' AND if(Field2 = 'NY',black(),
   pick(match(Field2,'LD,','JP'),yellow(),Blue(),green()))

Please help.

[AshutoshBhumkar · Accepted solution]

Hi,

Try this.

if(field3 = 'Closed' AND Field2 = 'NY',black(),
   pick(match(Field2,'LD,','JP'),yellow(),Blue(),green())

[surajap123]

Thanks for your help