FORMULA FIELD - Nested IF Statement Getting "Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 5"

Question

Here is the current formula:

IF( AND
 (NOT
    (Line_Level_Detail__c ='Services'), Line_Level_Type__c= 'New Product'), UnitPrice   * Quantity , 0)

Trying to add criteria that says if the Opportunity Stage is Closed Lost then the results should be 0.

This formula sits on the opportunity product.

This is what I have right now:

IF(ISPICKVAL(Opportunity.StageName, "Closed Lost"), 0,  AND
 (NOT
    (Line_Level_Detail__c ='Services'), Line_Level_Type__c= 'New Product'), UnitPrice   * Quantity , 0)

Can't figure out where we are going wrong.

Answer 1

The three parameters in the IF formulas represent:

1. logical condition
2. value if the condition is true
3. value if the condition is false

Since 0 was the third parameter in your original formula, you can just add another condition to the AND in the original version. Something like the following should return the expected result.

IF(AND(NOT(Line_Level_Detail__c ='Services'), Line_Level_Type__c= 'New Product', NOT(ISPICKVAL(Opportunity.StageName, 'Closed Lost'))), UnitPrice   * Quantity , 0)