# MOD

Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.

## Syntax

```
MOD(<number>, <divisor>)
```

### Parameters

Term | Definition |
---|---|

number | The number for which you want to find the remainder after the division is performed. |

divisor | The number by which you want to divide. |

## Return value

A whole number.

## Remarks

If the divisor is 0 (zero), MOD returns an error. You cannot divide by 0.

The MOD function can be expressed in terms of the INT function: MOD(n, d) = n - d*INT(n/d)

## Example 1

The following formula returns 1, the remainder of 3 divided by 2.

```
= MOD(3,2)
```

## Example 2

The following formula returns -1, the remainder of 3 divided by 2. Note that the sign is always the same as the sign of the divisor.

```
= MOD(-3,-2)
```

## See also

Math and Trig functions

ROUND function

ROUNDUP function

ROUNDDOWN function

MROUND function

INT function

## Feedback

Submit and view feedback for