formula not working !!!

[VeronicaElse]

Hello,

I have a workflow that has 22 statements in this formula and I am needing to add one more but it is not working -I have to make sure the column OtherReasonforDenial has only I&E. I have tried elseif [OtherReasonForDenial] not in ('I "&" E') then 'other reason for denial error' elseif  --Also  elseif [OtherReasonForDenial] != 'I "&" E' then 'other reason for denial error' elseif 

I have also tried only using ('I&E') and 'I&E' 

Please help!

Thanks!

Veronica 

[atcodedog05]

Hi @VeronicaElse 

Try

elseif [OtherReasonForDenial] not in ("I","E")

Hope this helps : )

[VeronicaElse]

IN (...) Parameter #1 has a  type mismatch--- error given 😞

[atcodedog05]

Hi @VeronicaElse 

Hoping [OtherReasonForDenial] is a string type datatype

Try this

elseif [OtherReasonForDenial] not in ("I","E")

And share the error snapshot.

[DawnDuong]

hi @VeronicaElse 

The operator IN is not used correctly. The correct syntax is 

[Field name] IN ([value 1], [value 2], [Value 3]

In your case, you can use the formula:

[OtherReasonForDenial] NOT IN ("I", "E")

the IN operator will result in values of -1 for true and 0 for false. 

Dawn.