You need to sign in to do that
Don't have an account?
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 ))))
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 ))))
All Answers