I am trying to write a formula for a picklist and getting the erorr Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 1. Below is my formula. Can anyone help please?
IF ( INCLUDES(Payment_Option__c, "EZ Pay"),
AND (EZ_Pay_Payments__c = 0), OR (EZPay_Start_Date__c == null), OR (EZ_Pay_Down_Payment__c = 0),
ELSE (IF (EZ_Pay_Down_Payment__c >= Min_EZ_Pay_Down_Payment__c), AND (EZ_Pay_Payments__c <= Max_EZ_Pay_Payments__c)))
4 answers
Currently, EZ Pay validation rules are bypassed when a user manually signs a contract. The following validations should be enforced in this scenario:
• If Invoice Payment Method CONTAINS “EZ Pay” then use the following logic and user attempts to manual sign, the following validations should be in place:
o IF(EZ_Pay_Payments_c = 0 OR EZPay_Start_Datec == null OR EZ_Pay_Down_Payment_c = 0
Throw error = “If you are selecting EZ pay as a Payment Option, you must have EZ Pay Payments, EZ Pay Start Date and Down Payment amount all filled out prior to Quote conversion.”
o ELSE IF (EZ_Pay_Down_Payment_c >= Min_EZ_Pay_Down_Paymentc) AND (EZ_Pay_Paymentsc <= Max_EZ_Pay_Payments_c)
Throw error = “If you are selecting EZ pay as a Payment Option, you must have EZ Pay Payments, EZ Pay Start Date and Down Payment amount all filled out prior to Quote conversion.”
