Sometimes you will want to add conditions to your formulas, for example you might want to use different calculations depending on what options in your form are selected.
if(Condition) operation else operation
The condition above will check the value of the dropdown, if the “Option 1” is selected the formula value will be 1, otherwise it will be 2.
The else section is optional, if you want you can create many conditions like this:
In the example above the formula value will be 1 if option 2 is selected, 2 if option 2 is selected or 3 if option 3 is selected.
You can also do arithmetical operations inside the conditions for more complex calculations: