Predefined Calculation: Value of A, or value of B if A is empty
This formula can be used to provide a fallback value if a question is not answered. It is particularly useful when working with internal only fields - if A is internal only, B will be the result of the formula on website submissions.
This formula requires 2 inputs:
- Field A - this value will be returned if it is present e.g the question was answered.
- Field B - this will be returned if field A is empty for the submission.
This formula returns:
|Value of Field A||If Field A has a value e.g. was answered.|
|Value of Field B||If Field A is empty.|
If field A has a value, this is the result.
If not, field B's value is the result.