# Help Centre

Equation editor
Functions in Analyse
Valid operators in the equation editor:
+
plus

-
minus

/
divide

*
multiply

^
exponent

=
equals

!=
not equals

>
greater than

<
less than

>=
greater than or equal to

<=
less than or equal to
Standard syntax must be followed for the equation editor to function. Quantemplate automatically inserts correct syntax where possible.
' '

" "
IF(...)
,
and lozenged if validated.
double quotes for categorical values in your data, eg ‘Region’=“America”
Comma must follow field or value in the function
Functions
IF
Checks whether a condition is met and returns one value if TRUE, and another value if FALSE.
``IF(logical_query,value_if_true,value_if_false)``
Examples of logical queries:
``````'Line_of_Business'="Property"
'Region'="Americas"
'Claim'>1000000``````
Examples
If the Line of Business is Property, then multiply premium by 1.2. If it is not Property do nothing.
``IF('Line_of_Business' = "Property", 'Premium' * 1.2, 'Premium')``
Using and/or in IF statements
And statement
``````IF('Column 1' > 'Column 2' and 'Column 3' < 'Column 4',
value_if_true, value_if_false)``````
Or statement
``````IF('Column 1' > 'Column 2' or 'Column 3' < 'Column 4',
value_if_true, value_if_false)``````
Combined statement
``````IF((('Column 1' > 'Column 2' or 'Column 1' < 'Column 5')
and ('Column 3' < 'Column 4')), value_if_true, value_if_false)``````
IFERROR
Returns parameter 2 if the calculation of parameter 1 generates an error.
``IFERROR(parameter_1,parameter_2)``
Example
If the calculation ‘claim_amount / claim_count’ generates an error, return the value 0.
``IFERROR('claim_amount/claim_count',0)``