Is it possible to use conditional statements and values from multiple fields in calculation formulas? For example, say I have a number field called calc1, and I apply a formula to it. I want the value to be calculated based on what was answered in previous questions q1 and q2:
calc1 = 2 if (q1==yes AND q2==yes)
calc1=1 if (q1==yes OR q2==yes)
Thanks in advance.