You need to sign in to do that
Don't have an account?
Currency Formula help
I'm having some trouble creating a formula that looks at two sets of criteria to set a currency value. The first set of criteria works fine but when I try to add an additional AND statement, it throws an error. Any and all feedback as to what I am doing wrong is appreciated.
IF( AND( NOT(ISBLANK( Referred_By__c)), TEXT( Referred_By__r.Receive_Referral_Incentives__c) <> 'No', ISPICKVAL(Account.Market_Segment__c, 'Apartment Community') || ISPICKVAL(Account.Market_Segment__c, 'Property Management' ), ISPICKVAL( Type__c ,'Individual')), IF(ISBLANK(Amount),0, IF((ISPICKVAL(Lease_Term__c, '1')&& Amount < 1500),0, IF((ISPICKVAL(Lease_Term__c, '1')&& Amount >= 1500),75, IF((ISPICKVAL(Lease_Term__c, '2')&& Amount < 750),0, IF((ISPICKVAL(Lease_Term__c, '2')&& Amount >= 750),75, IF((ISPICKVAL(Lease_Term__c, '3')&& Amount < Region_Minimums_Copy__c ),0, IF((ISPICKVAL(Lease_Term__c, '3')&& Amount >= Region_Minimums_Copy__c && Amount <= 499 ), 150, IF((ISPICKVAL(Lease_Term__c, '3')&& Amount >= 500 && Amount <= 899), 200, IF((ISPICKVAL(Lease_Term__c, '3')&& Amount >= 900), 250, IF((ISPICKVAL(Lease_Term__c, '6')&& Amount < Region_Minimums_Copy__c),0, IF((ISPICKVAL(Lease_Term__c, '6')&& Amount >= Region_Minimums_Copy__c && Amount <= 499 ), 250, IF((ISPICKVAL(Lease_Term__c, '6')&& Amount >= 500 && Amount <= 899), 300, IF((ISPICKVAL(Lease_Term__c, '6')&& Amount >= 900),350, IF((ISPICKVAL(Lease_Term__c, '12')&& Amount < Region_Minimums_Copy__c), 0, IF((ISPICKVAL(Lease_Term__c, '12') && Amount >= Region_Minimums_Copy__c && Amount <= 499),350, IF((ISPICKVAL(Lease_Term__c, '12') && Amount >= 500 && Amount <= 899),400, IF((ISPICKVAL(Lease_Term__c, '12') && Amount >= 900), 450,0 ))))))))))))))))),0) IF( AND( ISPICKVAL(Account.Market_Segment__c, 'Apartment Community') || ISPICKVAL(Account.Market_Segment__c, 'Property Management' ), TEXT(Customer_Name__r.Receive_Referral_Incentives__c) <> 'No', ISPICKVAL( Type__c ,'In-house Corporate'),100,0),0 )