---
title: Math
slug: hyper-portal/math
docTags: 
createdAt: 2023-02-23T11:00:04.000Z
---

### [ABS](https://hyperportal.help/#/content/computed-expressions?id=abs)

Returns the absolute value of a number.

**Syntax**

`ABS(value)`

- value: The number of which to return the absolute value.

**Sample Usage**

`ABS(-2)`

`ABS(property)`

### [EXP](https://hyperportal.help/#/content/computed-expressions?id=exp)

Returns Euler's number, e (\~2.718) raised to a power.

**Syntax**

`EXP(exponent)`

- exponent: The exponent to raise e to.

**Sample Usage**

`EXP(2)`

`EXP(property)`

### [POWER or POW](https://hyperportal.help/#/content/computed-expressions?id=power-or-pow)

Returns a number raised to a power. Equivalent to the "^" operator.

**Syntax**

`POWER(base, exponent) or POW(base, exponent)`

- base: The number to raise to the exponent power. If base is negative, exponent must be an integer.
- exponent: The exponent to raise base to.

**Sample Usage**

`POWER(4, 0.5)`

`POWER(property1, property2)`

`POWER(2, 5)`

### [ROUND](https://hyperportal.help/#/content/computed-expressions?id=round)

Returns the number rounded to the nearest integer.

**Syntax**

`ROUND(value)`

- value: The number to round.

**Sample Usage**

`ROUND(1.5)`

`ROUND(0.5)`

### [CEIL](https://hyperportal.help/#/content/computed-expressions?id=ceil)

Always rounds a number up to the next largest integer.

**Syntax**

`CEIL(value)`

- value: The number to round.

**Sample Usage**

`CEIL(1.5)`

`CEIL(0.5)`

### [FLOOR](https://hyperportal.help/#/content/computed-expressions?id=floor)

Returns the largest integer less than or equal to a given number

**Syntax**

`FLOOR(value)`

- value: The number to round.

**Sample Usage**

`FLOOR(1.5)`

`FLOOR(0.5)`

### [MINUS](https://hyperportal.help/#/content/computed-expressions?id=minus)

Returns the difference of two numbers. Equivalent to the "-" operator.

**Syntax**

`MINUS(value1, value2)`

- value1: The minuend, or number to be subtracted from.
- value2: The subtrahend, or number to subtract from value1.

**Sample Usage**

`MINUS(property1, property2)`

`MINUS(3, 4)`

### [PRODUCT](https://hyperportal.help/#/content/computed-expressions?id=product)

Returns the result of multiplying a series of numbers together.

**Syntax**

`PRODUCT(factor1, [factor2, ...])`

- factor1: The first number or range to calculate for the product.
- factor2, ... - \[OPTIONAL]: Additional values to multiply by.

**Sample Usage**

`PRODUCT(numberList)`

`PRODUCT(1, 2, 3, number, numberList)`

**Notes**

- If only a single number for factor1 is supplied, PRODUCT returns factor1.
- Each factor may be a number or a range. If a list, empty values are ignored.

### [ROUND](https://hyperportal.help/#/content/computed-expressions?id=round-1)

The ROUND function rounds a number to a certain number of decimal places according to standard rules.

**Syntax**

`ROUND(value, [places])`

- value - The value to round to places number of places.
- places - \[ OPTIONAL - 0 by default ] - The number of decimal places to which to round. Places may be negative, in which case value is rounded at the specified number of digits to the left of the decimal point.

**Sample Usage**

`ROUND(826.645, 0) // = 827`

`ROUND(826.645) // = 827`

`ROUND(826.645, 1) // = 826.6`

`ROUND(826.645, 2) // = 826.65`

`ROUND(826.645, 3) // = 826.645`

`ROUND(826.645, -1) // = 830`

`ROUND(826.645, -2) // = 800`

**Notes**

- Standard rules indicate that when rounding to a particular place, the next most significant digit (the digit to the right) is considered. If this digit is greater than or equal to 5, the digit is rounded up, otherwise it is rounded down. This occurs irrespective of sign; that is, 'up' and 'down' are in terms of magnitude.

### [SUM](https://hyperportal.help/#/content/computed-expressions?id=sum)

Returns the sum of a series of numbers and/or numbers.

**Syntax**

`SUM(value1, [value2, ...])`

- value1: The first number or range to add together.
- value2, ... - \[OPTIONAL]: Additional numbers or ranges to add to value1.

**Sample Usage**

`SUM(listOfNumbers)`

`SUM(1, 2, 3, number, listOfNumbers)`

**Notes**

- If only a single number for value1 is supplied, SUM returns value1.

### [DIVIDE](https://hyperportal.help/#/content/computed-expressions?id=divide)

Returns one number divided by another. Equivalent to the "/" operator.

**Syntax**

`DIVIDE(dividend, divisor)`

- dividend: The number to be divided.
- divisor: The number to divide by (cannot equal 0).

**Sample Usage**

`DIVIDE(4, 2)`

`DIVIDE(number1, number2)`

### [N](https://hyperportal.help/#/content/computed-expressions?id=n)

Returns the argument provided as a number.

**Syntax**

`N(value)`

- value: The argument to be converted to a number
- If value is TRUE, the result is 1
- If value is FALSE, the result is 0

**Sample Usage**

`N('12') => 12`

`N(12) => 12`

`N(TRUE) => 1`

`N(FALSE) => 0`