Problem with IF Statment

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)
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,088
Members
412,567
Latest member
mm1
Top