Form -> Formula

## Formula

**Keywords**: Form; Formula
Formula is one of the form types in the CubeDrive. CubeDrive allows the user to define the formula in the field.
It is a concise way of expressing information symbolically. The flexible of formulas has many effects on data collection:

- It can improve the efficiency to fill the form, automatically calculate the data, and display the content
based on some logic.
- Reduce error in the calculate process.

### Setup formula

When creating a new form, you can drag the Formula field type from the field list and drop to the form design
center panel. You also need set the formula property on the right panel.

To setup a formula, you need enter the format with "=" start in the formula text field. The related information
will be popuped when you type the data.

#### Examples

- =${'Number'}*${'Number2'}*1.13
- =SUM(${'Number'},${'Number2'})
- =PRODUCT(${'Number'},${'Currency'})
- =INT(YEARFRAC(${'birthdate'},TODAY()))
- =IF(${'Number'}>12, "Teenager", "Kid")

### Functions

Here lists the supported formulas at this moment.

- + - * /

Syntax: **=(${'Number'}+${'Number2'})*1.1**

User + - * / to process the basic math calculation.
- ABS

Syntax: **=ABS(${'Number'})**

Returns the absolute value of the given number.
- AVERAGE

Syntax: **=AVERAGE(${'Number'},${'Number2'}, ...)**

Returns the average of the arguments. Number1, number2, ... are numerical values or ranges. Text is ignored.
- CONCATENATE

Syntax: **=CONCATENATE(${'text1'},${'text2'}, ...)**

Combines several text strings into one string.
- DEGREES

Syntax: **=DEGREES(${'Number'})**

This function converts radians into degrees.
- EXP

Syntax: **=EXP(${'Number'})**

Returns a Double specifying e (the base of natural logarithms) raised to a power.
- IF

Syntax: **=IF(${'Number'}>12, "Teenager", "Kid")**

Returns one value if a condition evaluates to TRUE and another value if it evaluates to FALSE. .
- INT

Syntax: **=INT(${'Number'})**

Rounds a number down to the nearest integer.
- MAX

Syntax: **=MAX(${'Number'},${'Number2'}, ...)**

Returns the max of the arguments. Number1, number2, ... are numerical values or ranges.
- MIN

Syntax: **=MIN(${'Number'},${'Number2'}, ...)**

Returns the min of the arguments. Number1, number2, ... are numerical values or ranges.
- PRODUCT

Syntax: **=PRODUCT(${'Number'},${'Number2'}, ...)**

Returns the multiple of corresponding array numbers
- RADIANS

Syntax: **=RADIANS(${'angle'})**

Converts degrees to radians.
- RAND

Syntax: **=RAND()**

Returns a random number between 0 and 1.
- SQRT

Syntax: **=SQRT(${'Number'})**

Returns a positive square root.
- SQRTPI

Syntax: **=SQRTPI(${'Number'})**

Returns a positive square root of (number * pi).
- SUM

Syntax: **=SUM(${'Number'},${'Number2'}, ...)**

Returns the sum of corresponding array numbers
- SUMPRODUCT

Syntax: **=SUMPRODUCT(${'Number'},${'Number2'},...)**

Product all numbers in a range of items.
- TODAY

Syntax: **=TODAY()**

Returns the current computer system date. TODAY is a function without arguments.
- YEARFRAC

Syntax: **=YEARFRAC(${'birthdate'},TODAY())**

Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). Use the YEARFRAC worksheet function to identify the proportion of a whole year's benefits or obligations to assign to a specific term.

« PDF Form
Custom Drop-down List »