# Numeric Functions

Updated 2 years ago by dustin keir

## Numeric Functions

Use numeric functions to manipulate numeric values in formula user-defined fields and in rules for mandatory fields. You can add the following functions to formulas using numeric fields.

• Ceiling – Rounds a number up to the nearest integer or up to a specified number of decimal points.
• Floor – Rounds a number down to the nearest integer or down to a specified number of decimal points.
• Round – Rounds a number to the nearest integer or to a specified number of decimal points.

### Ceiling

Rounds a number up to the nearest integer or up to a specified number of decimal points.

#### Syntax

Ceiling(Number, DecPlace)

#### Parameters

 Parameter Data Type Description Number Decimal The numeric value to round. DecPlace Integer (Optional) The number of decimal places to round up to.

#### Example

`Ceiling(2.32, 1)`
• This example returns 2.4

### Floor

Rounds a number down to the nearest integer or down to a specified number of decimal points.

#### Syntax

Floor(Number, DecPlace)

#### Parameters

 Parameter Data Type Description Number Decimal The numeric value to round. DecPlace Integer (Optional) The number of decimal places to round down to.

#### Example

`Floor(2.36, 1)`
• This example returns 2.3

### Round

Rounds a number to the nearest integer or to a specified number of decimal points.

#### Syntax

Round(Number, DecPlace)

#### Parameters

 Parameter Data Type Description Number Decimal The numeric value to round. DecPlace Integer (Optional) The number of decimal places to round to.

#### Example

`Round(2.45687, 2)`
• This example returns 2.46.