Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
learn_sfdc

# Advanced Formula in formula field

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
Alain Cabon
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))))))

Regards

Alain Cabon
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))))))

Regards
This was selected as the best answer
learn_sfdc
Hi Alain,

still its not working...
learn_sfdc
Hi Alain,

Sorry, its working fine... Thank you...
Jailor Boy
Once try https://leonflix.info for watch movies and TV hows
Sarkari Yojana
Sarkari Yojana Site. You will get all indian govt schemes on this website and all thing you want.
Sarkari yojana (https://sarkariyojnaa.net/)
Payslip JK Police (https://sarkariyojnaa.net/jammu-kashmir-employee-payslip/)
bhoomi mee
i am use meebhoomi (http://meebhoomi.online) for fin property records in andhra pradesh this is best for find property in AP