Formula Help Needed

[Guest]

I have the following expression:

Expr1: IIf([SCHW ADV NETWORK]=Yes,[TOTAL FEE]*0.15)

But now I need to add that if [SCH ADV NETWORK=Yes New,[TOTAL FEE]-[SAN]

How can this be added to the expression I already have?

Any help would be greatly appreciated!

 

[fredg]

I have the following expression:

Expr1: IIf([SCHW ADV NETWORK]=Yes,[TOTAL FEE]*0.15)

But now I need to add that if [SCH ADV NETWORK=Yes New,[TOTAL FEE]-[SAN]

How can this be added to the expression I already have?

Any help would be greatly appreciated!

Evidently the value in [SCHW ADV NETWORK] is Text, not a Yes/No check
box field.
If so, then your first IIF should not work, as Yes is a number (value
of -1) which is not the same as "Yes" which is text.

Expr1: IIf([SCHW ADV NETWORK] = "Yes",[TOTAL FEE]*0.15,IIf([SCH ADV
NETWORK] ="Yes New",[TOTAL FEE]-[SAN],""))

What do you wish to do if the value is neither "Yes" nor "Yes New"?
The final "" above will leave the control blank.