• Thalie
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

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