Maximum amount of IIf conditions in MS Outlook 2003 Formula

[Greg Lucas]

Hi there,
I was wondering if anyone could tell me what the maximum amount if IIf statements in a outlook formula is: I have 17 at the moment, and may need to go to about 20 or so.

I am getting a error with the following function:

IIf([Location]="Assembly A - Not for Profit (After Hrs.)",Format(15,"Currency"),
IIf([Location]="Assembly A - Not for Profit (Open Hrs.)",Format(35,"Currency"),
IIf([Location]="Assembly B - Not for Profit (After Hrs.)",Format(15,"Currency"),
IIf([Location]="Assembly B - Not for Profit (Open Hrs.)",Format(35,"Currency"),
IIf([Location]="Assembly C - Not for Profit (After Hrs.)",Format(15,"Currency"),
IIf([Location]="Assembly C - Not for Profit (Open Hrs.)",Format(35,"Currency"),
IIf([Location]="Dance Studio (Not for profit)",Format(25,"Currency"),
IIf([Location]="Dance Studio (Open Hrs.)",Format(75,"Currency"),
IIf([Location]="Double Gym League (Incl. Staffing)",Format(65,"Currency"),
IIf([Location]="Garden Courtyard",Format(75,"Currency"),
IIf([Location]="Gym Event - For profit (After Hrs.)",Format(300,"Currency"),
IIf([Location]="Gym Event - For profit (Open Hrs.)",Format(343,"Currency"),
IIf([Location]="Gym Event - Not for profit (After Hrs.)",Format(193,"Currency"),
IIf([Location]="Gym Event - Not for profit (Open Hrs.)",Format(150,"Currency"),
IIf([Location]="Medium Assembly - Not for profit",Format(25,"Currency"),
IIf([Location]="Medium Assembly (Open Hrs.)",Format(75,"Currency"),
IIf([Location]="Staffing - After Hrs.",Format(43,"Currency"),
"Rate?")))))))))))))))))

Cheers
Greg