• Liz Carter
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
I'm trying to write a formula field on Opportunity object involving 2 fields - Amount, and a custom number field, License_Period_months__c. The goal is to calculate an amount based on 3 different scenarios of contract length:

Logic:
 
If
License_Period_months__c = 12, Amount
 
If
License_Period_months__c = 24, Amount * 2 * .15
 
If
License_Period_months__c = 36, Amount * 3 * .30

I am not sure of the correct way to write the formula involving the IF statements, as I keep getting errors. I'm attempting to do this on a formula (currency) field type on opp. thanks!
I'm trying to write a formula field on Opportunity object involving 2 fields - Amount, and a custom number field, License_Period_months__c. The goal is to calculate an amount based on 3 different scenarios of contract length:

Logic:
 
If
License_Period_months__c = 12, Amount
 
If
License_Period_months__c = 24, Amount * 2 * .15
 
If
License_Period_months__c = 36, Amount * 3 * .30

I am not sure of the correct way to write the formula involving the IF statements, as I keep getting errors. I'm attempting to do this on a formula (currency) field type on opp. thanks!