aafroehlich
New Member
- Joined
- Dec 8, 2005
- Messages
- 15
I am having a problem with this if statment. Can anyone help me out???
IIF([Tier]=“Tier 1”,IIF([MCC]/[Tot_Auth]<.02), [MCC],0, Iif[Tier]=“Tier 2”,IIF([MCC]/[Tot_Auth]<.03), [MCC],0,0)
IIF([Tier]=“Tier 1”,IIF([MCC]/[Tot_Auth]<.02), [MCC],0, Iif[Tier]=“Tier 2”,IIF([MCC]/[Tot_Auth]<.03), [MCC],0,0)