Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ThalieThalie 

modification of the if (or, formulas for taxes exception

Hi this is the fomula i have for Canada taxes, it works fine but the taxes have changed today and I have to add a second exception for BillingStates= "BC" with 0.12 for taxes and I don't know how to do it

 

IF (OR ( BillingState = "NB", BillingState = "NS" , BillingState= "PEI", BillingState = "NL", BillingState = "ON") ,Sous_total__c *0.13 ,Sous_total__c *0.05)

 

 

Help

Thanks

tantotanto

Try this:

 

IF (
OR (
BillingState = "NB",
BillingState = "NS" ,
BillingState= "PEI",
BillingState = "NL",
BillingState = "ON") ,
Sous_total__c *0.13 ,
IF(
BillingState="BC",
Sous_total__c * 0.12,
Sous_total__c *0.05))
Pradeep_NavatarPradeep_Navatar

IF (OR ( BillingState = "NB", BillingState = "NS" , BillingState= "PEI", BillingState = "NL", BillingState = "ON") ,Sous_total__c *0.13 , IF(BillingState = "BC" ,Sous_total__c *0.12 ,Sous_total__c *0.05))

 

in case there are more than one states for second exception then change the formula to:

 

IF (OR ( BillingState = "NB", BillingState = "NS" , BillingState= "PEI", BillingState = "NL", BillingState = "ON") ,Sous_total__c *0.13 , IF(OR(BillingState = "BC" ,BillingState = "XX", ......),Sous_total__c *0.12 ,Sous_total__c *0.05))

 

Hope this helps.