• Sarkari Yojana
  • NEWBIE
  • 0 Points
  • Member since 2020

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

Im using below formula to populate the values based term estimate months field, it calculates till 83 but if its beyond 83 then it doesn calculate, can you please help me where im going wrong

IF(Team_Value__c!=0,Team_Value__c, 
IF(Opportunity.Estimate_Months__c < 12, SellPrice * 0, 
IF(AND(12 <= Opportunity.Estimate_Months__c,Opportunity.Estimate_Months__c <=35), SellPrice * 1, 
IF(AND(36 <= Opportunity.Estimate_Months__c,Opportunity.Estimate_Months__c <=59), SellPrice * 2, 
IF(AND(60 <= Opportunity.Estimate_Months__c,Opportunity.Estimate_Months__c <=83), SellPrice * 2.5, 
IF(84 >= Opportunity.Estimate_Months__c,SellPrice * 3.0,0))))))

Thanks