**Algebraic Functions**

SeamlessDocs recognizes *order of operations*, so keep in mind that certain algebraic functions will execute before others. A great way to remember to order of operation is the acronym **PEMDAS**:

**P**arentheses → **E**xponents → **M**ultiplication → **D**ivision → **A**ddition → **S**ubtraction

Regardless of the arrangement of the algebraic expression from left to right, functionality related to parentheses is always going to come before exponents, which is going to come before multiplication, and so on.

**“ROUND” Function**

By adding the function “ROUND” directly before the formula, the end value will round to whatever number of decimal places you set. The format will look like this f=ROUND(Cell Label or formula, # of Decimal places set):

**Make sure to put an open parenthesis after the word *“ROUND”.

**“DOLLAR” Formatting**

In a SeamlessDoc, you can add the function “DOLLAR” by selecting *Dollars* under special formatting, when you click on a field’s settings (**see image below**). All fields that make use of the *Dollars* formatting will appear with a USD dollar sign, applicable commas, and two figures for cents.

For the EXACT text function the output field will say True or False depending on whether the fields match or don't match respectively.

**Logical Functions**

**IF/THEN Statements**

All IF/THEN Statements should be formatted as follows:

IF (Condition, Value if True, Value if False)

With the IF function, you can make a logical comparison: Is the requested value identical to what you expect or not? If this query is true, then it triggers an action of your choice. If it’s false, it triggers a different action. Simply put: if A (Condition), then B (Value if True), otherwise C (Value if False).

You can use the greater than or less than operators: "<" and ">". We do not currently support the equals "=" operator.

Click here to review an IF/THEN Statement SeamlessDocs example.

**Date Functions**

**Extra Resources**

For the full list of available functions within SeamlessDocs, please click here.

SeamlessDocs Calculation Reference Form.

Click here to review WebForm Functions and Calculations.