Skip to main content
Is it possible to do multiple indepdent if conditions in formula field. I need to calculate a numeric field based on multiple other fields. Here is what it looks like:

 

if field1 = "WA" add 1 to numericField;

 

if field2 = "CA" add 1 to numericField;

 

At the end of this, the numericField can either be 0, 1 or 2. Can this be done?
2 件の回答
  1. 2017年7月25日 0:07
    Try this.

     

    If (field1__c = "WA", 1, 0) +

     

    If (field2__c = "CA", 1, 0)