Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rung41Rung41 

Assistance need to simplify formula

I am running into a complie error - Formula size is to big execute. Look for any assistance how I can simplify my formula. Thanks in advance!

IF(
(ISPICKVAL(Minimum_Lease_Terms__c,"3") || ISPICKVAL(Minimum_Lease_Terms__c,"4")),15.20, 
IF(
(ISPICKVAL(Minimum_Lease_Terms__c,"5") || ISPICKVAL(Minimum_Lease_Terms__c,"6") || ISPICKVAL(Minimum_Lease_Terms__c,"7")), 11.40, 
IF(
(ISPICKVAL(Minimum_Lease_Terms__c,"8") || ISPICKVAL(Minimum_Lease_Terms__c,"9")),7.60, 
IF
(ISPICKVAL(Minimum_Lease_Terms__c,"1") || (ISPICKVAL(Minimum_Lease_Terms__c,"2") ||(ISPICKVAL(Minimum_Lease_Terms__c,"10") || ISPICKVAL(Minimum_Lease_Terms__c,"11") || ISPICKVAL(Minimum_Lease_Terms__c,"12"))), 1.90, NULL ))))
Best Answer chosen by Rung41
Nayana KNayana K
CASE(Minimum_Lease_Terms__c,
"3", 15.20,
"4", 15.20
"5", 11.40,
"6", 11.40,
"7", 11.40,
"8", 7.60,
"9", 7.60,
"1", 1.60,
"2", 1.60,
"10", 1.60,
"11", 1.60,
"12", 1.60,
NULL)

 

All Answers

Nayana KNayana K
CASE(Minimum_Lease_Terms__c,
"3", 15.20,
"4", 15.20
"5", 11.40,
"6", 11.40,
"7", 11.40,
"8", 7.60,
"9", 7.60,
"1", 1.60,
"2", 1.60,
"10", 1.60,
"11", 1.60,
"12", 1.60,
NULL)

 
This was selected as the best answer
Rung41Rung41
Thank you. I gave it a try but I'm running into the same issue. I have formulas referencing formulas which I believe is causing the issue.