Skip to main content
Hi,

I am getting following error while executing the formula field Review all error messages below to correct your data.

Incorrect number of parameters for function 'if()'. Expected 3, received 1 (Related field: Formula) . Below is my code

if(AND(Hdn_Closed_Program_Week__c + 1 ==  Opp_Count__c, Hdn_Closed_Program_Week__c >= 1), Hdn_Closed_Program_Week__c,

if(Old_Program_Week__c == Hdn_Closed_Program_Week__c),Old_Program_Week__c , Old_Program_Week__c + Hdn_Closed_Program_Week__c )
2 answers
  1. Jan 5, 2015, 3:04 PM

    @vetriselvan manoharan:

    Try the below version of it:

    if(AND(Hdn_Closed_Program_Week__c + 1 ==  Opp_Count__c, Hdn_Closed_Program_Week__c >= 1), Hdn_Closed_Program_Week__c,

    if(Old_Program_Week__c == Hdn_Closed_Program_Week__c,Old_Program_Week__c , Old_Program_Week__c + Hdn_Closed_Program_Week__c ))

    Hope it helps:

    Thanks,

    balaji