Advanced functions
You'll find these advanced functions listed on the right side panel of the Calculator's formula builder. A short description is displayed as well when hovering above an operator on the side panel.
Name  Description  Syntax Example 
MAX  Returns the largest of all input numbers  MAX(Q1,Q2,5,...) 
MIN  Returns the smallest of all input numbers  MIN(Q1,Q2,5,...) 
ROUND  Rounds input numbers to decimal places  ROUND(number,precision) 
POW  Power of / exponent function  POW(number,exponent) 
RAND  Returns a random number from a specified range  RAND(min,max,precision) 
FLOOR  Returns the next lowest integer value by rounding down  FLOOR(1.12345) 
CEIL  Returns the next highest integer value by rounding up  CEIL(1.12345) 
ROOT  Square root (โ) of a number  ROOT(Q1) 
LOG  Base 2 logarithm of a number  LOG(Q1,10) 
LOG10  Base 10 logarithm of a number  LOG10(Q1) 
LN  Natural logarithm of a number  LN(Q1) 
COUNT  Function to check how many files were uploaded. Can only be used with File Upload elements.  COUNT(Q1) 
DAYS  Function to calculate how many days are in the range of two dates (including both dates). Can only be used with Date & Time elements.  DAYS(Q1,Q2)

Conditional logic operators:
Name  Description  Syntax Example 
IF/THEN  Conditional Logic  IF(condition, then case, else case) 
The conditions below can only be used inside the first parameter of an IF function:
Symbol  Description  Syntax Example  Example Result 
>  Greater than  Q1>1  Is true if Q1 is greater than one 
<  Smaller than  Q1<1  Is true if Q1 is smaller than on 
>=  Equals or greater than  Q1>=1  Is true if Q1 is greater than one or equals one 
>=  Equals or smaller than  Q1<=1  Is true if Q1 is smaller than one or equals one 
<>  Is different than / is not (negation)  Q1<>5  Is true if Q1 is not 5 
=  Equals to  Q1=5  Is true if Q1 is 5 
AND  Logical operator that combines two conditions. Is true if both conditions are true  AND(Q1>1,Q1<10)  Is true of Q1 is greater than 1 and Q1 is smaller than 10 
OR  Logical operator that combines two conditions. Is true when one of two conditions is true  OR(Q1<5,Q1>10)  Is true of Q1 is smaller than 5 or Q1 is greater than 10 
ANSWERED  Function to check if the question was answered  ANSWERED(Q1)  Is true if Q1 was answered 
NOT  Function to check if the negation of a value is true  NOT(Q1)  Is true if Q1 is false 
CHECKED  Function to assert if an Optin Checkbox element was CHECKED, meaning the checkbox was ticked.  CHECKED(Q1)  Is true if Q1 was ticked (and Q1 is an Optin checkbox element). 
CONTAINS  Function to check if a Free Text Input element contains text (in full or partially).  CONTAINS(Q1,"needle")  Is true if Q1 contains the text "needle" (and Q1 is a Free Text Input element which collects text input). Can be nested to be negated: NOT(CONTAINS(Q1,"needle")) 
BEFORE  Function to check if a Date&Time element was answered with a value before a given date/time.  BEFORE(Q1,"20230101")  Is true if Q1 was answered with a date earlier than "20230101" (and Q1 is a Date&Time element. 
AFTER  Function to check if a Date&Time element was answered with a value after a given date/time.  AFTER(Q1,"20230101")  Is true if Q1 was answered with a date later than "20230101" (and Q1 is a Date&Time element. 
PAST  Function to check if a Date&Time element was answered with a value in the past (at the time of evaluation).  PAST(Q1)  Is true if Q1 was answered with a date earlier than now (and Q1 is a Date&Time element). 
FUTURE  Function to check if a Date&Time element was answered with a value in the future (at the time of evaluation).  FUTURE(Q1)  Is true if Q1 was answered with a date later than now (and Q1 is a Date&Time element). 
NOW  Function returns current Date&Time.  NOW()  BEFORE(Q1,NOW()) is true if Q1 is a date earlier dan the current date. 
These advanced functions will allow you to build more customized calculations. You'll find some example formulas for different use cases below:
Quantity dependent shipping price calculator
Calculator formula: =IF(Q2>5,Q1*Q2+10,IF(Q2>3,Q1*Q2+5,Q1*Q2+2))
Where Q1 is the price of the selected item, and Q2 is the quantity of the items ordered.
In the example above, two nested IF functions are used to check for the quantity ordered.
The leftmost IF function checks if there are more than 5 items in the order. If true, $10 will be charged for shipping, which is added to the ordered products' price. If the condition isn't true (less than 6 items ordered), the nested IF function checks if the amount of items is more than 3, in which case $5 will be charged for shipping. If the nested IF function's condition isn't true, the else case will be calculated, which charges $2 for shipping.
Coupon code checker
Calculator formula: IF(CONTAINS(Q2,'COUPONCODE'),Q1*0.8,Q1)
Where Q1 is the price of the selected product, and Q2 is the coupon code entered by the participant.
In the example above, the CONTAINS function checks if Q2 includes the predefined text, which is COUPONCODE in this case. If a match is found, the formula applies a 20% discount to the chosen product's value (achieved by the multiplication with 0.8).
If no match is found, the calculator's output will be the full value of the chosen product (Q1).
You'll find more use case examples in our blog post.