# Documentation/Calc Functions/MOD

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

MOD

## Category:

Mathematical

## Summary:

This function returns **Dividend** modulo **Divisor**, that is the remainder when **Dividend** is divided by **Divisor**.

## Syntax:

MOD(**Dividend**; **Divisor**)

## Returns:

Returns a real number that is the remainder when one number, the **Dividend**, is divided by another number, the **divisor**.

## Arguments:

**Dividend** is a real number or a reference to the cell containing that number which will be the dividend the for MOD function.

**Divisor** is a real number or a reference to the cell containing that number which will be the divisor the for MOD function

If the **Divisor** is 0 then the function returns an error value.

## Additional details:

- This function is implemented as
**Dividend**-**Divisor*** INT(**Dividend**/**Divisor**), and this formula gives the result even if the arguments are not integer. - The sign of the result is the same as
**Divisor**.

## Examples:

Formula | Description | Returns |
---|---|---|

=MOD(11;2) | Remainder of 11/2 | 1 |

=MOD(-11;2) | Remainder of -11/2. The sign is the same as divisor. | 1 |

=MOD(11;-2) | Remainder of 11/-2. The sign is the same as divisor. | -1 |

=MOD(-11;2) | Remainder of -11/2. The sign is the same as divisor. | 1 |

=MOD(-11;-2) | Remainder of -11/-2. The sign is the same as divisor. | -1 |

=MOD(11.25;2.5) | Remainder of 11.25/2.5 | 1.25 |

=MOD(11;0) | function returns an error value since Divisor is 0 |
1.25 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

MOD