IIF

[Guest]

This works for me: Expr10: IIf([Billing Term]="Collect",[Destination])
but how do I do the following or can I?
Expr10: IIf([Billing Term]="Collect",[Destination]),IIf( [Name] "COD" isNot
[Billing Term]"Collect",[Destination])

 

[Guest]

When you write your IIF think of it like this... IIF ( Condition, then do
something, otherwise do this) and they can be nested like... IIF (
Condition, then do something, IIF ( Condition, then do something, otherwise
do this))
Not sure what you are trying to accomplish in the second part of that
statement, but it seems as though you have a ")" out of order
Expr10: IIf([Billing Term]="Collect",[Destination]),IIf( [Name] "COD" isNot
[Billing Term]"Collect",[Destination])
try moving it to the end like...
Expr10: IIf([Billing Term]="Collect",[Destination],IIf( [Name] "COD" isNot
[Billing Term]"Collect",[Destination]))
I don't know that it will work because the second IIf( [Name] "COD" isNot
[Billing Term]"Collect"...doesn't make sense.
HTH

 

[Guest]

I played around and I got this to work:

IIf([Billing Term]="Collect",IIf([Name]="COD",[Destination])," ")

but can I do this: IIf([Billing Term]="Collect",[Destination]),IIf([Billing
Term]="Collect",IIf([Name]="COD",[Destination])," ")

When you write your IIF think of it like this... IIF ( Condition, then do
something, otherwise do this) and they can be nested like... IIF (
Condition, then do something, IIF ( Condition, then do something, otherwise
do this))
Not sure what you are trying to accomplish in the second part of that
statement, but it seems as though you have a ")" out of order
Expr10: IIf([Billing Term]="Collect",[Destination]),IIf( [Name] "COD" isNot
[Billing Term]"Collect",[Destination])
try moving it to the end like...
Expr10: IIf([Billing Term]="Collect",[Destination],IIf( [Name] "COD" isNot
[Billing Term]"Collect",[Destination]))
I don't know that it will work because the second IIf( [Name] "COD" isNot
[Billing Term]"Collect"...doesn't make sense.
HTH
--
Joe

This works for me: Expr10: IIf([Billing Term]="Collect",[Destination])
but how do I do the following or can I?
Expr10: IIf([Billing Term]="Collect",[Destination]),IIf( [Name] "COD" isNot
[Billing Term]"Collect",[Destination])

 

[Guest]

Still confused...

but can I do this: IIf([Billing Term]="Collect",[Destination]),IIf([Billing
Term]="Collect",IIf([Name]="COD",[Destination])," ")

The logic behind this is not making sense, explain what you are trying to
do, to me this is saying...
if the "billing term" is "collect, then show the "destination"...
but then you close the IIF with the ")" add another comma so it won't work
(syntax error)
think about it like:
IIF ( Condition, then do something, otherwise do this)
and where I have "otherwise do this" you can nest another complete IIF
statement.

 

[Guest]

Sorry that should have been like this: (but I understand, it works in Excel)

IIf([Billing Term]="Collect",[Destination]),IIf([Billing
Term]="Collect",IIf([Name]="COD",[Destination])," "))


But I got around it.

Still confused...

but can I do this: IIf([Billing Term]="Collect",[Destination]),IIf([Billing
Term]="Collect",IIf([Name]="COD",[Destination])," ")

The logic behind this is not making sense, explain what you are trying to
do, to me this is saying...
if the "billing term" is "collect, then show the "destination"...
but then you close the IIF with the ")" add another comma so it won't work
(syntax error)
think about it like:
IIF ( Condition, then do something, otherwise do this)
and where I have "otherwise do this" you can nest another complete IIF
statement.