multiple conditions with OR

[allwynbazil]

Team,

I am handling two conditions in an If statement and am not getting the expected result. In this case, the count is 3 and the internal comment is "There are no quotable data for this Case Number". This should return "No" only if the internal comments are not either "There are no quotable data for this Case Number" or "It's a Federal deal and doesn't require budgetary quote" and the count is > 0.

Regards,

Alwin

[ShankerV · Accepted solution]

Hi @allwynbazil 

IF [Count]>0 AND ([Internal Comment C]="There are no quotable data for this Case Number" or [Internal Comment C]="It's Federal deal and doesn't require budgetary quote")
THEN "No"
ELSE "Yes"
ENDIF

Many thanks

Shanker V

[Raj · Accepted solution]

IF [Count] > 0 AND NOT ([Internal Comment] = "There are no quotable data for this Case Number" OR [Internal Comment] = "It's a Federal deal and doesn't require budgetary quote") THEN "No" ELSE "Yes" endif