You need to sign in to do that
Don't have an account?
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
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
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
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
still its not working...
Sorry, its working fine... Thank you...
Sarkari yojana (https://sarkariyojnaa.net/)
Payslip JK Police (https://sarkariyojnaa.net/jammu-kashmir-employee-payslip/)