Advanced Formula: Operators

December 22, 2022

Advance Formula in Jotform Tables has two types of operators: the basic operators and the logical operators.

Basic Operators

The basic operators in Advanced Formula are used with values — either referenced to a column or manually entered — to perform common operations, such as addition, subtraction, multiplication, etc.

Examples:

  • =5+2 will evaluate to 7.
  • ="one"&"-"&"half" will return one-half.
  • =5+4-3/2*1&"%" will output to 7.5%.

The following table contains the list of basic operators that you can use in Jotform Tables:

Operator Description
& Concatination operator.
For example, ="Hello"&" "&"world" will return Hello world.
+ Addition operator.
For example, =10+2 will evaluate to 12.
Subtraction operator.
For example, =10-2 will evaluate to 8.
/ Division operator.
For example, =10/2 will evaluate to 5.
* Multiplication operator.
For example, =10*2 will evaluate to 20.
, Augment operator. Used as a delimiter to separate arguments in a function.
For example, =SUBSTITUTE("Sunday","day","").

Logical Operators

In Jotform Tables, logical operators (also known as comparison operators) can be used like basic operators to create logical expressions for comparing values. An expression returns TRUE if it’s correct and FALSE if not.

Examples:

  • =5>3 will return TRUE.
  • =5+3=8 will return TRUE.
  • ="Apples"="Oranges" will return FALSE.
  • ={Number}>0 will return TRUE if the Number column’s value is greater than 0 and FALSE otherwise.
  • ={Answer}="Yes" will return TRUE if the Answer column’s value is “Yes” and FALSE if not.

Note: In Jotform Tables, TRUE (bool) outputs either 1 or “true”, while FALSE (bool) outputs either 0 or an empty string.

Here’s the list of logical operators you can use in Jotform Tables:

Operator Description
> Greater than
>= Greater than or equal to
< Less than
<= Less than or equal to
= Equal

Logical expressions are often used with Logical Functions. For example, =IF({Age}>=18,"Approved","Denied") will return Approved if the Age column’s value is greater than or equal to 18 and Denied otherwise. For more information, see: Logical Functions

Seel also:

END OF YEAR SALE
Save 50%

ON ANNUAL JOTFORM PLANS

Offer does not apply to Jotform Enterprise

Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments:

  • MD HAIRUDIN BIN SABUDIN - Profile picture