ShowAll Questionssorted byDate Posted
Rung41

# 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 ))))
Nayana 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)```

Nayana 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
Rung41
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.