Skip to main content
Topics#Data ManagementLEAH Gus's Question
LEAH Gus (Gus) asked in #Data Management
Oct 5, 2017, 7:47 PM

I need a formula that caculates a different percentage of a field based on what state is in state field

I need a formula that will calculate 5.5% of the value in the taxable amount filed if Maine is in the billing state field, 7% of taxable amount if Vermont is in the billing state field and 6.25% if Massachusetts in the billing state field.

 

here's what I have

 

(  Billing_State__c   = Maine)  Taxable_Amount__c  *0.055, 

 

( Billing_State__c  = Vermont), Taxable_Amount__c *0.07, 

 

( Billing_State__c  = Massachusetts), Taxable_Amount__c *0.0625

 

0)))

 

I also tried 

 

IF (  Billing_State__c , " Maine")  Taxable_Amount__c  *0.055, 

 

IF( Billing_State__c , "Vermont"), Taxable_Amount__c *0.07, 

 

IF ( Billing_State__c , "Massachusetts"), Taxable_Amount__c *0.0625,

 

0)))

 

 
7 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Oct 5, 2017, 8:14 PM

    all set

    Taxable_Amount__c  *
    CASE(Billing_State__c ,
    "Maine",0.055, 
    "Vermont", 0.07, 
    "Massachusetts", 0.0625,
    0)

     

     
Write an answer...
0/9000