Translations:Documentation/Calc Functions/MOD/18/en
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 |