You need to sign in to do that
Don't have an account?
Formula - Receiving an error on IsPickVal Formula
I am adding this formula to GST/HST field. I have a picklist (Province_for_tax_calculation) with values ON,BC,NB etc.
I have another field called Amount Payable which needs to be calculated based on the picklist value selected. The formula below is not working. Any ideas?
IF(
OR(
ISPICKVAL(Province_for_tax_calculation__c, "ON"),
ISPICKVAL(Province_for_tax_calculation__c, "BC"),
ISPICKVAL(Province_for_tax_calculation__c, "NB"),
ISPICKVAL(Province_for_tax_calculation__c, "NS"),
ISPICKVAL(Province_for_tax_calculation__c, "NL"),
ISPICKVAL(Province_for_tax_calculation__c, "PEI"),
ISPICKVAL(Province_for_tax_calculation__c, "QC")),
"Amount_Payable__c *0.13,0",
"Amount_Payable__c *0.12,0",
"Amount_Payable__c *0.13,0",
"Amount_Payable__c *0.15,0",
"Amount_Payable__c *0.13,0",
"Amount_Payable__c *0.14,0",
"Amount_Payable__c *0.149,0"
)