Skip to main content
Topics#Data ManagementQuestion de Carl Lange
Carl Lange (Self) a posé une question dans #Data Management
25 août 2015, 21:20

IF statement followed by >

I need a formula that incorporates an IF statement. If the larger of field A and field B is within a specific dollar range, then something will trigger in Process Builder. The IF portion of my formula is not working. Field A is "Credit_c" and Field B "Debit_c"

 

AND(

 

IF([Opportunity].Credit__c >[Opportunity].Debit__c,[Opportunity].Credit__c,[Opportunity].Debit__c) > 100000,

 

IF([Opportunity].Credit__c >[Opportunity].Debit__c,[Opportunity].Credit__c,[Opportunity].Debit__c) <= 250000,

 

[Opportunity].RDC__c >= 1,

 

[Opportunity].RDC__c <= 250000,

 

[Opportunity].Submit__c

 

)

 

Thanks!
11 réponses
  1. Chris Duncombe (Imprivata)
    26 août 2015, 00:15
    Try this out

     

     

    AND(
         MAX(Credit__c, Debit__c) > 100000,
         MAX(Credit__c, Debit__c) <= 250000,
         RDC__c >= 1,
         RDC__c <=250000,
         Submit__c = true
    )

     

     
Rédiger une réponse...
0/9000