---
title: "Arithmetic Functions"
url: "https://helpcentre.esayworkmobile.co.uk/en/article/arithmetic-functions"
language: "en"
last_updated: "2025-06-12T13:06:49.141Z"
---

# Arithmetic Functions

The following section describes each available arithmetic function, it's associated syntax and examples of how to use each.

### **ABS**

Takes a number and returns it's absolute value by ignoring it's sign, therefore negative numbers are returned as positive.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| ABS(*n*) | *n* is a number | a number |

| **Example** | **Result** |
| --- | --- |
| \=ABS(17) | 17 |
| \=ABS(-24) | 24 |
| \=ABS(0) | 0 |

* * *

### **DEGREES**

Converts a value representing radians into degrees.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| DEGREES(*angle*) | *angle* is a number | a number |

| **Example** | **Result** |
| --- | --- |
| DEGREES(2) | 65.408440973835 |

* * *

### EVEN

Round the supplied value *n* to the next even number. Rounds away from zero, so up for positive numbers and down for negative numbers.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| EVEN(*n*) | *n* is a number | A number |

| **Example** | **Result** |
| --- | --- |
| \=EVEN(8) | 8 |
| \=EVEN(7) | 7 |
| \=EVEN(-7) | \-8 |

* * *

### **INT**

Rounds the supplied value *n* down.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| INT(*n*) | *n* is a number | number |

| **Example** | **Result** |
| --- | --- |
| \=INT(37) | 37 |
| \=INT(37.8) | 37 |

* * *

### MAX

Returns the maximum value of two supplied numbers.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| MAX(*m, n*) | *m* is a number  <br>*n* is a number | a number |

| **Example** | **Result** |
| --- | --- |
| \=MAX(14, 19) | 19 |
| \=MAX(-14, -19) | \-14 |

* * *

### **MIN**

Returns the minimum value of two supplied numbers.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| MIN(*m, n*) | *m* is a number  <br>*n* is a number | a number |

| **Example** | **Result** |
| --- | --- |
| \=MIN(14, 19) | 14 |
| \=MIN(-14, -19) | \-19 |

* * *

### **MOD**

Returns the remainder as a result of dividing *m* by *n*. It is not possible to divide by zero.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| MOD(*m, n*) | *m* is a number  <br>*n* is a number | a number |

| **Example** | **Result** |
| --- | --- |
| \=MOD(124, 10) | 4 (124/10 gives 12 with a remainder of 4) |
| \=MOD(124, 0) | Error! |

* * *

### **MROUND**

Rounds the supplied value *n* to the nearest multiple of *m*. *n* and *m* must both be positive or both negative, or the result is always zero.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| MROUND(*m, n*) | *m* is a number  <br>*n* is a number | a number |

| Example | Result |
| --- | --- |
| \=MROUND(14, 5) | 15 |
| \=MROUND(16, 5) | 15 |
| \=MROUND(-14, -15) | \-15 |
| \=MROUND(-14, 5) | 0 |

* * *

### **ODD**

Rounds the supplied value *n* to the next odd number. Rounds away from zero, so up for positive numbers and down for negative numbers.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| ODD(*n*) | *n* is a number | A number |

| **Example** | **Result** |
| --- | --- |
| \=ODD(8) | 9 |
| \=ODD(7.1) | 9 |
| \=ODD(-7.1) | \-9 |

* * *

### **PI**

Returns the value of Pi.

| **Syntax** | **Result** |
| --- | --- |
| PI() | A number |

| **Example** | **Result** |
| --- | --- |
| \=PI() | 3.1415729 |

* * *

### **POWER**

Returns a result of the supplied values *m* to the power *n (m^n).*

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| POWER(*m, n*) | *m* is a number  <br>*n* is a number | A number |

| Example | Result |
| --- | --- |
| \=POWER(3, 3) | 27 |

* * *

### **PRODUCT**

Returns the product of the supplied values *m* and *n* (*m\*n*).

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| PRODUCT(*m, n*) | *m* is a number  <br>*n* is a number | A number |

| Example | Result |
| --- | --- |
| \=PRODUCT(3, 4) | 12 |

* * *

### **QUOTIENT**

Returns the whole number element from dividing *m* by *n*. It is not possible to divide by zero.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| QUOTIENT(*m, n*) | *m* is a number  <br>*n* is a number | A number |

| **Example** | **Result** |
| --- | --- |
| \=QUOTIENT(124, 10) | 12 |
| \=QUOTIENT(124, 0) | Error! |

* * *

### **RADIANS**

Converts the supplied numeric value from degrees to radians.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| RADIANS(*angle*) | *angle* is a number | A number |

| **Example** | **Result** |
| --- | --- |
| \=RADIANS(180) | 3.1415927 |

* * *

### **ROUND**

Rounds *n* to *p* decimal places. If *p* is positive, digits are counted to the right of the decimal point. If *p* is negative, they count to the left of the point.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| ROUND(*n, p*) | *n* is a number  <br>*p* is a number | A number |

| **Example** | **Result** |
| --- | --- |
| \=ROUND(1254.258, 2) | 1254.26 |
| \=ROUND(1254.258, -2) | 1300 |

* * *

### **SIGN**

Used to find the sign of *n*. Result is -1 if *n* is negative, +1 if *n* is positive or 0 if *n* is zero.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| SIGN(*n*) | *n* is a number | A number |

| **Example** | **Result** |
| --- | --- |
| \=SIGN(48.542) | 1 |
| \=SIGN(3 - 3) | 0 |
| \=SIGN(-957.2) | \-1 |

* * *

### **SQRT**

Computes the square root of *n*. Note that negative numbers have no real square root.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| SQRT(*n*) | *n* is a number | A number |

| Example | Result |
| --- | --- |
| \=SQRT(9) | 3 |
| \=SQRT(0) | 0 |
| \=SQRT(-9) | Error! |

* * *

### **TRUNC**

Truncates the fractional part from *n*, leaving a whole number. Rounds towards zero, so positive numbers round down, and negative numbers round up.

| **Syntax** | **Where** | **Result** |
| --- | --- | --- |
| TRUNC(*n*) | *n* is a number | A number |

| **Example** | **Result** |
| --- | --- |
| \=TRUNC(37) | 37 |
| \=TRUNC(36.9) | 36 |
| \=TRUNC(-36.9) | \-36 |