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?