if condition help

[surajap123]

Hi There,

I have below the condition that I want to write using if(). Please help.

if (location = ind, us, aus AND isnull(cde)) or isnull(priority) or isnull(severity).

Please help. Thanks

[Kushal_Chawda · Accepted solution]

@surajap123  try below

=if(match(loc,'IND','US','AUS') AND (len(trim(cde))=0 or len(trim(priority))=0 or len(trim(severity))=0), Dosomething)

[Chanty4u]

can you try this.

if(location='ind' and location='aus '  and isnull(cde) or isnull(priority) or isnull(severity))

[surajap123]

Thanks Kush