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 answers