You need to sign in to do that
Don't have an account?
Optimize Formula Help
I got to imagine there is a more effcient way to compose my formula. Is there a way to reference "NOT(ISBLANK( Referred_By__c))" once instead of in each IF statement?
Thanks in advance!
IF( ISPICKVAL(Lease_Term__c, '1') && NOT(ISBLANK( Referred_By__c)), 75, IF( ISPICKVAL(Lease_Term__c, '2')&& NOT(ISBLANK( Referred_By__c)), 75, IF( (ISPICKVAL(Lease_Term__c, '3') && Amount < 500) && NOT(ISBLANK( Referred_By__c)), 200, IF( (ISPICKVAL(Lease_Term__c, '3') && Amount <= 899) && NOT(ISBLANK( Referred_By__c)), 325, IF( (ISPICKVAL(Lease_Term__c, '3') && Amount >= 900)&& NOT(ISBLANK( Referred_By__c)), 450, IF( (ISPICKVAL(Lease_Term__c, '6') && Amount < 500 && NOT(ISBLANK( Referred_By__c))), 275, IF( (ISPICKVAL(Lease_Term__c, '6') && Amount <= 899) && NOT(ISBLANK( Referred_By__c)), 400, IF( (ISPICKVAL(Lease_Term__c, '6') && Amount >= 900&& NOT(ISBLANK( Referred_By__c))), 525, IF( (ISPICKVAL(Lease_Term__c, '9') && Amount < 500)&& NOT(ISBLANK( Referred_By__c)), 275, IF( (ISPICKVAL(Lease_Term__c, '9') && Amount <= 899) && NOT(ISBLANK( Referred_By__c)), 400, IF( (ISPICKVAL(Lease_Term__c, '9') && Amount >= 900)&& NOT(ISBLANK( Referred_By__c)), 525, IF( (CONTAINS("12:18:24:36",Text(Lease_Term__c)) && Amount < 500) && NOT(ISBLANK( Referred_By__c)), 325, IF( (CONTAINS("12:18:24:36",Text(Lease_Term__c)) && Amount <= 899) && NOT(ISBLANK( Referred_By__c)), 450, IF( (CONTAINS("12:18:24:36",Text(Lease_Term__c)) && Amount >= 900)&& NOT(ISBLANK( Referred_By__c)), 575,NULL))))))))))))))
Thanks,
Ramesh D
All Answers
Thanks,
Ramesh D