function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
learn_sfdclearn_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
Best Answer chosen by learn_sfdc
Alain CabonAlain 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

All Answers

Alain CabonAlain 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_sfdclearn_sfdc
Hi Alain, 

still its not working...
learn_sfdclearn_sfdc
Hi Alain, 

Sorry, its working fine... Thank you...
Jailor BoyJailor Boy
Once try https://leonflix.info for watch movies and TV hows
Sarkari YojanaSarkari 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 meebhoomi mee
i am use meebhoomi (http://meebhoomi.online) for fin property records in andhra pradesh this is best for find property in AP