Condition can be included in the formula script
The syntax is as follows:
outcome1 if condition else outcome2
where outcome1 and outcome2 should follow the datatype of that field
Some useful arithmetic operators include:
Some useful comparison operators include:
Some useful logical operators include:
and
or