Hey Everyone

I am working on a IF formula for a new field.

The formula is as follows:

OR(

IF(

ISPICKVAL( Type_of_Redemption__c, "Credit Note V" ), Total_Vouchers_Redeemed__c  *  Contract_Deal_Attribute__r.Groupon_Price__c  *  Contract_Deal_Attribute__r.Commission__c  *  Contract_Deal_Attribute__r.VAT__c , 0
), 

IF(

ISPICKVAL( Type_of_Redemption__c, "Credit Note C" ), Contract_Deal_Attribute__r.Groupon_Price__c * ( 1 +  Contract_Deal_Attribute__r.VAT__c ) * Commission_under_Credit_Note__c -  Contract_Deal_Attribute__r.Commission__c *   Total_Vouchers_Redeemed__c ) , 0

)

 However, I am recieving a Syntax error as there is no false statement, it expected 3 and received 2.

Any suggestions would be most warmly recieved.

Thank you.

Jimmy

Hey Everyone

I am working on a IF formula for a new field.

The formula is as follows:

OR(

IF(

ISPICKVAL( Type_of_Redemption__c, "Credit Note V" ), Total_Vouchers_Redeemed__c  *  Contract_Deal_Attribute__r.Groupon_Price__c  *  Contract_Deal_Attribute__r.Commission__c  *  Contract_Deal_Attribute__r.VAT__c , 0
), 

IF(

ISPICKVAL( Type_of_Redemption__c, "Credit Note C" ), Contract_Deal_Attribute__r.Groupon_Price__c * ( 1 +  Contract_Deal_Attribute__r.VAT__c ) * Commission_under_Credit_Note__c -  Contract_Deal_Attribute__r.Commission__c *   Total_Vouchers_Redeemed__c ) , 0

)

 However, I am recieving a Syntax error as there is no false statement, it expected 3 and received 2.

Any suggestions would be most warmly recieved.

Thank you.

Jimmy