IIf

[Pass-the-reality]

I have 2 IIf Statements that I need to combined into one -

Type: IIf([PlanType]="LPPO" Or [PlanType]="RPPO","PPO")
Type: IIf([PlanType]="HMO" Or [PlanType]="HMO-POS","HMO")

How would I say IIf Plan Type = LPPO or RPPO insert PPO (ex 1) OR if Plan
Type = HMO or HMO-POS insert HMO (ex 2) in one expression?

 

[Brendan Reynolds]

I have 2 IIf Statements that I need to combined into one -

Type: IIf([PlanType]="LPPO" Or [PlanType]="RPPO","PPO")
Type: IIf([PlanType]="HMO" Or [PlanType]="HMO-POS","HMO")

How would I say IIf Plan Type = LPPO or RPPO insert PPO (ex 1) OR if Plan
Type = HMO or HMO-POS insert HMO (ex 2) in one expression?

This is untested, but I believe should work ...

IIf([PlanType]="LPPO" Or [PlanType]="RPPO","PPO",IIf([PlanType]="HMO" Or
[PlanType]="HMO-POS","HMO"))

If it is possible for PlanType to be none of the above, you can add a third
argument to the inner IIf() to handle that possibility ...

IIf([PlanType]="LPPO" Or [PlanType]="RPPO","PPO",IIf([PlanType]="HMO" Or
[PlanType]="HMO-POS","HMO","N/A"))

 

[RonaldoOneNil]

Type: IIf([PlanType]="LPPO" Or [PlanType]="RPPO","PPO",IIf([PlanType]="HMO"
Or [PlanType]="HMO-POS","HMO","NEITHER"))