+ 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
Neil CummingsNeil Cummings
Information Transformation Services is endowing the clients with a stunning and impressive visual experience crafted by 3D Modeling Services. We are completely forted to offers our customers with a range of appealing 3D designs that are carefully crafted to meet with all type of requirements