# MODΒΆ

Returns the remainder of given number after it was divided by specified divisor. The result has the same sign as divisor.

**Syntax**

=MOD(Number, Divisor)

**Arguments**

Name |
Description |
---|---|

Number |
The number for which the remainder should be calculated. |

Divisor |
The number by which the Number should be divided |

**Return Value**

The remainder of applied division. Note: it always has the same sign as divisor.

**Example**

Function |
Result |
Comment |
---|---|---|

=MOD(3, 2) |
1 |
Remainder of 3/2 |

=MOD(-3, 2) |
1 |
Same sign as divisor |

=MOD(3, -2) |
-1 |
Same sign as divisor |