> For the complete documentation index, see [llms.txt](https://docs.adapptio.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.adapptio.com/reference-guide/functions/math.md).

# Math

### Round

Return a rounded number.

#### Expression:

**ROUND**(*value*: float)

#### Return:

*roundedValue*: float

#### Example of usage:

```javascript
ROUND(1.45)

Return value:
1
```

### Floor

Returns the rounded-down number.

#### Expression:

**FLOOR**(*value*: float)

#### Return:

*roundedValue*: float

#### Example of usage:

```javascript
FLOOR(1.45)

Return value:
1
```

### Ceil

Returns the rounded-up number.

#### Expression:

**FLOOR**(*value*: float)

#### Return:

*roundedValue*: float

#### Example of usage:

```javascript
CEIL(1.45)

Return value:
2
```

### To Fixed

Returns the number added to specified decimals.

#### Expression:

**TO\_FIXED**(*value*: float, *decimals*: integer)

#### Return:

*roundedValue*: float

#### Example of usage:

```javascript
TO_FIXED(123,3)

Return value:
123.000
```

### Min

*Returns a minimal numeric value from a series.*

#### Expression:

**MIN**(*value*: array)

#### Return:

*minimalValue*: float

#### Example of usage:

```javascript
MIN(11, 79, 82)

Return value:
11
```

### Max

*Returns a maximal numeric value from a series.*

#### Expression:

**MAX**(*value*: array)

#### Return:

*maximalValue*: float

#### Example of usage:

```javascript
MAX(11, 79, 82)

Return value:
82
```

### Format Number

*Returns a formatted number with specified decimal places, delimiter, and decimal point.*

#### Expression:

**FORMAT\_NUMBER**(*number*: float, *decimals*: integer, *delimiter*: string,  *decimalPoint*: string)

#### Return:

*formattedNumber*: string

#### Example of usage:

```javascript
FORMAT_NUMBER(12346734.12, 4, ".", ",")

Return value:
"12.346.734,1200"
```