function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Rung41Rung41 

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 )