ShowAll Questionssorted byDate Posted
Rung41

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