It is only calculating for conditions of QuickStartII. I will review and see if I can try to figure it out. You would think it is a simple if, then statement.

Thanks for all your help!...

Thanks...It actually worked but than I thought about combining the QS Multiplier as one formula instead so that I don't have have two different QS Multipliers (QS Multiplier I and II).
Here are my two formulas for the QS Multiplier.s I have been struggling as to how I can combine the two formulas into one. I have two columns in a table(Quick Start and Quick Start II) which is a qualifier to a comp plan. These qualifiers determines which...

I have three different onditions in my expression with different calcuations for each condition that is met. Only one can be met. I receive a syntax error (comma) in query expression.
The following expression is as follows:
CommCalc: IIf([BrokerDirect]=-1,([FirstLiens]-[PayOn])*[TierQualificati onBPS]*[QSMultiplierI],
IIf([QuickStartII]=-1,[FirstLiens]*[TierQualificati onBPS]*[QSMultiplier],
IIf([QuickStart]=-1,[FirstLiens]*[TierQualificati onBPS]*[QSMultiplierI],1))),1)...