Decode an IIf query

[Charlie24]

Appreciate help understanding the following IIf statement:

ExclusionSW: IIf(([CallType] Like "Insurance*") And ([CallType2] Is Null),1,IIf(([CallType] Like "ChgOrder*") And ([ProductLine] Is Null),1,0))

Thank you

[ranman256]

I don't see how this can work but:

if [Caltype] has word "insurance" in it AND [Caltype2] is null
then show 1

else
if Caltype has word "ChgOrder" in it AND ProductLine is null,
then show 1

else
show 0

[Charlie24]

I don't see how this can work but:

if [Caltype] has word "insurance" in it AND [Caltype2] is null
then show 1

else
if Caltype has word "ChgOrder" in it AND ProductLine is null,
then show 1

else
show 0

Thanks for the response. Perhaps I should have shared the following information.

The statement posted is in one of the Query fields and 0 is in the Criteria. Does this help?

[orange]

Just a minor change to ranman's response.

if [Caltype] starts with "insurance" in it AND [Caltype2] is null
then show 1

else
if Caltype starts with "ChgOrder" in it AND ProductLine is null,
then show 1

else
show 0

[June7]

Could modify with OR:

ExclusionSW: IIf(([CallType] Like "Insurance*" And [CallType2] Is Null) OR ([CallType] Like "ChgOrder*" And [ProductLine] Is Null), 1, 0)

[Welshgasman]

Crossposted https://www.mrexcel.com/board/thread...ement.1204336/